2302474 - Deadlocks during DTP data load update

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) ).

The issue can also occur when updating Open Hub Destination:

TRUNCATE TABLE "/BIC/OH*" DROP STORAGE RESTRICT WHEN DELETE TRIGGERS IMMEDIATE LOCATION

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

sql error 60, ORA-00060, deadlock, DBMAN099 , KBA , BW-WHM-DBA-MD , Master Data , BW-BEX-OT-DBIF , Interface to Database , Problem