It's all about the answers!

Ask a question

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"


Tariq Ashraf (251017) | asked Feb 01 '14, 3:29 a.m.
edited Feb 01 '14, 3:58 a.m.
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


Comments
Lily Wang commented Feb 03 '14, 7:27 p.m.

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.

One answer



permanent link
Stephanie Bagot (2.1k1513) | answered Feb 10 '14, 4:14 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
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


Register or to post 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.