Deletion of duplicated table entry (SAP DB)

[Former Member]

Hi!

I have executed the system copy of SAP ERP 2005 from Windows with MS SQL on Windows with SAP DB.

According to SAP guide some entries of the DB-tables should be deleted.

Can some one give the tcode and other technical description in order to do this?

Thank you very much

regards

Thom

[Former Member]

Hi Thom,

if you want to delete whole tables, you could do this with SE14 (Database Utility). Recreate table without keeping the data. If you have to delete only few rows, you may write a report or use database tools. You could also use sqlcli for MAXDB. sqlcli -d <SID> -u <connect schema>,<password> "delete from <table> where ...".

You can execute as <sid>adm user if you want.

Best regards

Ralph Ganszky

[Former Member]

Hello Ralph,

thank you very much for your answer!

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

My problem is that when I enter 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

Do you know how to proceed in this case?

Thank you!

Thom

[Former Member]

Hi Thom,

please open a ticket at SAP, this is probably no migration problem.

Regards

Ralph