Deletion of duplicated table entry

[Former Member]

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, dbacockpit, 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.

My questions:

1) How can I identify which DB-table is relevant?

2) How can I delete the duplicated entry?

a) with SAP tcodes

b) on DB level (what is the procedure)

Thank you very much!

regards

Thom

[Former Member]

Hi Thom,

from one side you can look in the WP log file where the short dump occured. The failed SQL statement is rather often logged there.

From the other side as the issue is reproducable you can take the SQL trace and see which SQL statement failed.

On the DB level you can delete the stamente with the usual DELETE statement. This exact description you will find in our documentation please follow the path from the SAP note 767598 in depend of your DB version.

Best regards,

Oksana