SAP Knowledge Base Article - Preview

2264818 - Database deadlocks on ESH_EX_CPOINTER

Symptom

When running a Z report which executes mass changes on search-relevant business objects it is observed that the report starts hanging when trying to update the Enterprise Search change pointer table ESH_EX_CPOINTER, and the job terminates with a database deadlock. The short dump contains the following information:

  • SQL error "SQL code: 60" occurred while accessing table "ESH_EX_CPOINTER".
  • Database error text: SQL message: ORA-00060: deadlock detected while waiting for resource                                                              
  • Return value of the database layer: "SQL dbsl rc: 99"     
  • "DBSQL_SQL_ERROR" CX_SY_OPEN_SQL_DB
    "CL_ESH_CO_CHANGEPOINTER=======CP" bzw. CL_ESH_CO_CHANGEPOINTER=======CM00
    "SET_CHANGEPOINTER"


Read more...

Environment

  • SAP Basis release 731 & 740.

Product

SAP NetWeaver Enterprise Search 7.3

Keywords

KBA , BC-EIM-ESH , NetWeaver Enterprise Search , 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.