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 for Me (Login required).

Search for additional results

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