SAP Knowledge Base Article - Preview

2603079 - Runtime Errors DBSQL_SQL_ERROR short dump with SQL error "SQL code: 133" in the Solution Manager System

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

SAP Solution Manager 7.2

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.