avatar image
Former Member

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

    SHDUPGIMP2.ELG

    SAPup.log

    Error screenshot & Table details at DB level

System details:

CRM 7.0 EHP2.0 , Oracle 11g

I have referred the below,

http://scn.sap.com/thread/3293015

SAP Note : 626915

Thanks in Advance

Thanks, Ganesh

SAPup.txt.zip (32.2 kB)
screenshot.xml (405.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 10, 2013 at 04:15 AM

    Hi Ganesh,

    As per SAP Note 689574 - Add. info. on upgrading to SAP ERP Central Component 5.00

    Similar issue has been addressed.

    Solution is :

    delete the primary index of the respective table and recreate it. Repeat the upgrade phase

    Hope this helps.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

Skip to Content