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

[Former Member]

Hi,

SAPSSRC.log

____________________

C:\usr\sap\BW1\SYS\exe\run/R3load.exe: START OF LOG: 20071018195059

C:\usr\sap\BW1\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

C:\usr\sap\BW1\SYS\exe\run/R3load.exe: version R6.40/V1.4

Compiled Nov 30 2005 20:41:21

C:\usr\sap\BW1\SYS\exe\run/R3load.exe -ctf I C:/temp/51030721/EXP2/DATA/SAPSSRC.STR C:\Program Files\sapinst_instdir\NW04\SYSTEM\ABAP\ORA\NUC\DB/DDLORA.TPL C:\Program Files\sapinst_instdir\NW04\SYSTEM\ABAP\ORA\NUC\DB/SAPSSRC.TSK ORA -l C:\Program Files\sapinst_instdir\NW04\SYSTEM\ABAP\ORA\NUC\DB/SAPSSRC.log

C:\usr\sap\BW1\SYS\exe\run/R3load.exe: job completed

C:\usr\sap\BW1\SYS\exe\run/R3load.exe: END OF LOG: 20071018195059

C:\usr\sap\BW1\SYS\exe\run/R3load.exe: START OF LOG: 20071018195133

C:\usr\sap\BW1\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

C:\usr\sap\BW1\SYS\exe\run/R3load.exe: version R6.40/V1.4

Compiled Nov 30 2005 20:41:21

C:\usr\sap\BW1\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\NW04\SYSTEM\ABAP\ORA\NUC\DB/SAPSSRC.cmd -l C:\Program Files\sapinst_instdir\NW04\SYSTEM\ABAP\ORA\NUC\DB/SAPSSRC.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): WE8DEC

(DB) INFO: ABTREE created #20071018195134

(IMP) INFO: import of ABTREE completed (39 rows) #20071018195134

(DB) INFO: ABTREE~0 created #20071018195134

(DB) INFO: AKB_CHKCONF created #20071018195134

(IMP) INFO: import of AKB_CHKCONF completed (0 rows) #20071018195134

(DB) INFO: AKB_CHKCONF~0 created #20071018195134

(DB) INFO: AKB_INDX created #20071018195134

(IMP) INFO: import of AKB_INDX completed (0 rows) #20071018195134

(DB) INFO: AKB_INDX~0 created #20071018195134

(DB) INFO: AKB_USAGE_INFO created #20071018195134

(IMP) INFO: import of AKB_USAGE_INFO completed (0 rows) #20071018195134

(DB) INFO: AKB_USAGE_INFO~0 created #20071018195134

(DB) INFO: AKB_USAGE_INFO2 created #20071018195134

(IMP) INFO: import of AKB_USAGE_INFO2 completed (0 rows) #20071018195134

(DB) INFO: AKB_USAGE_INFO2~0 created #20071018195134

(DB) INFO: APTREE created #20071018195134

(IMP) INFO: import of APTREE completed (388 rows) #20071018195134

(DB) INFO: APTREE~0 created #20071018195134

(DB) INFO: APTREE~001 created #20071018195134

(DB) INFO: APTREET created #20071018195134

(IMP) INFO: import of APTREET completed (272 rows) #20071018195134

DbSl Trace: Error in exec_immediate()

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "APTREET~0" ON "APTREET" ( "SPRAS", "ID", "NAME" ) TABLESPACE PSAPBW1 STORAGE (INITIAL 44981 NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

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

C:\usr\sap\BW1\SYS\exe\run/R3load.exe: job finished with 1 error(s)

C:\usr\sap\BW1\SYS\exe\run/R3load.exe: END OF LOG: 20071018195134

C:\usr\sap\BW1\SYS\exe\run/R3load.exe: START OF LOG: 20071018195314

C:\usr\sap\BW1\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

C:\usr\sap\BW1\SYS\exe\run/R3load.exe: version R6.40/V1.4

Compiled Nov 30 2005 20:41:21

C:\usr\sap\BW1\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\NW04\SYSTEM\ABAP\ORA\NUC\DB/SAPSSRC.cmd -l C:\Program Files\sapinst_instdir\NW04\SYSTEM\ABAP\ORA\NUC\DB/SAPSSRC.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): WE8DEC

(DB) ERROR: DDL statement failed

(DROP INDEX "APTREET~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 in exec_immediate()

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "APTREET~0" ON "APTREET" ( "SPRAS", "ID", "NAME" ) TABLESPACE PSAPBW1 STORAGE (INITIAL 44981 NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

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

C:\usr\sap\BW1\SYS\exe\run/R3load.exe: job finished with 1 error(s)

C:\usr\sap\BW1\SYS\exe\run/R3load.exe: END OF LOG: 20071018195315

_______________

I'm getting this error "duplicate keys found". I'm finished installing the central instance and during the database instance, i got this error. I'm installing BW 3.5 on x64 windows server 2003 platform. I'm using NU kernel 6.40.

Thanks for your suggestions on how to resolve this error.

Reward points guaranteed.

[Former Member]

This issue was resolved by properly deleting the central and database instance.

We have started a new build and it finished without an error.

Thanks.

[JPReyes]

Hi Joseph...

Seems like table APTREET has duplicated indexes... you may have to delete and recreate this index again ...

Also.. read this notes..

11369 - ORA-1452 during import after export from other system

617679 - Error due to incomplete column definitions

Regards

Juan

Please reward wity points if helpful