2476140 - "SQL Error: SQL0911N" error occurs for background job SMREP_PROCESS_BW_DATA_QUEUE within SAP Solution Manager 7.2

• 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

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