SAP Knowledge Base Article - Preview

3534015 - DBSQL_DUPLICATE_KEY_ERROR dumps during Access Plan Calculation in new CDC subscription mechanism. - SAP Landscape Transformation Replication Server (SLT)

Symptom

  • ABAP dumps occur in the access plan calculation phase.
  • Category               ABAP programming error
    Runtime Errors         DBSQL_DUPLICATE_KEY_ERROR
    Except.                CX_SY_OPEN_SQL_DB
    ABAP Program           CL_DMC_ACCESS_PLAN============CP
    Application Component  CA-LT-MIG
    Date and Time          26.10.2024 23:29:18

     

    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
        "SAVE_CLAUSES" "(METHOD)", 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 "DMC_ACCESS_PLAN" 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.)


Read more...

Environment

  • SAP Landscape Transformation Replication Server (SLT)
  • New CDC subscription mechanism

Product

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

Keywords

ABAP, Dumps, Access Plan Calculation, SAP Landscape Transformation Replication Server, SLT, DBSQL_DUPLICATE_KEY_ERROR, CX_SY_OPEN_SQL_DB, CL_DMC_ACCESS_PLAN============CP, Open SQL array insert, DMC_ACCESS_PLAN. , KBA , CA-LT-SLT , SAP Landscape Transformation Replication Server (SLT) , 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.