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.
SAP Knowledge Base Article - Preview