cancel
Showing results for 
Search instead for 
Did you mean: 

ERROR AT IMPORT ABAP

Former Member
0 Kudos

I started a freshSAP ERP 2005 IDES ECC6.0 installation using ORACLE, after 14 of the 19 Import monitor jobs have been completed I got an Error message; see the log below:

WARNING 2011-05-18 21:04:50

Execution of the command "C:\j2sdk1.4.2_17-x64\bin\java.exe -classpath migmon.jar -showversion com.sap.inst.migmon.imp.ImportMonitor -dbType ORA -importDirs
Vboxsvr\erp\51032413_1\EXP1;
Vboxsvr\erp\51032413_2\EXP2;
Vboxsvr\erp\51032413_3\EXP3;
Vboxsvr\erp\51032413_4\EXP4;
Vboxsvr\erp\51032413_5\EXP5;
Vboxsvr\erp\51032413_6\EXP6;
Vboxsvr\erp\51032413_6\EXP7;
Vboxsvr\erp\51032413_6\EXP8;
Vboxsvr\erp\51032413_6\EXP9;
Vboxsvr\erp\51032413_6\EXP10;
Vboxsvr\erp\51032413_6\EXP11 -installDir "C:\Program Files\sapinst_instdir\ERP\SYSTEM\ORA\CENTRAL\AS" -orderBy "" -r3loadExe C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe -tskFiles yes -extFiles yes -dbCodepage 4103 -jobNum 5 -monitorTimeout 30 -loadArgs " -stop_on_error" -trace all -sapinst" finished with return code 103. Output: java version "1.4.2_17"Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_17-b06)Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_17-b06, mixed mode)Import Monitor jobs: running 1, waiting 4, completed 14, failed 0, total 19.Import Monitor jobs: running 2, waiting 3, completed 14, failed 0, total 19.Import Monitor jobs: running 3, waiting 2, completed 14, failed 0, total 19.Import Monitor jobs: running 4, waiting 1, completed 14, failed 0, total 19.Loading of 'SAPAPPL1' import package: ERRORImport Monitor jobs: running 3, waiting 1, completed 14, failed 1, total 19.Loading of 'SAPAPPL2' import package: ERRORImport Monitor jobs: running 2, waiting 1, completed 14, failed 2, total 19.Loading of 'SAPSSEXC' import package: ERRORImport Monitor jobs: running 1, waiting 1, completed 14, failed 3, total 19.Loading of 'SAPAPPL0' import package: ERRORImport Monitor jobs: running 0, waiting 1, completed 14, failed 4, total 19.

ERROR 2011-05-18 21:04:50

CJS-30022 Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.

ERROR 2011-05-18 21:04:50

FCO-00011 The step runMigrationMonitor with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|5|0|NW_ABAP_Import|ind|ind|ind|ind|0|0|runMigrationMonitor was executed with status ERROR .

Experts please help, I need idiot solutions

Thanks.

Lane

Accepted Solutions (0)

Answers (11)

Answers (11)

0 Kudos

I have error as showing following error:

(SQL) INFO: SQLFiles.LST not found**

(SQL) INFO: POOL.SQL not found**

=====================

java version "1.4.2_06"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_06-b03)

Java HotSpot(TM) Client VM (build 1.4.2_06-b03, mixed mode)

Import Monitor jobs: running 1, waiting 2, completed 34, failed 0, total 37.

Import Monitor jobs: running 2, waiting 1, completed 34, failed 0, total 37.

Loading of 'ATAB' import package: ERROR

Import Monitor jobs: running 1, waiting 1, completed 34, failed 1, total 37.

Loading of 'REPOSRC' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 34, failed 2, total 37.

=====================

INFO: 2011-08-06 06:05:43

Data codepage 4103 is determined using TOC file 'K:\Software\SAP ABAP Netware 7.02 sp2\SAP_NetWeaver_702e_Export\DATA_UNITS\EXP1\DATA\ATAB.TOC' for package 'ATAB'.

TRACE: 2011-08-06 06:05:43 com.sap.inst.migmon.LoadTask run

Loading of 'ATAB' import package is started.

TRACE: 2011-08-06 06:05:43 com.sap.inst.migmon.LoadTask run

