on 03-13-2007 11:15 PM
I'm trying to install CRM 5.0 SR1 in Windows 2003 with Oracle 10.2 using system copy.
In the phase 19 of 34 of overall process an error ocurred:
Here is part of the import_monitor.log :
-
INFO: 2007-03-13 17:45:16
Data codepage 4103 is determined using TOC file 'F:\export\ABAP\DATA\D010INC.TOC' for package 'D010INC'.
TRACE: 2007-03-13 17:45:16 com.sap.inst.migmon.LoadTask run
Loading of 'SAPAPPL2_2' import package is started.
TRACE: 2007-03-13 17:45:16 com.sap.inst.migmon.LoadTask processPackage
Loading of 'SAPAPPL2_2' import package into database:
D:\usr\sap\CRD\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL2_2.cmd -dbcodepage 4103 -l SAPAPPL2_2.log -stop_on_error
ERROR: 2007-03-13 17:45:16 com.sap.inst.migmon.LoadTask run
Loading of 'SAPAPPL2_2' import package is interrupted with R3load error.
Process 'D:\usr\sap\CRD\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL2_2.cmd -dbcodepage 4103 -l SAPAPPL2_2.log -stop_on_error' exited with return code 2.
For mode details see 'SAPAPPL2_2.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: 2007-03-13 17:45:45
Cannot start import of packages with views because not all import packages with tables are loaded successfully.
WARNING: 2007-03-13 17:45:45
1 error(s) during processing of packages.
INFO: 2007-03-13 17:45:45
Import Monitor is stopped.
-
And here is part of the SAPAPPL2_2.log file:
(DB) INFO: THOLT created #20070313112649
(IMP) INFO: import of THOLT completed (42288 rows) #20070313112649
DbSl Trace: ORA-1452 occurred when executing SQL statement (parse error offset=33)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "THOLT~0" ON "THOLT" ( "FTGID", "SPRAS" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 131072 NEXT 0000000040K 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
D:\usr\sap\CRD\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
D:\usr\sap\CRD\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20070313112650
D:\usr\sap\CRD\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20070313114516
D:\usr\sap\CRD\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP
D:\usr\sap\CRD\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Sep 1 2006 00:38:35
D:\usr\sap\CRD\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL2_2.cmd -dbcodepage 4103 -l SAPAPPL2_2.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 = "DBC20070313100333 "
(GSI) INFO: vname = "ORACLE "
(GSI) INFO: hostname = "SDCRMGDL "
(GSI) INFO: sysname = "Windows NT"
(GSI) INFO: nodename = "SDCRMGDL"
(GSI) INFO: release = "5.2"
(GSI) INFO: version = "3790 Service Pack 1"
(GSI) INFO: machine = "2x Intel 801586 (Mod 2 Step 9)"
(DB) ERROR: DDL statement failed
(DROP INDEX "THOLT~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=33)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "THOLT~0" ON "THOLT" ( "FTGID", "SPRAS" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 131072 NEXT 0000000040K 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
D:\usr\sap\CRD\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
D:\usr\sap\CRD\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20070313114516
-
Does anyone could help me finding the solution for this problem???
Thanks.
<b>ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found</b>
you could either exclude the index from being created at this point and create it later when the import is finished (you'll need to edit the corresponding TOC, TSK and STR-Files) or try to solve the problem by checking sapnotes 541.538, 23.237 & 11.369...was the installation interrupted before in r3load phase SAPAPPL2???
GreetZ, AH
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Armando, did you read what i posted?
-> of course did the import stop in the r3load phase
-> there is an error concering the sappappl2 package
-> in order to overcome this error you have to either
a) exclude the index from being created -> edit the relevant toc & str-file(s)
b) check the mentioned sapnotes
my intention regarding any other interruptions is to know more about the situation...the duplicate key error can also occur when certain tables/indices have already been created and the r3load tries to create/fill them again after being invoked again (another interruption situation)...check for any .BCK files in your temporary installation directory (where all logs are written)
GreetZ, AH
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
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.