DB is inconsistent after the heterogenous system copy

[Former Member]

Hi!

I have currently serios problems working with SAP ERP 2005 (SAP DB on Windows) that was installed via heterogenous system.

Entering into db-relevant tcodes such as DB13, etc. retrieves a dump "ITAB_DUPLICATE_KEY".

Furthermore it is not possible to execute the patch in tcode SPAM, because the patch is hanging in the phase "IMPORT_PROPER" (the DD structure seems to be inconsistent).

Can someone describe the procedure with technical steps to solve the problem?

Thank you very much!

regards

Thom

[Former Member]

Please check this note if it helps.

Note 940878 - DB02N collector: ITAB_DUPLICATE_KEY

Import_Improper

You can do one thing if you are not able to proceed with patching.

You can go to pat01 and pat03 .

You try to rest the staus of patch in table pat03 to N

and start the same patch again.

update table sapr3.pat03 status='N' where patch='SAPKA46D04';

or get abaper to reset the value from abap.

Hope it helps

Amit Asthana

[Former Member]

Hi Thom !

Do you know on which tables you have the duplicate keys (the wp-number is in the dump and the sql-statement is in it's developertrace) ?

It might be that you have an DB specific error.

Or has the migration been interrupted an set-up again ? This might be a cause for duplicate-keys -> very bad, review import logs and re-do the import.

Regards

Josef