Symptom
While implementing note in Tcode SNOTE, it terminates with short dump DBSQL_DUPLICATE_KEY_ERROR in table USOBT.
-----------------------------------------------------------------
Category ABAP programming error
Runtime Errors DBSQL_DUPLICATE_KEY_ERROR
Except. CX_SY_OPEN_SQL_DB
ABAP Program CL_SVRS_TLOGO_READER==========CP
Application Component BC-UPG-NA
Short Text
Open SQL array insert produces duplicate records in the database.
What happened?
Error in the ABAP application program.
The current ABAP program "CL_SVRS_TLOGO_READER==========CP" had to be
terminated because it found a
statement that could not be executed.
Error analysis
An exception has occurred in class "CX_SY_OPEN_SQL_DB". This exception was no
caught
in procedure "WRITE_OBJECT" "(METHOD)" 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 "USOBT" causes the function to terminate if a
record with the same key already exists.
-----------------------------------------------------------------
Read more...
Environment
OS and database independent.
Keywords
"DBSQL_DUPLICATE_KEY_ERROR", "USOBT", "CX_SY_OPEN_SQL_DB", " same key already exists" , KBA , BC-UPG-NA , SAP Notes Assistant , 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.