SAP Knowledge Base Article - Preview

2276722 - Upgrade fails in SHADOW_IMPORT_INC due to conflicting unique indexes on table COMC_ATTRIBUTE - SAP ASE for Business Suite

Symptom

  • You are performing a SOLution MANager upgrade (which has CRM addin) or CRM upgrade.
  • Upgrade step MAIN_SHDIMP/SUBMOD_SHDIMP/SHADOW_IMPORT_INC fails with this error:

SHADOW IMPORT ERRORS and RETURN CODE in SAPK-702BRINBBPCRM.OD2
4 ETW000 [ dev trc,00000] Sun Feb 07 00:37:25 2016
4 ETW000 [ dev trc,00000] table logging switched off for all clients
4 ETW000 [ dbrsbuf ,00000] ***LOG BBC=>nametab inconsistency for table TADIR~ regarding view buffering
4 ETW000 1 entry for TADIR~ updated (R3TRATTR80215ADE55241DDF8CE636D957DE4033 ).
4 ETW000 0 entries of SMODILOG updated (ATTR80215ADE55241DDF8CE636D957DE4033 *)
2EETW000 Update and insert sequence failed due to conflicting unique indexes on table COMC_ATTRIBUTE (please read OSS note 626915 for details)
1 ETP111 exit code : "8"

  • Initially, the table COMC_ATTRIBUTE had two unique indexes at database level: COMC_ATTRIBUTE~0 and COMC_ATTRIBUTE~UNI. 
  • You dropped the ~UNI index as per SAP Note 1795072 - Error in COMC_ATTRIBUTE table during upgrade and re-ran the upgrade. It did not help. 
  • You dropped the index ~0 also, it did not help and you still get the same error.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite
  • SAP Customer Relationship Management (CRM) 7.x
  • SAP Solution Manager (SOLMAN) 7.x

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Customer Relationship Management all versions ; SAP Solution Manager 7.1 ; SAP Solution Manager 7.2

Keywords

upgrade, solman, COMC_ATTRIBUTE, "unique index", SHADOW_IMPORT_INC, "CRM addin" , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.