SAP Knowledge Base Article - Preview

3724031 - Dump DBSQL_DUPLICATE_KEY_ERROR occurs during implementing a note

Symptom

During implementing a note which was implemented before, the following dump occurs.

"

Category               ABAP programming error

Runtime Errors         DBSQL_DUPLICATE_KEY_ERROR

Except.                CX_SY_OPEN_SQL_DB

ABAP Program           SAPLSCWC

Application Component  BC-UPG-NA

Date and Time          <timestamp>

----------------------------------------------------------------------------------------------------

 

----------------------------------------------------------------------------------------------------

|Short Text                                                                                        |

|    Open SQL array insert produces duplicate records in the database.                             |

----------------------------------------------------------------------------------------------------

 

----------------------------------------------------------------------------------------------------

|What happened?                                                                                    |

|    Error in the ABAP application program.                                                        |

|                                                                                                  |

|    The current ABAP program "SAPLSCWC" 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 not                |

|     caught                                                                                       |

|    in procedure "SCWB_CINST_UPDATE_SMODI_TABLES" "(FUNCTION)" 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:                                                   |

|    When an Open SQL array insert is performed, trying to insert a record                         |

|    into the database table "SMODILOG" 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

SNOTE

Product

SAP NetWeaver 7.5

Keywords

SNOTE, obsolete version implemented, internal table, DBSQL_DUPLICATE_KEY_ERROR, CX_SY_OPEN_SQL_DB, SAPLSCWC , 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.