Skip to Content

ADDR_SAVE_INTERN duplicate key error short dump

Hi all,

I am trying to insert a record into the ADRC table through FM ADDR_SAVE_INTERN. First, I am pulling the next available ADRNR number through GET_NEXT_ADRNR. That is working fine and pulling back the next available number. However, when I insert via ADDR_SAVE_INTERN (adrc_i) I am getting a short dump with error DBSQL_DUPLICATE_KEY_ERROR. I have checked the ADRC table and the ADRNR number I am passing does not exist so I dont know why it is complaining about a duplicate?

Below is full error:

Category ABAP programming error

Runtime Errors DBSQL_DUPLICATE_KEY_ERROR

Except. CX_SY_OPEN_SQL_DB

ABAP Program SAPLSZA0

Application Component BC-SRV-ADR

Short Text Open SQL array insert produces duplicate records in the database. What happened? Error in the ABAP application program. The current ABAP program "SAPLSZA0" had to be terminated because it found a 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. Using Transaction ST22 for ABAP Dump Analysis, you can look at and manage termination messages, and you can also keep them for a long time. 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 "ADDR_SAVE_INTERN" "(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. The reason for the exception is: When an Open SQL array insert is performed, trying to insert a record into the database table "ADRC_UUID_INDEX" 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.)

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.