Troubleshooting
Problem
IBM Sterling Control Center shuts down after several hours of operation. It does this repeatedly and at more or less regular intervals.
Symptom
The engine log shows several errors like: "executeQuery - SQL Exception msg : The query has timed out".
..ultimately leading to...:
[InitCompProcCache-348-thread-1] ERROR RecoverableDAO - The query was executed 60 times for 36605 seconds. However, the engine did not succeed in performing the database operation, because of the following. Error :The query has timed out.
[InitCompProcCache-348-thread-1] ERROR RecoverableDAO - The query has timed out.
com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.
[InitCompProcCache-348-thread-1] ERROR SQLExceptionShutdownHandler - ** SQLExceptionShutdownHandler entered with sqlex=com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.
[InitCompProcCache-348-thread-1] ERROR SQLExceptionShutdownHandler - ** Event not updated or details on what was being done when error occurred -> The query has timed out.
[InitCompProcCache-348-thread-1] ERROR SQLExceptionShutdownHandler - The query has timed out.
com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.
[InitCompProcCache-348-thread-1] INFO SCCEngine - com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.
The Control Center Engine then shuts itself down because it has no reason to live without a working database connection.
[{"Product":{"code":"SS9GLA","label":"IBM Control Center"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Data management - Purge","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"5.4.0.1;5.4.0.2;5.4.1;5.4.2;5.4.2.1;6.0;6.0.0.1;6.1","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
17 December 2019
UID
swg21984099