Skip to Content

Deadlocks on the DB table SUSAGE

In SM66 you noticed high number of processes active with Report SAPLSUSAGE_LOGGING performign DB updates on table SUSAGE. From Oracel session monitor you see several sessions with evet "enq:TX-row lock contention" running in parallel and performing database UPDATE on same table SUSAGE.

The work processes are locked. There are database terminations during the update. High load or parallel processing of processes that write data to the table SUSAGE may result in two processes blocking each other. As a result after some time, all work processes are blocked by write processes on this table.

Oracle session Monitor:

ST22 Runtime errors:

The above issue should be resolved by Implementing the abap code corrections provided with SAP Note 2182269 - DB deadlock on table SUSAGE blocks all work processes.

Tags: