Skip to Content
author's profile photo Devender Goyal
0
Devender Goyal
Mar 02, 2022 at 04:57 AM

1EETGCLN cannot CREATE UNIQUE INDEX; duplicate key found /IWFND/I_MED_SRH

346 Views

Hello All,

We are upgrading from S/4HANA 2021 FPS00 to FPS01 and facing below error in DBCLONE phase.

Find the detailed information in log 'DBCLONE02.SMD':

3 ETGCLN CREATE COLUMN TABLE "SAPHANADB"."/IWFND/I_MED_SRH~" ("SRV_IDENTIFIER" NVARCHAR (000040) DEFAULT '' NOT NULL, "IS_ACTIVE" NVARCHAR (000001) DEFAULT '' NOT NULL, "NAMESPACE" NVARCHAR (000010) DEFAULT '' NOT NULL, "OBJECT_NAME" NVARCHAR (000035) DEFAULT '' NOT NULL, "SERVICE_NAME" NVARCHAR (000040) DEFAULT '' NOT NULL, "SERVICE_VERSION" NVARCHAR (000004) DEFAULT '0000' NOT NULL, "CREATED_BY" NVARCHAR (000012) DEFAULT '' NOT NULL, "CHANGED_BY" NVARCHAR (000012) DEFAULT '' NOT NULL, "CREATED_TIMESTMP" DECIMAL (000015, 000000) DEFAULT 0 NOT NULL, "CHANGED_TIMESTMP" DECIMAL (000015, 000000) DEFAULT 0 NOT NULL, "IS_SAP_SERVICE" NVARCHAR (000001) DEFAULT '' NOT NULL, "SOFT_STATE_STAT" NVARCHAR (000001) DEFAULT '' NOT NULL, "PROCESS_MODE" NVARCHAR (000001) DEFAULT '' NOT NULL, "RELEASE_STATUS" NVARCHAR (000184) DEFAULT '' NOT NULL) COLUMN LOADABLE UNLOAD PRIORITY 5

3 ETGCLN ALTER TABLE "SAPHANADB"."/IWFND/I_MED_SRH~" ADD CONSTRAINT "/IWFND/I_MED_SRH~~0" PRIMARY KEY ("SRV_IDENTIFIER", "IS_ACTIVE")

3 ETGCLN insert into "/IWFND/I_MED_SRH~" ( "SRV_IDENTIFIER", "IS_ACTIVE", "NAMESPACE", "OBJECT_NAME", "SERVICE_NAME", "SERVICE_VERSION", "CREATED_BY", "CHANGED_BY", "CREATED_TIMESTMP", "CHANGED_TIMESTMP", "IS_SAP_SERVICE", "SOFT_STATE_STAT", "PROCESS_MODE", "RELEASE_STATUS" ) select "SRV_IDENTIFIER", "IS_ACTIVE", "NAMESPACE", "OBJECT_NAME", "SERVICE_NAME", "SERVICE_VERSION", "CREATED_BY", "CHANGED_BY", "CREATED_TIMESTMP", "CHANGED_TIMESTMP", "IS_SAP_SERVICE", "SOFT_STATE_STAT", "PROCESS_MODE", "RELEASE_STATUS" from "/IWFND/I_MED_SRH"

3 ETGCLN Number of original rows: 523. Number of copied rows: 523.

3 ETGCLN CREATE UNIQUE INDEX "/IWFND/I_MED_SRH~1" ON "SAPHANADB"."/IWFND/I_MED_SRH~" ("IS_ACTIVE", "NAMESPACE", "SERVICE_NAME", "SERVICE_VERSION")

1EETGCLN cannot CREATE UNIQUE INDEX; duplicate key found: [5] Several documents with the same ID exist in the index;SAPHANADB:/IWFND/I_MED_SRH~.$$uc_/IWFND/I_MED_SRH~1$$ content not unique, cannot define unique constraint. rowCount != distinctCount

1EETGCLN /IWFND/I_MED_SRH

1EETGCLN Error when cloning table indexes