SAP Knowledge Base Article - Preview

2751637 - Duplicate key error for logging table - SAP Landscape Transformation Replication Server

Symptom

  • Duplicate key error for logging table
  • DBSQL_DUPLICATE_KEY_ERROR error for /1CADMC/0000XXXX table
  • Unique constraint violated for logging table (/1CADMC/0000XXXX)
  • SAPSQL_ARRAY_INSERT_DUPREC dumps in source system
  • DBIF_DSQL2_DEFAULT_CR_ERROR dumps in source system
  • Replication working on delete and recreation of the trigger
  • Dump on the source after starting replicating a table.
    Category ABAP programming error
    Runtime Errors DBSQL_DUPLICATE_KEY_ERROR
    Except. CX_SY_OPEN_SQL_DB
    ABAP Program SAPLF005

    Open SQL array insert produces duplicate records in the database.

    What happened?
    Error in the ABAP application program.

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

  • Error when manually insert a record in the source table directly in the database
    ERROR on line 1: ORA-00001: exclusive constraint (UNKNOWN.obj#=8871040) violated ORA-06512: on "SAPSR3./1LT/00000XXXINS", line 1 ORA-04088: error during trigger execution 'SAPSR3./1LT/00000XXXINS'


Read more...

Environment

  • SAP Landscape Transformation Replication Server

Product

SAP Landscape Transformation replication server 1.0 ; SAP Landscape Transformation replication server 2.0 ; SAP Landscape Transformation replication server 3.0

Keywords

DBSQL_DUPLICATE_KEY_ERROR, DUPREC, SAPSQL_ARRAY_INSERT_DUPREC, Duplicate, DUMP , KBA , CA-LT-SLT , SAP Landscape Transformation Replication Server (SLT) , CA-LTR-GEN , Use CA-LT-SLT instead , CA-LTR-DB , Use CA-LT-SLT instead , CA-LTR-BW , Use CA-LT-SLT instead , HAN-DP-LTR , Use CA-LT-SLT instead , 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.