SAP Knowledge Base Article - Preview

3453448 - SM_CCLM:SIMIL job fails with deadlock in Solution Manager 7.2 system

Symptom

Job: SM_CCLM:SIMIL_<SystemID> cancels with the following error messages in the job's log:

Internal session terminated with a runtime error DBSQL_SQL_ERROR (see ST22)
Job cancelled

AND

A dump similar to the one below, is produced in ST22:

Category               Installation Errors                                                          
Runtime Errors         DBSQL_SQL_ERROR                                                              
Except.                CX_SY_OPEN_SQL_DB                                                            

 

Short Text                                                                                        
    SQL error "SQL code: 133" occurred while accessing table "AGSCCL_OBJECT".                     
 
What happened?                                                                                    
    Database error text: "SQL message: transaction rolled back by detected                        
     deadlock: TrexColumnUpdate failed on table 'SAPABAP1:AGSCCL_OBJECT' with                     
     error: transaction rolled back by detected deadlock: Local Deadlock detected:                
     owner tid cycle=[(victim) 42189907894, 42189910448], rc" 


Read more...

Environment

Solution Manager 7.2

Product

SAP Solution Manager 7.2

Keywords

SM_CCLM:SIMIL fails with deadlock, transaction rolled back by detected deadlock: TrexColumnUpdate failed on table 'SAPABAP1:AGSCCL_OBJECT' , KBA , SV-SMG-CCM , Custom Code Management , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.