SAPSQL_ARRAY_INSERT_DUPREC dump while saving PO in ME22N

[Former Member]

Hi All,

SAPSQL_ARRAY_INSERT_DUPREC dump while updating PO in ME22N.

Error analysis

An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', was

neither

caught nor passed along using a RAISING clause, in the procedure

"/SAPSLL/OBJIDX_DB_UPDATE_R3" "(FUNCTION)"

.

Since the caller of the procedure could not have expected this exception

to occur, the running program was terminated.

The reason for the exception is:

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.

I tried to find SNOTE for this, but cannot find for ECC5.0. Can anybody help.

Thanks.

[Former Member]

This occurs because you try to insert a data with a key that already exists on the database.

I had once a similar problem with ME22 and I solved it by debugging and discovering which was the corrupt data. I think there was an error during PO savingand not all data was inserted, leaving some inconsistent data in tables. Later, when you try to save the purchase order, a data with same key is generated and tried to be inserted. If this is your case, you have two options: complete the data manually (inserting data in necessary tables) or delete the inconsistent data.

Regards.