SAP Knowledge Base Article - Preview

1862969 - Error during database insert in tables EDIDC or EDID4 or EDIDS

Symptom

  • Error during database insert in table EDIDC reported in transaction SM58
  • Open SQL array insert produces duplicate records in the database
  • Error during database insert in table EDID4
  • Error during database insert in table EDIDS
  • Error E0 371
  • SAPSQL_ARRAY_INSERT_DUPREC short dump in ST22 with function module F09_IDOC_INSERT_WITH_NUMBER
  • SM21 reports Run-time error "SAPSQL_ARRAY_INSERT_DUPREC" occurred

SM58:

EDIDC.png

 

ST22:

Runtime Errors         SAPSQL_ARRAY_INSERT_DUPREC
Exception              CX_SY_OPEN_SQL_DB
Short text
The ABAP/4 Open SQL array insert results in duplicate database records.
What happened?

Error in the ABAP Application Program

The current ABAP program "SAPLEDI1" had to be terminated because it has
come across a statement that unfortunately cannot be executed.

Error Analysis

An exception occurred that is explained in detail below.
The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught
in procedure "F09_IDOC_INSERT_WITH_NUMBER" "(FORM)", nor was it propageted by  a
RAISING clause.
Since the caller of the procedure could not have anticipated that the exception
would occur, the current program terminated.
If you use an ABAP/4 Open SQL array insert to insert a record in the database
and that record already exists with the same key, this results in termination.
(With an ABAP/4 Open SQL single record insert in the same error situation,
processing does not terminate, but SY-SUBRC is set to 4.)


Read more...

Environment

  • SAP Basis ALE
  • SAP NetWeaver
  • SAP Web Application Server for SAP S/4 HANA
  • ABAP PLATFORM - Application Server ABAP

Product

ABAP platform all versions ; SAP NetWeaver all versions ; SAP Web Application Server for SAP S/4HANA all versions

Keywords

BASIS_ALE, DBSQL_DUPLICATE_KEY_ERROR; F09_IDOC_INSERT_WITH_NUMBER , KBA , the abap/4 open sql array insert , cx_sy_open_sql_db , results in duplicate database records.  , sapledi1 , BC-MID-ALE , Integration Technology ALE , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.