SAP Help Site


RE: [sap-basis] Sap Ides Import Abap error

Posted by LEH (CEO & Senior Consultant)
on 08/10/2008 10:53:00 PM


Hi,

You need to increase the shared memory in your Oracle instance.
It’s the parameters below that are related to this.

shared_pool_size
shared_pool_reserved _size

Restart Oracle after applying the changes.

Regards,
LEH

From: niroukas via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 10. august 2008 11:41
To: LEH
Subject: RE:[sap-basis] Sap Ides Import Abap error

Thank you LEH,
I checked SAPAPPL2.log but i couldn’t find what is going wrong. I am posting
the last part of it:
(DB) INFO: T811X~001 created #20080810061841
DbSl Trace: Error 604 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-604 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE TABLE “T811Z” ( “MANDT” VARCHAR2(9) DEFAULT ‘000’ NOT NULL , “TAB”
VARCHAR2(90) DEFAULT ‘ ‘ NOT NULL , “ALART” VARCHAR2(3) DEFAULT ‘ ‘ NOT NULL
, “IPKNZ” VARCHAR2(3) DEFAULT ‘ ‘ NOT NULL , “ID” NUMBER(21,7) DEFAULT 0 NOT
NULL , “SDATE” VARCHAR2(24) DEFAULT ‘00000000’ NOT NULL , “STIME”
VARCHAR2(18) DEFAULT ‘000000’ NOT NULL , “UNAME” VARCHAR2(36) DEFAULT ‘ ‘
NOT NULL , “TEST” VARCHAR2(3) DEFAULT ‘ ‘ NOT NULL , “DURATION” NUMBER(10)
DEFAULT 0 NOT NULL , “DB_SELECT” VARCHAR2(3) DEFAULT ‘0’ NOT NULL )
TABLESPACE PSAPSR3 STORAGE (INITIAL 16384 NEXT 0000000040K MINEXTENTS
0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )
DbSlExecute: rc = 99
(SQL error 604)
error message returned by DbSl:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4108 bytes of shared memory (“shared
pool”,”update seg$ set type#=:4,blo…”,”Typecheck”,”seg:kggfaAllocSeg”)
(DB) INFO: disconnected from DB
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20080810061842
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20080810102719
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id:
//bas/700_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Jul 17 2007 01:28:45
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL2.cmd -dbcodepage 4103
-l SAPAPPL2.log -stop_on_error
DbSl Trace: OCI-call ‘OCIServerAttach’ failed with rc=12541
DbSl Trace: CONNECT failed with sql error ‘12541’
DbSl Trace: OCI-call ‘OCIServerAttach’ failed with rc=12541
DbSl Trace: CONNECT failed with sql error ‘12541’
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call ‘OCIServerAttach’ failed with rc=12541
DbSl Trace: CONNECT failed with sql error ‘12541’
DbSl Trace: OCI-call ‘OCIServerAttach’ failed with rc=12541
DbSl Trace: CONNECT failed with sql error ‘12541’
(DB) ERROR: DbSlErrorMsg rc = 99
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20080810102725
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20080810104919
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id:
//bas/700_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Jul 17 2007 01:28:45
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL2.cmd -dbcodepage 4103
-l SAPAPPL2.log -stop_on_error
DbSl Trace: OCI-call ‘OCISessionBegin’ failed with rc=1034
DbSl Trace: CONNECT failed with sql error ‘1034’
DbSl Trace: OCI-call ‘OCISessionBegin’ failed with rc=1034
DbSl Trace: CONNECT failed with sql error ‘1034’
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call ‘OCISessionBegin’ failed with rc=1034
DbSl Trace: CONNECT failed with sql error ‘1034’
DbSl Trace: OCI-call ‘OCISessionBegin’ failed with rc=1034
DbSl Trace: CONNECT failed with sql error ‘1034’
(DB) ERROR: DbSlErrorMsg rc = 99
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20080810104919
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20080810105152
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id:
//bas/700_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Jul 17 2007 01:28:45
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL2.cmd -dbcodepage 4103
-l SAPAPPL2.log -stop_on_error
DbSl Trace: OCI-call ‘OCISessionBegin’ failed with rc=1034
DbSl Trace: CONNECT failed with sql error ‘1034’
DbSl Trace: OCI-call ‘OCISessionBegin’ failed with rc=1034
DbSl Trace: CONNECT failed with sql error ‘1034’
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call ‘OCISessionBegin’ failed with rc=1034
DbSl Trace: CONNECT failed with sql error ‘1034’
DbSl Trace: OCI-call ‘OCISessionBegin’ failed with rc=1034
DbSl Trace: CONNECT failed with sql error ‘1034’
(DB) ERROR: DbSlErrorMsg rc = 99
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)
D:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20080810105152
—–Original Message—–
Hi all,I am new to Sap and i am trying to install Ides. I have downloaded
the files from service.sap.com three times and i get alway an error in the
phase of Abap importing.
ERROR 2008-08-09 14:02:35CJS-30022 Program ‘Migration Monitor’ exits with
error code 103. For details see log file(s) import_monitor.java.log,
import_monitor.log.ERROR 2008-08-09 14:02:35FCO-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|runMigrationMoni tor was executed with
status ERROR .
import_monitor.logINFO: 2008-08-09 14:02:05Import Monitor is started.
CONFIG: 2008-08-09 14:02:05Application
options:dbCodepageA03dbType=ORAextFiles=yesimportDirs=F:\IDES\SAP IDES
EXPORT DVD1\EXP1;F:\IDES\SAP IDES EXPORT DVD2\EXP2;F:\IDES\SAP IDES EXPORT
DVD3\EXP3;F:\IDES\SAP IDES EXPORT DVD4\EXP4;F:\IDES\SAP IDES EXPORT
DVD5\EXP5;F:\IDES\SAP IDES EXPORT DVD6\EXP6;F:\IDES\SAP IDES EXPORT
DVD6\EXP7;F:\IDES\SAP IDES EXPORT DVD6\EXP8;F:\IDES\SAP IDES EXPORT
DVD6\EXP9;F:\IDES\SAP IDES EXPORT DVD6\EXP10;F:\IDES\SAP IDES EXPORT
DVD6\EXP11installDir=C:\Program
Files\sapinst_instdir\ERP\SYSTEM\ORA\CENTRAL\ASjobNum=3loadArgs-stop_on_errormonitorTimeout0orderByr3loadExe=F:\usr\sap\NIR\SYS\exe\uc\NTI3
86\R 3load.exesapinsttrace=alltskFiles=yes
CONFIG: 2008-08-09 14:02:05List of packages with table structure: ‘SAP0000’.
CONFIG: 2008-08-09 14:02:05List of packages with views: ‘SAPVIEW’.
TRACE: 2008-08-09 14:02:05 com.sap.inst.migmon.imp.ImportStandardTask
preCreateParse of ‘C:\Program
Files\sapinst_instdir\ERP\SYSTEM\ORA\CENTRAL\AS\DDL ORA.TPL’ template file
is started.
INFO: 2008-08-09 14:02:05 com.sap.inst.migmon.imp.ImportStandardTask
preCreateParse of ‘C:\Program
Files\sapinst_instdir\ERP\SYSTEM\ORA\CENTRAL\AS\DDL ORA.TPL’ template file
is successfully completed.Primary key creation: after load.Index creation:
after load.
INFO: 2008-08-09 14:02:05Data codepage 4103 is determined using TOC file
‘F:\IDES\SAP IDES EXPORT DVD1\EXP1\DATA\SAPAPPL0.TOC’ for package
‘SAPAPPL0’.
TRACE: 2008-08-09 14:02:05 com.sap.inst.migmon.LoadTask runLoading of
‘SAPAPPL2’ import package is started.
TRACE: 2008-08-09 14:02:05 com.sap.inst.migmon.LoadTask
processPackageLoading of ‘SAPAPPL2’ import package into
database:F:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL2.cmd
-dbcodepage 4103 -l SAPAPPL2.log -stop_on_error
ERROR: 2008-08-09 14:02:10 com.sap.inst.migmon.LoadTask runLoading of
‘SAPAPPL2’ import package is interrupted with R3load error.Process
‘F:\usr\sap\NIR\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL2.cmd -dbcodepage
4103 -l SAPAPPL2.log -stop_on_error’ exited with return code 2.For mode
details see ‘SAPAPPL2.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: 2008-08-09 14:02:35Cannot start import of packages with views
because not all import packages with tables are loaded successfully.
WARNING: 2008-08-09 14:02:351 error(s) during processing of packages.
INFO: 2008-08-09 14:02:35Import Monitor is stopped.
__.____._

Copyright © 2008 ITtoolbox and message author.
No redistribution.

Related Content

White Papers


In the Spotlight

Effectively integrate reporting into your OEM applications. Learn how

_.____.__


Leave a Comment so far
Leave a comment



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s



%d bloggers like this: