SAP Knowledge Base Article - Preview

3290614 - DBSQL_DUPLICATE_KEY_ERROR in table USOBT when implementing note

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 , Note 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.