Loading of 'REPOSRC' import package is started.

INFO: 2011-08-06 06:05:43 com.sap.inst.migmon.LoadTask processPackage

Task file 'D:\Program Files\sapinst_instdir\NW702\AS-ABAP\ADA\CENTRAL\REPOSRC.TSK' from package 'REPOSRC' contains no tasks with data type (D).

TRACE: 2011-08-06 06:05:44 com.sap.inst.migmon.LoadTask processPackage

Loading of 'ATAB' import package into database:

K:\usr\sap\NSP\SYS\exe\uc\NTI386\R3load.exe -i ATAB.cmd -dbcodepage 4103 -l ATAB.log -nolog -c 50000 -force_repeat -loadprocedure dbsl

TRACE: 2011-08-06 06:05:44 com.sap.inst.migmon.LoadTask processPackage

Loading of 'REPOSRC' import package into database:

K:\usr\sap\NSP\SYS\exe\uc\NTI386\R3load.exe -i REPOSRC.cmd -dbcodepage 4103 -l REPOSRC.log -nolog -c 50000 -force_repeat -loadprocedure dbsl

ERROR: 2011-08-06 06:05:44 com.sap.inst.migmon.LoadTask run

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

Process 'K:\usr\sap\NSP\SYS\exe\uc\NTI386\R3load.exe -i ATAB.cmd -dbcodepage 4103 -l ATAB.log -nolog -c 50000 -force_repeat -loadprocedure dbsl' exited with return code 2.

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

ERROR: 2011-08-06 06:05:44 com.sap.inst.migmon.LoadTask run

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

Process 'K:\usr\sap\NSP\SYS\exe\uc\NTI386\R3load.exe -i REPOSRC.cmd -dbcodepage 4103 -l REPOSRC.log -nolog -c 50000 -force_repeat -loadprocedure dbsl' exited with return code 2.

For mode details see 'REPOSRC.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: 2011-08-06 06:06:13

Cannot start import of packages with views because not all import packages with tables are loaded successfully.

WARNING: 2011-08-06 06:06:13

2 error(s) during processing of packages.

INFO: 2011-08-06 06:06:13

Import Monitor is stopped.

0 Kudos

INFO: 2011-08-06 06:05:43

Data codepage 4103 is determined using TOC file 'K:\Software\SAP ABAP Netware 7.02 sp2\SAP_NetWeaver_702e_Export\DATA_UNITS\EXP1\DATA\ATAB.TOC' for package 'ATAB'.

TRACE: 2011-08-06 06:05:43 com.sap.inst.migmon.LoadTask run

Loading of 'ATAB' import package is started.

TRACE: 2011-08-06 06:05:43 com.sap.inst.migmon.LoadTask run

Loading of 'REPOSRC' import package is started.

INFO: 2011-08-06 06:05:43 com.sap.inst.migmon.LoadTask processPackage

Task file 'D:\Program Files\sapinst_instdir\NW702\AS-ABAP\ADA\CENTRAL\REPOSRC.TSK' from package 'REPOSRC' contains no tasks with data type (D).

TRACE: 2011-08-06 06:05:44 com.sap.inst.migmon.LoadTask processPackage

Loading of 'ATAB' import package into database:

K:\usr\sap\NSP\SYS\exe\uc\NTI386\R3load.exe -i ATAB.cmd -dbcodepage 4103 -l ATAB.log -nolog -c 50000 -force_repeat -loadprocedure dbsl

TRACE: 2011-08-06 06:05:44 com.sap.inst.migmon.LoadTask processPackage

Loading of 'REPOSRC' import package into database:

K:\usr\sap\NSP\SYS\exe\uc\NTI386\R3load.exe -i REPOSRC.cmd -dbcodepage 4103 -l REPOSRC.log -nolog -c 50000 -force_repeat -loadprocedure dbsl

ERROR: 2011-08-06 06:05:44 com.sap.inst.migmon.LoadTask run

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

Process 'K:\usr\sap\NSP\SYS\exe\uc\NTI386\R3load.exe -i ATAB.cmd -dbcodepage 4103 -l ATAB.log -nolog -c 50000 -force_repeat -loadprocedure dbsl' exited with return code 2.

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

