Symptom
Execution of the report PRD_SCM_GUID_CONVERSION results in a dump after a certain period of time:
Category ABAP programming error
Runtime Errors DBSQL_SQL_ERROR
Except. CX SY OPEN_SQL_DB
ABAP: Program PRD SCM GUID_CONVERSION
Application Component SCM-S4H-MD-PR
SQL error "SQL code: 131" occurred while accessing table MARCU.
An exception has occurred in class "CX_SY_OPEN_SQL_DB". This exception was not caught in procedure "SAVE_DATA" "(FORM)" or propagated by a RAISING clause.
Since the caller of the procedure could not have anticipated this exception, the current program was terminated.
The reason for the exception occurring was :
Database error text: SQL message: transaction rolled back by lock wait timeout: TrexColumnUpdate failed on table 'SAPABAP1:MARC' with error: transaction rolled back by lock wait timeout: Lock-wait time out exceeded [OWNER=X, TYPE=RECORD_LOCK, CURRENT_MODE=NON_KEY_EXC
Return value of the database layer: "SQL dbsl rc: 99"
The issue does not occur when the report is run for single materials.
Read more...
Environment
SAP S/4HANA
Product
Keywords
PRD_SCM_GUID_CONVERSION, dump, parallel changes, SM12, lock, SQL code: 131 , KBA , SCM-S4H-MD-PR , Product , 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.