cancel
Showing results for 
Search instead for 
Did you mean: 

Reg: Update Failures

Former Member
0 Kudos

Hi All,

I am working on ECC6.0, I can see around 80 updates failed due to the following reason. <b>ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC</b>.

what should i do now? how can i come out from this?

kind regards,

praveen

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Praveen,

This error indicates that there is an event of duplication of table record.

In sm13 pls analyze the failed Updates get info like user and transaction which started the update termination. Contact the user for further inputs.

Also check whether Update is deactivated and check for pending lock entries in sm12 for further analysis.

Regards

Umesh

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Praveen,

As the error message suggests, the failure was due to unique constraint violation on the object, which is fine as the object is consistant.

Get hold of the username / transaction and check with the users if they are having any issues with their records / data. If they find it to be consistant, just make note of the update failures and analyze which job / process caused duplicate records to be inserted.

Regards,

Nisch