본문 바로가기

Ⅰ. ERP/6. 에러해결

[SAP DUMP] DBSQL_DUPLICATE_KEY_ERROR

728x90

[DUMP 내용]

 

Category               ABAP programming error
Runtime Errors         DBSQL_DUPLICATE_KEY_ERROR
Except.                CX_SY_OPEN_SQL_DB
ABAP Program           
Application Component  Not assigned
Date and Time          2022.12.29 14:36:27 (UTC+9)

 Short Text
     Open SQL array insert produces duplicate records in the database.

 어떤 문제가 발생했습니까?
     Error in the ABAP application program.

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

 

 

[DUMP 해결방법]

 

insert 할 때 ACCEPTING DUPLICATE KEYS 붙인다.

 

INSERT DB FROM TABLE @itab ACCEPTING DUPLICATE KEYS.

 

728x90