Recreate TEMP and UNDO tablespace, Generate report with runtime error: IO Error: Socket read timed out while executing query

Problem

Generating report with runtime error : "IO Error: Socket read timed out while executing query"

This could be because portal server and/or Oracle database is busy or need more time to run the big query

Cause

Generating report with runtime error : IO Error: Socket read timed out while executing query. Steps to recreate TEMP and UNDO tablespace

Solution

Try one of these steps:

1) Reduce scope of the report selection by narrowing date range or smaller server group. If report is RTD, query may needs to be reviewed and optimized for better performance

2) Check the size of TEMP and UNDO tablespace. If any of these files is 32G then it needs to be recreated.

Linux: 

/data04/oradata/scdb/aptare_tbs_temp_01.dbf
/data05/oradata/scdb/aptare_tbs_undo_01.dbf

Windows:

<PATH_TO_ORACLE_DB_FILE>/oradata/scdb/

Example: D:/oradata/scdb/aptare_tbs_temp_01.dbf

Steps to recreate:

a. Shutdown Tomcat Portal and Tomcat Agent services
b. Run recreate scripts

Linux: 

su  -  aptare
cd /opt/aptare/database/tools
sqlplus  /  as  sysdba  @recreate_temp_unix.sql
sqlplus  /  as  sysdba  @recreate_undo_tbs.sql

Windows:

sqlplus  /  as  sysdba  @recreate_temp_win.sql
sqlplus  /  as  sysdba  @recreate_undo_windows.sql

b. Start up Tomcat Portal and Tomcat Agent services

3)  If the report just simply needs more time than the default 5mins , then make this change

a. Stop Tomcat Portal service
b. Edit /opt/aptare/portalconf/portal.properties  (Linux) or c:\opt\aptare\portalconf\portal.properties (Windows)

Change "db.connection.expiration=5"  to  a greater number in minutes

Example: db.connection.expiration=25

c. Start Tomcat Portal service

Applies To

All