- 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
Deleting queue took 1458704.2 ms
- 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".
SAP Solution Manager 7.2, SP04
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 pageThis 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.