cancel
Showing results for 
Search instead for 
Did you mean: 

Stuck update in sm13

PavanKumar2998
Newcomer
0 Kudos

Hello Experts,

I have been getting these dump along with stuck update in my customers systems.

Category ABAP programming error
Runtime Errors DBSQL_DUPLICATE_KEY_ERROR
Except. CX_SY_OPEN_SQL_DB
ABAP Program SAPLV50U
Application Component LE-SHP
Date and Time 15.04.2024 12:42:49 (CET)

 

Short Text
Open SQL array insert produces duplicate records in the database.

 

What happened?
Error in the ABAP application program.

The current ABAP program "SAPLV50U" had to be terminated because it
statement that could not be executed.

 

What can I do?
Note which actions and entries caused the error to occur.

Consult your SAP administrator.

Using transaction ST22 for ABAP dump analysis, you can view, manage
and retain termination messages for longer periods.
Note which actions and entries caused the error to occur.

Consult your SAP administrator.

Using transaction ST22 for ABAP dump analysis, you can view, manage
and retain termination messages for longer periods.

Error analysis
An exception has occurred in class "CX_SY_OPEN_SQL_DB". This exception was not
caught
in procedure "LIPS_VERBUCHEN" "(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:
The reason for the exception is:
When an Open SQL array insert is performed, trying to insert a record
into the database table "LIPS" causes the function to terminate if a
record with the same key already exists.

(When an Open SQL individual record insert is performed, this situation
does not cause the function to terminate. SY-SUBRC is set to 4 instead.)

I want to know what is the exact reason for this error and as a basis consultant what i should do. Also some updates have created a dump and some did not what does this mean.

 

Thanks in advance

Ryan-Crosby
Active Contributor
0 Kudos
It's a duplicate key insertion as stated in the dump, which means the system attempted to insert a row into LIPS that already exists. Enlist the help of a developer to trace down the root cause.

Accepted Solutions (0)

Answers (0)