Conflicting Unique indexes - CRM upgrade stopped

Hi Friends,

We are getting the below error in pre-processing step of CRM upgrade from CRM 5.2 to CRM 7.0 EHP 2.0

"Checks after phase MAIN_SHDIMP/SUBMOD_SHDIMP/SHADOW_IMPORT_UPG2 were negative!

Last error code set: Detected 128 errors summarized in 'SHDUPGIMP2.ELG'<br/> Calling '/dataexport/SUM/abap/exe/tp' failed with return code 8, check /dataexport/SUM/abap/log/SAPup.ECO for details"

Detail from SHDUPGIMP2.ELG:

"2EETW000 Update and insert sequence failed due to conflicting unique indexes on table COMC_ATTRIBUTE (please read OSS note 626915 for details)"

I have dropped the index at DB level.

Any suggestion on how to proceed further..

I have attached the below files



    Error screenshot & Table details at DB level

System details:

CRM 7.0 EHP2.0 , Oracle 11g

I have referred the below,

SAP Note : 626915

Thanks in Advance

Thanks, Ganesh (32206 B)
screenshot.xml (405654 B)

Hi All,

The issue is solved,  below are the steps. Thank you all for the suggestions.

Solution :

1. Created the unique index "COMC_ATTIBUTE~UNI"at SAP level in SE14

2. Renamed  the unique index from "COMC_ATTIBUTE~UNI" to "ZDROPINDEX" at DB level instead of deleting it.

3. Retried the main import phase in SUM.

Thanks, Ganesh

0 View this answer in context