Symptom
In the Solution Manager System, in transaction ST22, the following dump is found:
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 11.02.2018 19:25:59
Short Text
SQL error "SQL code: 133" occurred while accessing table "AGSDVMAS_LOG".
What happened?
Database error text: "SQL message: transaction rolled back by detected
deadlock: TrexUpdate failed on table 'SAPABAP1:AGSDVMAS_LOG' with error:
transaction rolled back by detected deadlock: Deadlock detected while
executing transaction (TRANSACTION_ID=36, UPDATE_TRANSACTION_ID"
Error analysis
An exception has occurred which is explained in more detail below. The
exception is assigned to class 'CX_SY_OPEN_SQL_DB' and was not caught in
procedure
"AGSDVMAS_LOG_ADD" "(FUNCTION)", nor was it propagated by a RAISING clause.
Since the caller of the procedure could not have anticipated this
exception, the current program was terminated.
Information on where terminated
The termination occurred in ABAP program "SAPLAGSDVMAS_SELF_SERVICE", in
"AGSDVMAS_LOG_ADD". The main program
was "AGSDVMAS_CONTROL".
In the source code, the termination point is in line 25 of (Include)
program "LAGSDVMAS_SELF_SERVICEU13".
Program "SAPLAGSDVMAS_SELF_SERVICE" was started as a background job.
The termination is due to exception "CX_SY_OPEN_SQL_DB" occurring in procedure
"AGSDVMAS_LOG_ADD" "(FUN
2 FUNCTION SAPLAGSDVMAS_SELF_SERVICE LAGSDVMAS_SELF_SERVICEU13 25
AGSDVMAS_LOG_ADD
1 EVENT AGSDVMAS_CONTROL AGSDVMAS_CONTROL 151
START-OF-SELECTION
>>>>> INSERT INTO agsdvmas_log VALUES ls_log.
>>>>> INSERT INTO agsdvmas_log VALUES ls_log.CTION)".
Read more...
Environment
SAP Solution Manager 7.2 SP06
Product
Keywords
DBSQL_SQL_ERROR, AGSDVMAS_CONTROL, ST22, SAPLAGSDVMAS_SELF_SERVICE LAGSDVMAS_SELF_SERVICE, SQL code: 133, agsdvmas_log VALUES ls_log , KBA , SV-SMG-DVM , Data Volume 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.