2476140 - SQL Error: SQL0911N The current transaction has been rolled back because of a deadlock or timeout | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2476140 - SQL Error: SQL0911N The current transaction has been rolled back because of a deadlock or timeout

Symptom

  • Deadlocks in the job log of job SMREP_PROCESS_BW_DATA_QUEUE you can see log entries like this:

    Number of latecome records to be processed: 0 (runtime: 8.1 ms)
    SQL: <DATE><TIME> SM_EFWK
    TRUNCATE TABLE "SMREP_MAI_QUEUE2"
    SQL Error: SQL0911N  The current transaction has been rolled back because of a dead
    SQL-END:

    Deleting queue took 1458704.2 ms

    OR

  • In the System Logs:

    Database error -911 at EXE
    SQL0911N The current transaction has been rolled back
    because of a deadlock or timeout. Reason code "68".
    SQLSTATE=40001
    Deadlock occurred

Read more...

Environment

SAP Solution Manager 7.2, SP04

Product

SAP Solution Manager 7.2

Keywords

SOLMAN, deadlock, Change the queue table deletion method, SMREP_CFG_STATIC, NO_TABDROP, SMREP_MAI_QUEUE1 , KBA , SV-SMG-MON-REP , Content for Technical Monitoring Reporting , 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.