‎2009 Jan 09 5:39 AM
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
‎2009 Jan 09 10:59 AM
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
‎2009 Jan 09 6:43 AM
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.
‎2009 Jan 09 7:15 AM
‎2009 Jan 09 10:53 AM
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..
‎2009 Jan 09 10:57 AM
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
‎2009 Jan 09 10:59 AM
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
‎2009 Mar 23 10:58 AM
Hi !
This problem was solution ?
I got dump too.
Can you help me ?