SAP Knowledge Base Article - Preview

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

Symptom

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...

Environment

  • 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

Product

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

Keywords

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

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.