ERROR: 2011-08-06 06:05:44 com.sap.inst.migmon.LoadTask run

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

Process 'K:\usr\sap\NSP\SYS\exe\uc\NTI386\R3load.exe -i REPOSRC.cmd -dbcodepage 4103 -l REPOSRC.log -nolog -c 50000 -force_repeat -loadprocedure dbsl' exited with return code 2.

For mode details see 'REPOSRC.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: 2011-08-06 06:06:13

Cannot start import of packages with views because not all import packages with tables are loaded successfully.

WARNING: 2011-08-06 06:06:13

2 error(s) during processing of packages.

INFO: 2011-08-06 06:06:13

Import Monitor is stopped.

Former Member
0 Kudos

Hi,

First of all, could you provide the question, in words?

ERROR: 2011-08-06 06:05:44 com.sap.inst.migmon.LoadTask run
Loading of 'ATAB' import package is interrupted with R3load error.
Process 'K:\usr\sap\NSP\SYS\exe\uc\NTI386\R3load.exe -i ATAB.cmd -dbcodepage 4103 -l ATAB.log -nolog -c 50000 -force_repeat -loadprocedure dbsl' exited with return code 2.
For mode details see 'ATAB.log' file.

ERROR: 2011-08-06 06:05:44 com.sap.inst.migmon.LoadTask run
Loading of 'REPOSRC' import package is interrupted with R3load error.
Process 'K:\usr\sap\NSP\SYS\exe\uc\NTI386\R3load.exe -i REPOSRC.cmd -dbcodepage 4103 -l REPOSRC.log -nolog -c 50000 -force_repeat -loadprocedure dbsl' exited with return code 2.
For mode details see 'REPOSRC.log' file.

Check the "ATAB.log" and "REPOSRC.log" trace files, in ordcer to identify the root cause.

Best regards,

Orkun Gedik

Former Member
0 Kudos

hi lane,

please check your tablespaces, if they are full extend them and hit retry.

Regards,

shanser

Former Member
0 Kudos

@ Mohit,

I dont have access to SAP NOTES, am a university student installing trial version for study purpose.

thanks

Former Member
0 Kudos

Hi,

Without access to the SAP market place, its impossible to to get access to the SAP Notes.

The versions you are trying to install is an IDES version, its not exactly a trial version.

Check if the value of the parameter SHARED_POOL_SIZE is more than 400mb.

It has to be 400mb or more. It again depends on the number of CPUs you are using.

Try this

sqlplus>show parameter shared_pool_size

sqlplus>alter system set shared_pool_size=1235;

The new size should be 20 % more then the present value,.i.e. out put from

first command. This way you can increase the value of the shared pool dynamically, other way is

in ORACLE_HOME/dbs/initSID.ora file this parameter is there change the value and save the

file then you need to shutdown and restart the database to make this new value effective.

Also let us know the hardware configuration that you are using.

Regards,

Vishnu

Former Member
0 Kudos

@ Vishnu:

SAPSSEXC:

(DB) INFO: DM45T~0 created #20110518185234

(DB) INFO: DM46S created #20110518185234

(IMP) INFO: import of DM46S completed (1796 rows) #20110518185234

(DB) INFO: DM46S~0 created #20110518185234

(DB) INFO: DM46S~A created #20110518185234

(DB) INFO: DOKCLU created #20110518185235

DbSl Trace: Error 4031 in stmt_execute() from oci_execute_stmt(), orpc=14

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

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 99, table "DOKCLU"

(SQL error 4031)

error message returned by DbSl:

ORA-04031: unable to allocate 808 bytes of shared memory ("shared pool","select name,intcol#,segcol#,...","Typecheck","seg:kggfaAllocSeg")

(DB) INFO: disconnected from DB

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

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110518190354

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110518203751

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

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

Compiled Jul 17 2007 00:40:17

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -l SAPSSEXC.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: DOKCLU deleted/truncated #20110518203952

DbSl Trace: Error 604 in stmt_execute() from oci_execute_stmt(), orpc=0

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

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 99, table "DOKCLU"

(SQL error 604)

error message returned by DbSl:

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select name,password,datats#...","Typecheck","kgghteInit")

