topic error: SAPSQL_ARRAY_INSERT_DUPREC ... in Application Development and Automation Discussions

error: SAPSQL_ARRAY_INSERT_DUPREC ...

Former Member — Thu, 22 Nov 2007 01:07:31 GMT

We are getting short dumps in transaction VA01 and VA02 that reference the error:

SAPSQL_ARRAY_INSERT_DUPREC

Is this due to an internal number range assignment?

Can you please help?

Thanks,

Karim

Former Member — Thu, 22 Nov 2007 02:44:40 GMT

Hi Karim,

This error happens when the system treis to create the entry in the table with the already existing key.

You may need to find out for which table this error is happening and what are those duplicate values.

Regards,

Atish

Former Member — Thu, 22 Nov 2007 03:59:43 GMT

There are a ton of notes for this problem. I suggest you search there.

Rob

Former Member — Thu, 22 Nov 2007 04:02:15 GMT

Hi,

This dump occurs only when system try to inser a duplicate record.

regards,

siva chalasani.

Former Member — Thu, 22 Nov 2007 04:21:19 GMT

Hi Karim,

This error occurs when some records having duplicate primary/unique keys are being inserted to a table .

To solve the problem, repeat the transaction, and at abap dump screen, check the code where the error occurs.

If it is due to user exit, add relevant codes to remove duplicate records .

Rgds,

TS Winedya