Conflicting Unique indexes - CRM upgrade stopped
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
CRM 7.0 EHP2.0 , Oracle 11g
I have referred the below,
SAP Note : 626915
Thanks in Advance
ganesh subbiah replied
The issue is solved, below are the steps. Thank you all for the suggestions.
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.