Skip to Content
0
Mar 09, 2016 at 10:28 AM

DMO stuck in EU_CLONE_MIG_DT_RUN due to duplicate entries

1196 Views

Hi everyone,

I have a strange behavior with a DMO currently running for ECC.


The source ECC level is ECC6 EHP6 running on Oracle 11.2.0.3.

Target will be ECC EHP7 running on SAP HANA 1.00.111.00.1454183496.

SUM level is SP14.

We are in phase EU_CLONE_MIG_DT_RUN and have the following error message : ( file MIGRATE_DT_00201_IMP.LOG ) :

(IMP) INFO: starting create for object "EKPO~0" of type "primary index" #20160304191731
DbSl Trace: execute(), rc=1, rcSQL=349
DbSl Trace: EXECUTE on connection 0, rc=349
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(ALTER TABLE "EKPO" ADD CONSTRAINT "EKPO~0" PRIMARY KEY ( "MANDT", "EBELN", "EBELP" ) )
DbSlExecute: rc = 99
(SQL error 349)
error message returned by DbSl:

cannot CREATE UNIQUE INDEX; duplicate key found: [5] Several documents with the same ID exist in the index;SAPSE2:EKPO.$trexexternalkey$ content not unique, cannot define unique constraint. rowCount != distinctCount

We have checked our source Oracle system and do not have any duplicate entry in it :

  • On oracle this query brings no data back. Which proves the system does not have duplicate entries in this table in regards to the EKPO~0 key :

select alldata.rowid, alldata.*

from SAPSR3.EKPO alldata,

(select MANDT, EBELN, EBELP

from SAPSR3.EKPO group by MANDT, EBELN, EBELP

having count(*) > 1) keydata

where alldata.MANDT=keydata.MANDT

AND alldata.EBELN=keydata.EBELN

AND alldata.EBELP=keydata.EBELP

;

No rows selected.

  • In the HANA database, the following query brings the following data back :

select T1."$rowid$", T1.*

from "EKPO" T1,

(SELECT MANDT, EBELN, EBELP

FROM "EKPO" GROUP BY MANDT, EBELN, EBELP

HAVING COUNT(*) > 1) T2

where T1.MANDT=T2.MANDT

and T1.EBELN=T2.EBELN

and T1.EBELP=T2.EBELP

order by EBELN;

$rowid$

MANDT

EBELN

EBELP

LOEKZ

STATU

AEDAT

TXZ01

MATNR

EMATN

1

372 591

100

6500058866

2

20120423

CEFEPIME PM 256 WW B30

505000

505000

2

372 174

100

6500058866

2

20120528

5 V POWER.SUPPLY EU

MD5011

MD5011

3

370 279

100

6500059624

2

20120430

ACCUPROBE M GORDONAE

39005

39005

4

370 858

100

6500059624

2

20120430

BACILLUS CEREUS AGAR 500 GR

.00083

.00083

5

385 369

100

6500061247

24

20120517

COLOR GRAM2 R4 SAFRANIN BO2L

55548

55548

6

403 809

100

6500061247

24

20120525

PWR ENTRY MDL 115/230V

805-0017-02

805-0017-02

7

404 496

100

6500066511

4

20120710

STERILE COTTON SWABS (100)

70610

70610

8

444 828

100

6500066511

4

20120710

SEALER ASSEMBLY [R]

530111-1

530111-1

9

375 620

100

6500069747

2

20120806

YST TEST KIT VTK2 20CARDS

21343

21343

10

417 640

100

6500069747

2

20120810

  1. NUCL. EXTR. BUFFER 3(4X1L)

280132

280132

11

426 563

100

6500070529

5

20120820

GELOSE MAC CONKEY 100 PLATES

43149

43149

12

483 095

100

6500070529

5

20120820

DIMETHYLFORMAMIDE

.4540266

.4540266

13

479 987

100

6500073722

2

20121010

SE THIO. + INDIC. 25X100ML

P1700

P1700

14

479 691

100

6500073722

2

20120924

SODIUM(DI-) HYDROG PHOSPHATE - (1000)

.4560125

.4560125

15

475 995

100

6500075946

2

20121010

VIDAS BARCODEREAD 3800GPDF USB

93628

93628

16

475 994

100

6500075946

2

20121010

VIDAS ANALYSER

410417

410417

17

560 158

100

6500087164

5

20130121

MUELLER HINTON 2 AGAR 90 20PL

43301

43301

18

560 650

100

6500087164

5

20130121

URETHRAL COLLECTION SWABS

39309

39309

So we have duplicate entries in the SAP HANA database for EKPO which do not exist on Oracle.

What could be the source of this issue ?

How can we continue the DMO ?

Thanks and best regards,

Steve.