cancel
Showing results for 
Search instead for 
Did you mean: 

Found SQL error -99999 occurred log entry in sm21

Former Member
0 Kudos

Hi Experts,

Today i have seen TIME_OUT ABAP Dump and relevant information for dump in st22

   The program "ZXX_REPORT" has exceeded the maximum permitted runtime

    without  interruption and has therefore been terminated.

Relevant SM21 Log entries for the dump are as below

SQL error -99999 occurred; work process in reconnect status

A database operation returned a return code that indicates that the

work process is no longer connected to the database, or that this

connection was broken for a while.

This error can occur, for example, if the database was shut down, but

not the SAP System. Network problems can also cause the connection

between the application server and the database server to be broken.

For initial information on the cause of the error, see the database

error text.

Work process has left reconnect status

The work process has left the reconnect status.  It has successfully

reconnected to the database (instance) and can now send database

requests to the database (instance).

Relevant information for dump  in dev_w0 work process log file as below


ThAlarmHandler (1)

ThAlarmHandler (1)

ThAlarmHandler: set CONTROL_TIMEOUT/DP_CONTROL_JAVA_EXIT and break sql

Received cancel request for current DB operation

SQLCancel() successfully processed -> DBSL_ERR_OK

db_sqlbreak() = 0

program canceled

   reason   = max run time exceeded

   user     = USER1

   client   = 100

   terminal = pc

   report   = ZXX_REPORT

ThAlarmHandler: return from signal handler

Execution cancelled in toplevel function: DbSlBegReadDB6

program canceled

   reason   = max run time exceeded

   user     = USER1

   client   = 100

   terminal = PC

   report   = ZXX_REPORT

*** ERROR in DB6EndTransaction[dbdb6.c, 6583] CON = 0 (BEGIN)

&+     DbSlRollbackDB6( SQLEndTran 😞 [IBM][CLI Driver] CLI0106E  Connection is closed. SQLSTATE=08003

&+

&+     ROLLBACK[DONT_KEEP_WITH_HOLD]

Kindly suggest on this issue with your valuable information.

Thanks,

Bharath.

Accepted Solutions (0)

Answers (1)

Answers (1)

Sriram2009
Active Contributor
0 Kudos

Hi Reddy

1. You may require to check the Z reports why its getting timeout? for this you can use the transaction code ST12. check the link http://scn.sap.com/docs/DOC-44143

2.  Could you check this SAP Note 1247697 - DB6: CLI0125E Function sequence error (SQL error -99999)


3. What is the Kernel version and level?


Regards

Ram

Former Member
0 Kudos

Hi Sriram,

Our kernel release is 700 with 201 patch level.

Thanks,

Bharath.

Sriram2009
Active Contributor
0 Kudos

Hi Bharaht

On NW 700 latest kernel 353 minimum 333 level it required 201 is very low

Regards

Ram