SAP Knowledge Base Article - Preview

3290614 - DBSQL_DUPLICATE_KEY_ERROR in table USOBT when implementing note in SNOTE

Symptom

While implementing SAP Note via 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.
 

In certain release, the table name "USOBT" may not appear directly in the Error Analysis section. However, you can find this information under the "Chosen Variables" section, as shown below: 

LV_TABNAME
    USOBT


Read more...

Environment

  • Note Assistant (SNOTE)
  • OS and database independent

Product

SAP ERP 6.0 ; SAP NetWeaver Application Server for ABAP 7.1 ; SAP NetWeaver Application Server for ABAP 7.2 ; SAP S/4HANA all versions ; SAP Solution Manager all versions

Keywords

DBSQL_DUPLICATE_KEY_ERROR, CX_SY_OPEN_SQL_DB, CL_SVRS_TLOGO_READER==========CP, Open SQL array insert produces duplicate records in the database, same key already exists, USOBT, SNOTE, note, download, implement, dump, Note Assistant , 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.