IMPORT monitor Job failed

[Former Member]

Hi SAP experts,

My installation of ECC6 fails while importing at completed 36, running 1, waiting 1, total of 38. My OS is windows 2003 and ORACLE 10.2G. Hardware specs is quad core and 2GB RAM ONLY.

Heres the log from import_monitor_java_log.txt

Import Monitor jobs: running 2, waiting 1, completed 35, failed 0, total 38.
Loading of 'SAPDODS' import package: OK
Import Monitor jobs: running 1, waiting 1, completed 36, failed 0, total 38.
Loading of 'SAPSSEXC_3' import package: ERROR
Import Monitor jobs: running 0, waiting 1, completed 36, failed 1, total 38.

another log from SAPSSEXC_3.LOG.txt

D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSSEXC_3.cmd -dbcodepage 4103 -l SAPSSEXC_3.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: REPOSRC deleted/truncated #20091223091035

DbSl Trace: OCI-call 'OCILobWrite' failed: rc = 604

DbSl Trace: ORA-604 occurred when writing to a LOB

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed
  rc = 99, table "REPOSRC"
  (SQL error 604)
  error message returned by DbSl:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4024 bytes of shared memory ("shared pool","select o.owner#,o.name,o.nam...","Typecheck","seg:kggfaAllocSeg")
(DB) INFO: disconnected from DB

D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)
D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20091223100041

D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20091223100500

D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP
D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Sep  1 2006 00:36:46
D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSSEXC_3.cmd -dbcodepage 4103 -l SAPSSEXC_3.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: REPOSRC deleted/truncated #20091223100506

Thank you in advance.

[Former Member · Accepted solution]

Hi Joel,

This is a common error during installation when the RAM is less. To solve this error, please do the following:

Without closing the sapinst, login as <SID>adm user on OS level

Open Command prompt

Login to SQLplus

shutdown immediate; ( shutdown the database )

once its successfully shutdown, start it up using:

startup;

After the database is back up, go to the SAPinst and click "retry". It should work.

Regards,

Jazz

[Former Member · Accepted solution]

Hi Jazz,

That resolve the issue.

Thank you.

Joel

[Former Member]

Hi

I am also getting the following error.. Import jobs failed 18

pls help me.

And I tried the following scenario also.. but no use :

Without closing the sapinst, login as <SID>adm user on OS level

Open Command prompt

Login to SQLplus

shutdown immediate;  ( shutdown the database )

once its successfully shutdown, start it up using:

startup;

Thanks & rgds

Nagendra

[Former Member]

In my case I believed that installation was stopped in the step import ABAP message: "running 1, waiting 1, completed 36, total of 38  because I hadn't any message about the progress.

After 3 to 4 hours the progress bar continue the next task.

I will tell you how it ends, the installation still continues.

Regards,

[Former Member]

Hi,

Try increasing the shared pool size to a desirable level and retry.

alter system set shared_pool_size='value'

regards,

[peter_dzurov]

You can check also SAP Note Number: [869006|https://service.sap.com/sap/support/notes/869006] for more information.

[former_member227283]

Hi Jeol,

Did you tried complete OS restart and restart the phase of installtion from the point error.

If it doen't resolve the issue then pls paste the content of initPRD.ora in forum.

Thanks

Anil