(DB) INFO: disconnected from DB

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

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110518210159

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110518231239

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

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

Compiled Jul 17 2007 00:40:17

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -l SAPSSEXC.log -stop_on_error

DbSl Trace: Failed to register client info: orc=604

DbSl Trace: ORA-604 when accessing table SAPUSER

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=604

DbSl Trace: CONNECT failed with sql error '604'

(DB) ERROR: db_connect rc = 256

DbSl Trace: Failed to register client info: orc=4031

DbSl Trace: ORA-604 when accessing table SAPUSER

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=604

DbSl Trace: CONNECT failed with sql error '604'

(DB) ERROR: DbSlErrorMsg rc = 99

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

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110518231242

Former Member
0 Kudos

Please try this SAP Note 690241.

Thanks..

Mohit

Former Member
0 Kudos

@Vishnu

SAPAPPL2:

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

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110518210144

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110518231239

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

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

Compiled Jul 17 2007 00:40:17

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe -i SAPAPPL2.cmd -dbcodepage 4103 -l SAPAPPL2.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=604

DbSl Trace: CONNECT failed with sql error '604'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=604

DbSl Trace: CONNECT failed with sql error '604'

(DB) ERROR: db_connect rc = 256

DbSl Trace: Failed to register client info: orc=4031

DbSl Trace: ORA-604 when accessing table SAPUSER

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=604

DbSl Trace: CONNECT failed with sql error '604'

(DB) ERROR: DbSlErrorMsg rc = 99

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

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110518231242

Former Member
0 Kudos

@Vishnu (I mailed the comprehensive logs to you)

SAPAPPL1:

(IMP) INFO: import of MC13VD0ITMSETUP completed (1659818 rows) #20110518175813

(DB) INFO: MC13VD0ITMSETUP~0 created #20110518180229

(DB) INFO: MC13VD0KONSETUP created #20110518180230

DbSl Trace: Error 604 in stmt_execute() from oci_execute_stmt(), orpc=0

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

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 99, table "MC13VD0KONSETUP"

(SQL error 604)

error message returned by DbSl:

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select local_tran_id, global...","Typecheck","kgghteInit")

(DB) INFO: disconnected from DB

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

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110518180532

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110518203751

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

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

Compiled Jul 17 2007 00:40:17

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe -i SAPAPPL1.cmd -dbcodepage 4103 -l SAPAPPL1.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: MC13VD0KONSETUP deleted/truncated #20110518205931

DbSl Trace: Error 4031 in stmt_execute() from oci_execute_stmt(), orpc=17

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

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 99, table "MC13VD0KONSETUP"

(SQL error 4031)

error message returned by DbSl:

ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select name,online$,contents...","Typecheck","seg:kggfaAllocSeg")

(DB) INFO: disconnected from DB

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

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110518210143

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110518231239

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

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

Compiled Jul 17 2007 00:40:17

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe -i SAPAPPL1.cmd -dbcodepage 4103 -l SAPAPPL1.log -stop_on_error

DbSl Trace: Failed to register client info: orc=604

DbSl Trace: ORA-604 when accessing table SAPUSER

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=604

DbSl Trace: CONNECT failed with sql error '604'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=604

DbSl Trace: CONNECT failed with sql error '604'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=604

DbSl Trace: CONNECT failed with sql error '604'

(DB) ERROR: DbSlErrorMsg rc = 99

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

C:\usr\sap\ECC\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110518231242

Former Member
0 Kudos

@Vishnu,

the logs you requested are too long, each of them is more than the 15000 max character allowed on the forum for a post.

Way forward?

Thanks

Former Member
0 Kudos

Hi,

Just the last few lines from each log file, which indicate the error should be enough.

Regards,

Vishnu.

Former Member
0 Kudos

at Jagadish:

I defined 5 parallel jobs.

Thanks

Former Member
0 Kudos

Hi Lane,

How many parellel processes you have defined for the import?

Thanks,

Jagadish

Former Member
0 Kudos

Hi,

Copy paste the error logs from SAPAPPL0.log, SAPAPPL1.log, SAPAPPL2.log, SAPSSEXC.log files

from the installation directory under C:/ drive.

Regards,

Vishnu