SAP Knowledge Base Article - Preview

2547756 - Dump DBIF_DSQL2_SQL_ERROR with SQL error "-60" or "600"

Symptom

ST22 reports the following short dump:

Category               Installation Errors
Runtime Errors         DBIF_DSQL2_SQL_ERROR
Except.                CX_SY_NATIVE_SQL_ERROR
Date and Time          XXXX.XX.XX XX:XX:XX
----------------------------------------------------------------------------------------------------
|Short text                                                                                        |
|    SQL error "-60" occurred when executing Native SQL.                                           |
----------------------------------------------------------------------------------------------------
|What happened?                                                                                    |
|    The error "-60" occurred in the current database connection "LCA".                            |
|    Error Text of Database: "POS(1) Work rolled back: tExcept 31100 in                            |
|     SIM_SIMSESSION"                                                                              |
|    SQL Statement Responsible:"EXECUTE PROCEDURE "SIM_SIMSESSION_CONTROL""

Or

|What happened? |

| Error 600 has occurred on the current database connection "LCA". |
| Database error text: POS(1) Work rolled back: tExcept 31100 in SIM_SIMSESSION |
| Triggering SQL statement: "EXECUTE PROCEDURE "SIM_SIMSESSION_CONTROL"" |


At the same time, MaxDB log file contains following information:

0x2D0   ERR       51000   OBJECT ##### #!!# tExcept no. = 31100 ########
0x2D0   ERR       51000   OBJECT #  in SIM_SIMSESSION_CONTROL
0x2D0   ERR       51000   OBJECT #
0x2D0   ERR       51000   OBJECT ~< tExcept 31100 dq.size() == 0 - 0 [cbs_tsim_deltaqueue.cpp: 452] in SIM_SIMSESSION_CONTROL >~
0x2D0   ERR       51000   OBJECT #
0x2D0   ERR       51000   OBJECT # COM build 
0x2D0   ERR       51000   OBJECT #--------------------------------------#
0x2D0   ERR       51000   OBJECT # omsTerminate will be triggered:
0x2D0   ERR       51000   OBJECT # ERROR 31100 in SIM_SIMSESSION_CONTROL
0x2D0   ERR       51000   OBJECT # [incident] Z7L{0G00000EXG00l8G8HW
0x2D0   ERR       51000   OBJECT #        --> COM trace 1
0x2D0   ERR       51000   OBJECT ########################################
0x2D0   ERR       51000   OBJECT OmsHandle::omsTerminate  in method SIM_SIMSESSION_CONTROL :  tExcept 31100 in SIM_SIMSESSION_CONTROL ERROR 3110       0 in SIM_            SIMSESS             
0x2D0   ERR       51000   OBJECT ION_CONTROL: SessionGlobals::isMarkedForTerminate(h) is true!!!


Read more...

Environment

  • SCM system
  • Livecache Application

Keywords

DBIF_DSQL2_SQL_ERROR, CX_SY_NATIVE_SQL_ERROR, error "-60", error 600, SIM_SIMSESSION_CONTROL, simulation, 31100, tExcept 31100 , KBA , BC-DB-LCA , liveCache Applications , SCM-APO-PPS , Production Planning and Detailed Scheduling , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.