on 08-06-2008 5:47 AM
SAPSDIC.log
DbSl Trace: ORA-1452 occurred when executing SQL statement (parse error offset=34)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "F4UHLP~0" ON "F4UHLP" ( "MANDT", "USERNAME", "TABFIELD", "FIELDFIELD", "VALUE" ) TABLESPACE PSAPPDR STORAGE (INITIAL 1556384 NEXT 0000000080K 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
G:\usr\sap\PDR\SYS\exe\nuc\NTI386\R3load.exe: job finished with 1 error(s)
G:\usr\sap\PDR\SYS\exe\nuc\NTI386\R3load.exe: END OF LOG: 20090803230937
G:\usr\sap\PDR\SYS\exe\nuc\NTI386\R3load.exe: START OF LOG: 20090803232927
G:\usr\sap\PDR\SYS\exe\nuc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP
G:\usr\sap\PDR\SYS\exe\nuc\NTI386\R3load.exe: version R7.00/V1.4
Compiled Sep 1 2006 00:30:56
G:\usr\sap\PDR\SYS\exe\nuc\NTI386\R3load.exe -i SAPSDIC.cmd -dbcodepage 1100 -l SAPSDIC.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 "F4UHLP~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: ORA-1452 occurred when executing SQL statement (parse error offset=34)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "F4UHLP~0" ON "F4UHLP" ( "MANDT", "USERNAME", "TABFIELD", "FIELDFIELD", "VALUE" ) TABLESPACE PSAPPDR STORAGE (INITIAL 1556384 NEXT 0000000080K 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
G:\usr\sap\PDR\SYS\exe\nuc\NTI386\R3load.exe: job finished with 1 error(s)
G:\usr\sap\PDR\SYS\exe\nuc\NTI386\R3load.exe: END OF LOG: 20090803232927
-
ERROR: 2009-08-03 23:29:27 com.sap.inst.migmon.LoadTask run
Loading of 'SAPSDIC' import package is interrupted with R3load error.
Process 'G:\usr\sap\PDR\SYS\exe\nuc\NTI386\R3load.exe -i SAPSDIC.cmd -dbcodepage 1100 -l SAPSDIC.log -stop_on_error' exited with return code 2.
For mode details see 'SAPSDIC.log' file.
Standard error output:
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
WARNING: 2009-08-03 23:29:53
Cannot continue import because not all import packages with data conversion tables are loaded successfully.
WARNING: 2009-08-03 23:29:53
1 error(s) during processing of packages.
INFO: 2009-08-03 23:29:53
Import Monitor is stopped.
-
java version "1.4.2_17"
Java(TM) 2 Runtime Environment, Stan
dard Edition (build 1.4.2_17-b06)
Java HotSpot(TM) Client VM (build 1.4.2_17-b06, mixed mode)
Import Monitor jobs: running 1, waiting 18, completed 0, failed 0, total 19.
Loading of 'SAPSDIC' import package: ERROR
Import Monitor jobs: running 0, waiting 18, completed 0, failed 1, total 19.
I am using oracle as DB , Ecc 6.0 installation stops at this step
Please help
Edited by: Ritesh Harishchandra Soni on Aug 6, 2008 6:49 AM
Hi,
Check below link and check if you can create those at oracle level
http://www.techonthenet.com/oracle/errors/ora01452.php
Regards
Ashok
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For the error message ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found. I would suggest to edit the related TSK file and replace "err" by "ok" in the file. Then continue the installation without any problem. You will be able to create this index later on in db02 if needed.
Best regards,
Olivier
Dear Rithesh,
Please refer below SAP notes for the solution. Defenitely it will resolve.
11369 ORA-1452 during import after export from other system
617679 Error due to incomplete column definitions
Please let me know if you need any more help.
Thanks
Kishore
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.