ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

[Former Member]

Dear All,

i exported system copy of Dev server and impot the System copy with new installation, step Abap Import it gives me an error:

E:\usr\sap\BIC\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

E:\usr\sap\BIC\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20090820071316

E:\usr\sap\BIC\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20090820104937

E:\usr\sap\BIC\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

E:\usr\sap\BIC\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:39

E:\usr\sap\BIC\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL1_1.cmd -dbcodepage 4103 -l SAPAPPL1_1.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(GSI) INFO: dbname = "BIC20090819080859 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "INFPU05449 "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "INFPU05449"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 Service Pack 2"

(GSI) INFO: machine = "2x Intel 80686 (Mod 15 Step 11)"

(DB) ERROR: DDL statement failed

(DROP INDEX "/BIC/000APR00001~0")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: Error 1452 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-1452 occurred when executing SQL stmt (parse error offset=44)

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "/BIC/000APR00001~0" ON "/BIC/000APR00001" ( "FLD001" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 65536 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 1452)

error message returned by DbSl:

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

(DB) INFO: disconnected from DB

E:\usr\sap\BIC\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

E:\usr\sap\BIC\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20090820104938.

Please help suggesting the solution.

thanks

[Former Member]

The problem is solved now.

Marked the 'err' entry in APAPPL1_1.TSk with 'ign' which solved the issue.

[Former Member]

IGN means that you ignore the data package which means that you won't import it into your system. Is this what you really wanted to do?

Just in case anyone else thinks this is a fix to the problem... it will cause data loss.

John

[fidel_vales]

1) search for notes

2) use the search available on the SDN (the top right box in this webpage)

You will find at least the following 4 notes regarding your error:

541538 FAQ: Reorganization

23237 duplicate keys, duplicate rows, duplicate records

11369 ORA-1452 during import after export from other system

617679 Error due to incomplete column definitions

I leave to you to read them and coose the one that applies to your situation.