For account security, your password must meet the following criteria: At least ten (10) characters, A lowercase letter, An uppercase letter, A number, A symbol, Does not include your username, Is not any of your last 4 passwords.
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.
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
Translated Content
Please note that this document is a translation from English, and may have been machine-translated. It is possible that updates have been made to the original version after this document was translated and published. Veritas does not guarantee the accuracy regarding the completeness of the translation. You may also refer to the English Version of this knowledge base article for up-to-date information.
Translated Content
Please note that this document is a translation from English, and may have been machine-translated. It is possible that updates have been made to the original version after this document was translated and published. Veritas does not guarantee the accuracy regarding the completeness of the translation. You may also refer to the English Version of this knowledge base article for up-to-date information.
