Client Import - Duplicate Key Error

[Former Member]

Hello,

Doing a client export/import from our production to development systems (done many times before) and I've encountered an error for the first time. The error is the following:

1917 duplicate key errors during insert into table EDID4 occured

The odd thing is that I did this exact same import into a different client on the same system and had no issues (ie. Worked for client 400 but not working for client 401). The log gives no indication as to which records are duplicated specifically. Also, the the EDID4 table is absolutely massive (> 51 million rows) which leads me to believe that some type of cleanup/archiving should be occurring on this table.

Anyone have any advice on how best to proceed from this error? I'm unable to "just ignore it" since SCC7 won't run with this error having taken place....also not sure i should "just ignore it".

Thanx in advance,

er

[former_member128291]

Dear Elder,

Regarding the issue faced by you i would suggest you to review the following SAP Notes:

1074030 - R3trans: "Duplicate key" composite SAP note (as of Rel 6.10)

1603705 - R3trans: Error does not cause return code 8 or higher

Also check that your kernel (specially tp, R3trans, R3load) should be latest (not too old).

Best Regards,

Abhishek

[Former Member]

Dear Elder,
Regarding the issue faced by you i would suggest you to review the following SAP Notes:
1074030 - R3trans: "Duplicate key" composite SAP note (as of Rel 6.10)
1603705 - R3trans: Error does not cause return code 8 or higher
Also check that your kernel (specially tp, R3trans, R3load) should be latest (not too old).
Best Regards,
Abhishek

Hi Abhishek, thanx for the reply. I've actually been through both of those notes (plus about a dozen others) and nothing contained there within has helped.

Any other ideas?