SAP Note 196113 - SAPSQL_ARRAY_INSERT_DUPREC, BALHDR

Component : Basis Application Log -

Solution : https://service.sap.com/sap/support/notes/196113 (SAP Service marketplace login required)

Summary :
SAP Note addresses issues due to duplicate record errors in the BALHDR table resulting from SQL array inserts in versions below 4.6A, causing ABAP runtime errors and update terminations. The problem originates from the APPL_LOG number range management, where existing numbers can be reassigned, leading to failures. Remediation steps involve checking and adjusting the number status via transaction SE16 for table BALHDR and modifying number status in SLGN. If problems persist, resetting number range buffers and server tests via transaction SM56 and RSSLGK00 report are recommended to handle legacy number conflicts effectively and prevent further dumps.

Key words :
client          <current client >    object          appl_log    subobject    range    year    global reset xyou, function module bal_db_save_no_update_task      program        saplsbal_db      include        lsbal_dbu07, function module appl_log_write_db      program        saplslg0      include        lslg0u07, function module bal_db_internal_no_update_task      program saplsbal_db_internal      include lsbal_db_internalu02, number        current number  01 00000000000000000001  99999999999999999999      16936the current number field, select number range buffer -> reset, appl_log number range object, table balhdropen sql array insert, number range object reason, number range object===============================================================

Related Notes :

1292069Add. info. on upgrading to SAP ERP 6.0 EHP4 SR1 ABAP
1156968Add. info. on upgrading to EHP 4 for SAP ERP 6.0 ABAP
1088904Add. info. on upgrading to SAP ECC 6.0 SR3 ABAP
961410Add. info. on upgrading to SAP ECC 6.0 SR2 ABAP
913971Add. info. on upgrading to SAP ERP Central Component 6.0 SR1
826092Add. info. on upgrading to SAP ERP Central Component 6.0
737696Add. info on upgrade to SAP R/3 Enterprise 4.70 Ext. 2 SR1
637683Add info about upgrade to SAP R/3 Enterprise Core 4.70 Ext 2
603852Additional information about upgrading to SAP SCM 4.0
587896Add. info on upgrade to SAP R/3 Enterprise Core 4.70 SR1