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

[devender_goyal2]

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

[devender_goyal2]

Resolution steps:

1. Find duplicates via below script from SAP note.

2. Find and update all the records that the following two conditions are met for them

• Has different value than "SAP" under changed_by and created_by fields
• and
• NAMESPACE, SERVICE_VERSION and SERVICE_NAME are the same

Login to application server or run the below sql in hana studio.

update "/IWFND/I_MED_SRH" set IS_ACTIVE=I where SRV_IDENTIFIER='ZFDM_PAGE_REPOSITORY_CUST_SRV_0001' or SRV_IDENTIFIER='ZFDM_PAGE_REPOSITORY_SRV_0001' or SRV_IDENTIFIER='ZFDM_VALUE_HELP_SRV_0001' ;

We made the duplicate entries unique that helped resolve the issue. SUM was able to create the unique index and DBclone phase completed successfully.

Regards,

Devender