/scripts/ahub.form.attachments.js
0

Error in Phase EU_CLONE_MIG_DT_RUN cannot CREATE UNIQUE INDEX; duplicate key found

Nov 06, 2016 at 02:50 AM

311

avatar image
Former Member

Hi experts,

in the DMO Phase Error in Phase EU_CLONE_MIG_DT_RUN (MaxDB -> Hana) we geht this Error: cannot CREATE UNIQUE INDEX; duplicate key found

(DB) INFO: REPOSRC merged #20161105232619 (IMP) INFO: finished create for object "REPOSRC" of type "merge" in 0 sec #20161105232619 (IMP) INFO: starting create for object "REPOSRC^0" of type "primary index" #20161105232619 DbSl Trace: execute(), rc=1, rcSQL=397 DbSl Trace: EXECUTE on connection 0, rc=397 ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed (ALTER TABLE "REPOSRC" DROP CONSTRAINT "REPOSRC^0") DbSlExecute: rc = 99 (SQL error 397) error message returned by DbSl: invalid object name: invalid constraint name: line 1 col 39 (at pos 38) (IMP) INFO: a failed DROP attempt is not necessarily a problem 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 "REPOSRC" ADD CONSTRAINT "REPOSRC^0" PRIMARY KEY ( "PROGNAME", "R3STATE" ) ) DbSlExecute: rc = 99 (SQL error 349) error message returned by DbSl:

Now i found 100k+ duplicated entrys in table REPOSRC on the new Hana.

Is there a way to delete these dupplicated entrys? They have no primarykeys in this table ..

Thanks & Regards,

Sven

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Nov 06, 2016 at 09:04 AM
0
Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi,

i saw this Wiki & Note, but the Question is: How to delete these Duplicates?

Regards

0
avatar image
Former Member Nov 07, 2016 at 04:48 AM
0

Hi

Check this SCN thread https://archive.sap.com/discussions/thread/1790054 and also have you refereed the SAP Note 2262573?

BR

SS

Share
10 |10000 characters needed characters left characters exceeded
Skip to Content