Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Former Member
0 Likes
743

HI,

When ran the pgm in background got a short dump as "ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC".

Its seems that this has occured when a duplicate record is inserted into the database table.Please help me to find which value is getting inserted

1 ACCEPTED SOLUTION
Read only

former_member15255
Active Participant
0 Likes
711

Hello,

1) First check wheather there any Indexes are maintained for the table,Check wheather all the primary keys has been maintained in the Index. if it is not maintained , maintain all the primary keys in the indexes or delete the index. Take help of BASIS person

2) Secondly check wheather data already exist

3) if it is standard transaction then check with the number range Take the help of functional consultant

4) Check for Note Availability

regards

Suresh

6 REPLIES 6
Read only

Former Member
0 Likes
711

It may be difficult to suggest right away..

Could you tell which program u r executing.

Try and look for INSERT statements in the program.. and analyse the internal table there..

also you may have to check if any similar record already exists in ur Database table..

Revert if u need more help.

Read only

0 Likes
711

Its in pgm "SAPLEDI1" in the include "LEDI1F09".

Read only

0 Likes
711

Dont study the programs..

Best would be to check the data you are inserting with respect to the data already present.

Thats the best way coming to my mind..

Read only

0 Likes
711

Hi,

can you run it online?

If yes, in the short dump go in "debug mode" (with the corresponding button) and you'll see the instruction with error.

Probably you'll we able to see the content of the work are of the record that the program tries to insert in the standard table.

Bye

Andrea

Read only

former_member15255
Active Participant
0 Likes
712

Hello,

1) First check wheather there any Indexes are maintained for the table,Check wheather all the primary keys has been maintained in the Index. if it is not maintained , maintain all the primary keys in the indexes or delete the index. Take help of BASIS person

2) Secondly check wheather data already exist

3) if it is standard transaction then check with the number range Take the help of functional consultant

4) Check for Note Availability

regards

Suresh

Read only

Former Member
0 Likes
711

Hi !

This problem was solution ?

I got dump too.

Can you help me ?