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.