3606855 - DBSQL_DUPLICATE_KEY_ERROR - trying to insert a record into the database table "ADRU"

When adding or changing email addresses, or any other communication data, the following runtime error occurs:

Category                       ABAP Programming Error       
Runtime Errors                 DBSQL_DUPLICATE_KEY_ERROR    
Except.                        CX_SY_OPEN_SQL_DB            
ABAP Program                   SAPLSZA0                     
Application Component      BC-SRV-ADR

The reason for the exception is:

When an Open SQL array insert is performed, trying to insert a record
into the database table "ADRU" causes the function to terminate if a
record with the same key already exists.

Read more...

• SAP ERP
• SAP ERP Central Component
• SAP enhancement package for SAP ERP
• SAP enhancement package for SAP ERP, version for SAP HANA
• SAP S/4HANA
• SAP S/4HANA Cloud Private Edition
• SAP Netweaver

SAP ERP Central Component all versions ; SAP ERP all versions ; SAP NetWeaver all versions ; SAP R/3 Enterprise all versions ; SAP R/3 all versions ; SAP S/4HANA Cloud Private Edition all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

BP, BPS, BUSINESS PARTNER, BUSINESS PARTNERS, VENDOR, VENDORS, SUPPLIER, SUPPLIERS, CUSTOMER, CUSTOMERS,      (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.)     "DBSQL_DUPLICATE_KEY_ERROR" CX_SY_OPEN_SQL_DB  "SAPLSZA0" bzw. LSZA0U47     "ADDR_SAVE_INTERN"                                                                                                                   

, KBA , BC-SRV-ADR , Address Management / Business Address Services , Problem