SAP Knowledge Base Article - Preview

3453448 - SM_CCLM:* job fails and generates a DBSQL_SQL_ERROR dump

Symptom

Job: SM_CCLM:*_<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" 

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

Solution Manager 7.2

Product

SAP Solution Manager 7.2

Keywords

SM_CCLM, collecto job, "SQL code: 133" occurred while accessing table "AGSCCL_OBJECT", 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.