cancel
Showing results for 
Search instead for 
Did you mean: 

System Copy for ECC6 SR3 - Error in Import ABAP phase

Former Member
0 Kudos

Dear Experts,

I am performing system copy on WIN2003 64 bit platform. During Traget System Instalation in System Copy for ECC6 SR3 with Single ABAP stack and Ora 10.2.0.4 I am seeing foolowing errors in my import_monitor.log file.

TRACE: 2011-05-31 12:31:30 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SAPSLEXC' import package into database:

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLEXC.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPSLEXC.log -stop_on_error

ERROR: 2011-05-31 12:31:35 com.sap.inst.migmon.LoadTask run

Loading of 'SAPSLEXC' import package is interrupted with R3load error.

Process 'E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLEXC.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPSLEXC.log -stop_on_error' exited with return code 2.

For mode details see 'SAPSLEXC.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

TRACE: 2011-05-31 12:39:00 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SAP0000' import package into database:

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe -i SAP0000.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAP0000.log -stop_on_error

ERROR: 2011-05-31 12:39:03 com.sap.inst.migmon.LoadTask run

Loading of 'SAP0000' import package is interrupted with R3load error.

Process 'E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe -i SAP0000.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAP0000.log -stop_on_error' exited with return code 2.

For mode details see 'SAP0000.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

I am using MIGMON patch 6. I replced the old SAr file under INSTALL directory with the new MIGMON.SAR file.

I have rerun the installtion twice but I get stuck at the same point.

Please suggest why I am seeing this error.

Thanks.

Will post the errors from 'SAP0000.log' and 'SAPSLEXC.log' in separate post.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

SAP note 957917 - ORA: Conversion from old to new tablespace layout resolved the issue.

Former Member
0 Kudos

Hi,

re-Starts the installtion with SIDadm finishes successfuly.

Regards

balaji

Former Member
0 Kudos

SAPSLEXEC.log

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110531123129

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

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

Compiled Oct 31 2010 23:05:11

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe -ctf I F:\TempStorage\SIGMA\ABAP\DATA\SAPSLEXC.STR C:\Program Files\sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP\DDLORA.TPL SAPSLEXC.TSK ORA -l SAPSLEXC.log

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe: job completed

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110531123129

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110531123130

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

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

Compiled Oct 31 2010 23:05:11

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLEXC.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAPSLEXC.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 = "SE120110531110506 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "RPBVA4001 "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "RPBVA4001"

(GSI) INFO: release = "5.2"

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

(GSI) INFO: machine = "4x AMD64 Level 16 (Mod 9 Step 1)"

(DB) INFO: CO2MAP created #20110531123134

(IMP) INFO: import of CO2MAP completed (35 rows) #20110531123134

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

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "CO2MAP~0" ON "CO2MAP" ( "ID", "SRCLINE" ) TABLESPACE PSAPSR3620 STORAGE (INITIAL 65536 NEXT 0000000640K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 959)

error message returned by DbSl:

ORA-00959: tablespace 'PSAPSR3620' does not exist

(DB) INFO: disconnected from DB

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

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110531123134

Former Member
0 Kudos

Dear,

as per error message

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "CO2MAP~0" ON "CO2MAP" ( "ID", "SRCLINE" ) TABLESPACE PSAPSR3620 STORAGE (INITIAL 65536 NEXT 0000000640K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 959)

error message returned by DbSl:

ORA-00959: tablespace 'PSAPSR3620' does not exist

(DB) INFO: disconnected from DB

system trying to create unique index on tablespace PSAPSR3620 which does not exist.

If you are running on ECC 6.0 SR3 then there will be tablespace PSAPSR3700 not PSAPSR3620.

Kinldy check your source system and confirm.

Regards,

Nikunj Thaker

Former Member
0 Kudos

Thanks for your reply Sir!!

We resolved the prolem using :

957917 - ORA: Conversion from old to new tablespace layout

Thanks!!

Former Member
0 Kudos

'SAP0000.log

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110531123900

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

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

Compiled Oct 31 2010 23:05:11

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe -ctf I F:\TempStorage\SIGMA\ABAP\DATA\SAP0000.STR C:\Program Files\sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP\DDLORA.TPL SAP0000.TSK ORA -l SAP0000.log -o D

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe: job completed

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110531123900

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110531123900

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

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

Compiled Oct 31 2010 23:05:11

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe -i SAP0000.cmd -dbcodepage 4103 -k 1G5fdEM50DmIrBzjt6TE5Pae -l SAP0000.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

(DB) INFO: REPOLOAD created #20110531123903

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

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "REPOLOAD~0" ON "REPOLOAD" ( "PROGNAME", "R3STATE", "MACH" ) TABLESPACE PSAPSR3620 STORAGE (INITIAL 13704192 NEXT 0000010240K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 959)

error message returned by DbSl:

ORA-00959: tablespace 'PSAPSR3620' does not exist

(DB) INFO: disconnected from DB

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

E:\usr\sap\SE1\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110531123903