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 :
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.
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
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.