SAP Knowledge Base Article - Preview

2302474 - Deadlocks during master data update

Symptom

Master data loading processes are hanging, the logs show deadlocks on the data base. You may find statements similar to the following ones on your system:

In SM37 jobs named like BIDTPR_* show statements:
TRUNCATE TABLE "/BI0/06........." DBMAN 099

In the syslog:
Database error -911 at EXE
"SQL0911N The current transaction has been rolled back because of a deadlock or timeout
Deadlock occurred

SQL statement:
TRUNCATE TABLE "/BI0/06.........." DROP STORAGE RESTRICT WHEN DELETE TRIGGERS IMMEDIATE

"UPDATE "/BI0/S<infoobject>" * "CHCKFL" = ? WHERE EXISTS ( SELECT * FROM
 "/BI0/06........" T_100 WHERE T_100 . "SID" = "/BI0/S<infoobject>" . "SID" )"

Shortdump:
DBIF_RSQL_SQL_ERROR
CX_SY_OPEN_SQL_DB
SQL error "-60" when accessing table "/BIC/S<infoobject>"
UPDATE (l_sidtab) SET (l_set_clause)
WHERE EXISTS ( SELECT * FROM (l_tmptabnm) WHERE (l_where_clause) ).


Read more...

Environment

  • SAP NetWeaver 7.3
  • SAP enhancement package 1 for SAP NetWeaver 7.3
  • SAP NetWeaver 7.4 
  • SAP NetWeaver 7.5

Product

SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.3

Keywords

sql error 60, ORA-00060, deadlock, DBMAN099 , KBA , BW-WHM-DBA-MD , Master Data , BW-BEX-OT-DBIF , Interface to Database , 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.