ABAP runtime errors SAPSQL_ARRAY_INSERT_DUPREC

[Former Member]

Hi,

Its a production dump.I know the functionality of this dump.

But my question is program [SAPLZED7] in the dump doesn't exist in the system.I am also forwarding details below replated to dump.Please give some hint how to solve it??

The ABAP/4 Open SQL array insert results in duplicate database records.

What happened?

The current ABAP/4 program "SAPLZED7 " had to be terminated because

one of the statements could not be executed.

This is probably due to an error in the ABAP/4 program.

What can you do?

Note the actions and input that caused the error.

Inform your SAP system administrator.

You can print out this message by choosing "Print". Transaction ST22

allows you to display and manage termination messages, including keeping

them beyond their normal deletion date.

Error analysis

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

How to correct the error

Use an ABAP/4 Open SQL array insert only if you are sure that none of

the records passed already exists in the database.

If the error occurred in a non-modified SAP program, you may be

able to find a solution in the SAP note system.

If you have access to the note system yourself, use the following

search criteria:

"SAPSQL_ARRAY_INSERT_DUPREC"

"SAPLZED7 " or "LZED7F01 "

"UPDATE_TORQUE_TABLE"

If you cannot solve the problem yourself, please send the

following documents to SAP:

1. A hard copy print describing the problem.

To obtain this, select the "Print" function on the current screen.

-

2. A suitable hardcopy prinout of the system log.

To obtain this, call the system log with Transaction SM21

and select the "Print" function to print out the relevant

part.

3. If the programs are your own programs or modified SAP programs,

supply the source code.

To do this, you can either use the "PRINT" command in the editor or

print the programs using the report RSINCL00.

4. Details regarding the conditions under which the error occurred

or which actions and input led to the error.

[FredericGirod · Accepted solution]

Sometimes, the DUPREC is due to SNRO problem.

if you have several document type link to the same object number, the program could tries to insert a number already taked

(I don't look your program)

Regards

[Former Member]

The coding your are looking for is in FUNCTION MODULE ZED7.

[Former Member]

Hi,

I checked and found the FM ZED7 is not existing in my production system

[Former Member]

Hi,

You can search for a SAP note on SAP service market place with the search term SAPSQL_ARRAY_INSERT_DUPREC.

There are number of notes available, so you can check there.

Regs,

Lokesh