topic ITAB_DUPLICATE_KEY Error after system copy in Application Development and Automation Discussions

ITAB_DUPLICATE_KEY Error after system copy

Former Member — Sat, 24 May 2008 13:09:13 GMT

Hi!

I am facing with the following error after the system copy of SAP ERP 2005 on Windows migrated from MS SQL to SAP DB.

By entering into the db-relevant tcodes (DB13, etc.) the following error appears:

Runtime Errors ITAB_DUPLICATE_KEY

Date and Time 24.05.2008 14:01:23

Short text

A row with the same key already exists.

What happened?

Error in the ABAP Application Program

The current ABAP program "CL_DB6_SYS====================CP" had to be

terminated because it has come across a statement that unfortunately cannot be executed.

Error analysis

An entry was to be entered into the table "\CLASS=CL_DB6_SYS\DATA=SYSTEMS"

(which should have had a unique table key (UNIQUE KEY)).

However, there already existed a line with an identical key.

The insert-operation could have ocurred as a result of an INSERT- or

MOVE command, or in conjunction with a SELECT ... INTO.

The statement "INSERT INITIAL LINE ..." cannot be used to insert several

initial lines into a table with a unique key.

Has some one any ideas how to solve the problem?

Thank you very much!

regards

Thom

Re: ITAB_DUPLICATE_KEY Error after system copy

Sm1tje — Sat, 24 May 2008 18:47:49 GMT

when you are (absolutely) sure, that this is not caused by a custom program (which calls this CL_DB6_SYS somewhere along the line), you should create a ticket (OSS message).

I looked at service.sap.com, but could only find some problems with CL_DB6_SYS, but they are not the same. Maybe you can have a look at service.sap.com and use a few search parameters too, to find if there is already a note available for this you have to implement.

Re: ITAB_DUPLICATE_KEY Error after system copy

Former Member — Thu, 16 Jun 2011 14:11:41 GMT

Hi,

I am facing same problem for oppty component bt111h_oppt.

Error analysis:

An entry was to be entered into the table

"\DATA=VIEWS" (which should have

had a unique table key (UNIQUE KEY)).

However, there already existed a line with an identical key.

The insert-operation could have ocurred as a result of an INSERT- or

MOVE command, or in conjunction with a SELECT ... INTO.

The statement "INSERT INITIAL LINE ..." cannot be used to insert several

initial lines into a table with a unique key.

How to resolve this ?

Please help me.

Regards

Krishna

Edited by: krishna nadupuri on Jun 16, 2011 4:12 PM