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
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.
SAP Knowledge Base Article - Preview