on 09-24-2007 2:44 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.