cancel
Showing results for 
Search instead for 
Did you mean: 

Loading of SAPAPPL2_2 import package is interrupted

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

andreas_herzog
Active Contributor
0 Kudos

<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

Former Member
0 Kudos

Hi Andreas,

As far as I know the installation was interrupted in SAPAPPL2 r3load phase, so it didn't finished.

Thank you.

andreas_herzog
Active Contributor
0 Kudos

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