CLM 4.0.3 server shutdown unexpectedly and after restarting the server the (JTS database) is not able to connect and shows error "[IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004"
O/S : Windows 2008 R2
CLM : 4.0.3 WAS: WAS Network Deployment 8.0 DB2 : 9.7 Enterprise ============================================================ About DB2 Administration Tools Environment ============================================================ DB2 administration tools level: Product identifier SQL09073 Level identifier 08040107 Level DB2 v9.7.301.326 Build level s101006 PTF IP23214 ============================================================ Java development kit (JDK): Level IBM Corporation 1.6.0 ============================================================ My CLM server was shutdown due to electricity and UPS failure. Both application and DB are on the same server. After restarting the server, it is showing following error. When I checked the DB, JTS database is not able to connect but other database like CCM, QM and DW databases are connecting properly. When I am trying to connect the JTS DB it shows following error. [IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004 Explanation: A system error occurred. Some possible reasons for this error are: * The database manager is not installed correctly or the environment is not set up correctly. * On UNIX-based systems, db2iupdt may need to be run in order to update the DB2 instance to enable acquisition of a new system configuration or access to function associated with the installation or removal of certain product options, FixPaks, or modification levels. * You might get this message if you are not using the correct DB2 Administration Server password. The command cannot be processed. User response: * To update the instance to acquire a configuration or access to function run DB2IUPDT <InstName>. * If the error occurred while trying to connect to a database, get a trace (instructions below) and call IBM support. If the problem falls outside of the above suggestions, ensure that the system time and date is correctly set, and make sure your system has enough memory and swapping/paging space available. Resubmit the current command. If the error continues, stop the database manager and restart it. If the error still continues, reinstall the database manager. If trace was active, invoke the Independent Trace Facility at the operating system command prompt. Contact your technical service representative with the following information: Required information: * Problem description * SQLCODE or message number * SQLCA contents if possible * Trace file if possible. Federated system users: if necessary isolate the problem to the data source rejecting the request (see the Troubleshooting Guide for procedures to follow to identify the failing data source). If the problem is with a data source follow the problem determination procedures for that data source. sqlcode: -1042 sqlstate: 58004 [IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004 Explanation: A system error occurred. Some possible reasons for this error are: * The database manager is not installed correctly or the environment is not set up correctly. * On UNIX-based systems, db2iupdt may need to be run in order to update the DB2 instance to enable acquisition of a new system configuration or access to function associated with the installation or removal of certain product options, FixPaks, or modification levels. * You might get this message if you are not using the correct DB2 Administration Server password. The command cannot be processed. User response: * To update the instance to acquire a configuration or access to function run DB2IUPDT <InstName>. * If the error occurred while trying to connect to a database, get a trace (instructions below) and call IBM support. If the problem falls outside of the above suggestions, ensure that the system time and date is correctly set, and make sure your system has enough memory and swapping/paging space available. Resubmit the current command. If the error continues, stop the database manager and restart it. If the error still continues, reinstall the database manager. If trace was active, invoke the Independent Trace Facility at the operating system command prompt. Contact your technical service representative with the following information: Required information: * Problem description * SQLCODE or message number * SQLCA contents if possible * Trace file if possible. Federated system users: if necessary isolate the problem to the data source rejecting the request (see the Troubleshooting Guide for procedures to follow to identify the failing data source). If the problem is with a data source follow the problem determination procedures for that data source. sqlcode: -1042 sqlstate: 58004 [IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004 Explanation: A system error occurred. Some possible reasons for this error are: * The database manager is not installed correctly or the environment is not set up correctly. * On UNIX-based systems, db2iupdt may need to be run in order to update the DB2 instance to enable acquisition of a new system configuration or access to function associated with the installation or removal of certain product options, FixPaks, or modification levels. * You might get this message if you are not using the correct DB2 Administration Server password. The command cannot be processed. User response: * To update the instance to acquire a configuration or access to function run DB2IUPDT <InstName>. * If the error occurred while trying to connect to a database, get a trace (instructions below) and call IBM support. If the problem falls outside of the above suggestions, ensure that the system time and date is correctly set, and make sure your system has enough memory and swapping/paging space available. Resubmit the current command. If the error continues, stop the database manager and restart it. If the error still continues, reinstall the database manager. If trace was active, invoke the Independent Trace Facility at the operating system command prompt. Contact your technical service representative with the following information: Required information: * Problem description * SQLCODE or message number * SQLCA contents if possible * Trace file if possible. Federated system users: if necessary isolate the problem to the data source rejecting the request (see the Troubleshooting Guide for procedures to follow to identify the failing data source). If the problem is with a data source follow the problem determination procedures for that data source. sqlcode: -1042 sqlstate: 58004 ---------------------------------------------------------------------------------------------------------------------------------- I have restored the JTS DB through Log files but no luck. Does anyone know, What could be the issue? Thanks, Tariq Ashraf |
One answer
This looks like an issue with the DB driver per [CLI driver]. I searched the error and came across this technote.
http://www-01.ibm.com/support/docview.wss?uid=swg21424771 While not directly related, I would check the paths regardless and make sure they are OK as suggested in the technote. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
Hi Tariq,
Could you provide the errors in jts.log?
Is there any error in DB2 log db2diag.log? If the problem is in DB2, you can consult DB2 support.