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

[Former Member]

Hi Experts,

While installing ERP6.0 EHP5 in DB2 getting error as mentioned below log. Please help

CONFIG: 2011-09-17 16:55:31

Application options:

dbCodepage=4103

dbType=DB6

extFiles=no

importDirs=C:\SAPCD\sanexport\ABAP

installDir=C:\Program Files\sapinst_instdir\ERPEhP5\LM\COPY\DB6\SYSTEM\CENTRAL\AS-ABAP

jobNum=3

loadArgs=-stop_on_error -loadprocedure fast LOAD

migrationKey=1g1gDEM50Dd01eqtdAM11A96

monitorTimeout=30

orderBy=

r3loadExe=D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe

sapinst=

trace=all

tskFiles=yes

CONFIG: 2011-09-17 16:55:31

List of packages with table structure: 'SAP0000'.

CONFIG: 2011-09-17 16:55:31

List of packages with views: 'SAPVIEW'.

TRACE: 2011-09-17 16:55:31 com.sap.inst.migmon.imp.ImportStandardTask preCreate

Parse of 'C:\Program Files\sapinst_instdir\ERPEhP5\LM\COPY\DB6\SYSTEM\CENTRAL\AS-ABAP\DDLDB6.TPL' template file is started.

INFO: 2011-09-17 16:55:31 com.sap.inst.migmon.imp.ImportStandardTask preCreate

Parse of 'C:\Program Files\sapinst_instdir\ERPEhP5\LM\COPY\DB6\SYSTEM\CENTRAL\AS-ABAP\DDLDB6.TPL' template file is successfully completed.

Primary key creation: before load.

Index creation: before load.

INFO: 2011-09-17 16:55:32

Data codepage 4102 is determined using TOC file 'C:\SAPCD\sanexport\ABAP\DATA\SAPAPPL0.TOC' for package 'SAPAPPL0'.

INFO: 2011-09-17 16:55:33

Version table 'SVERS' is found in STR file 'C:\SAPCD\sanexport\ABAP\DATA\SAPSDIC.STR' from package 'SAPSDIC'.

INFO: 2011-09-17 16:55:33

Data conversion tables 'DDNTF,DDNTF_CONV_UC,DDNTT,DDNTT_CONV_UC' are found in STR file 'C:\SAPCD\sanexport\ABAP\DATA\SAPSDIC.STR' from package 'SAPSDIC'.

TRACE: 2011-09-17 16:55:33 com.sap.inst.migmon.LoadTask run

Loading of 'SAPSSEXC' import package is started.

TRACE: 2011-09-17 16:55:33 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SAPSSEXC' import package into database:

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -k 1g1gDEM50Dd01eqtdAM11A96 -l SAPSSEXC.log -stop_on_error -loadprocedure fast LOAD

ERROR: 2011-09-17 18:27:26 com.sap.inst.migmon.LoadTask run

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

Process 'D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -k 1g1gDEM50Dd01eqtdAM11A96 -l SAPSSEXC.log -stop_on_error -loadprocedure fast LOAD' exited with return code 2.

For mode details see 'SAPSSEXC.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-09-17 18:27:32

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

WARNING: 2011-09-17 18:27:32

1 error(s) during processing of packages.

INFO: 2011-09-17 18:27:32

Import Monitor is stopped.

[Former Member]

Hi,

You can try a simple solution...

1. Just stop SAP Installation.

2. De-activate DB2 database

3. Stop DB2

4. Start DB2

5. Activate Database

6. Restart SAP installation with "Continue Old Installation" option.

Regards.

Rajesh Narkhede

[Former Member]

"SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032 "

you should start by looking what happened to you DB.

db2diag.log

[Former Member]

Hi Sudipta,

Did you check SAPSSEXC.log yet ? May be we can find something specific there.

And at the same time, I hope you are using latest kernel (modified kernel dvd - latest R3load etc.).

Note 1480785 - Creating a Modified Windows Kernel DVD

Thanks

[Former Member]

Hi, Thanks for your reply. I checked the SAPSSEXC.log. But could not get any conclusion. I am attaching here the same. Please check once

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110915100435

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled May 7 2010 03:20:30

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -k 1g1gDEM50Dd01eqtdAM11A96 -l SAPSSEXC.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(GSI) INFO: dbname = "HCD "

(GSI) INFO: vname = "DB6 "

(GSI) INFO: hostname = "UNKNOWN "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "HCCDEV"

(GSI) INFO: release = "6.1"

(GSI) INFO: version = "7600 "

(GSI) INFO: machine = "4x AMD64 Level 6 (Mod 44 Step 2)"

(DB) INFO: DYNPSOURCE deleted/truncated #20110915100451

(DB6) Using LOAD API for table DYNPSOURCE

(DB6) [IBM][CLI Driver] SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032

(DB6) ERROR: Setting SQL_USE_LOAD_OFF failed with dbcode -1224 .

(IMP) ERROR: EndFastload: rc = 2

(DB) INFO: disconnected from DB

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

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110915112907

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110917102140

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled May 7 2010 03:20:30

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -k 1g1gDEM50Dd01eqtdAM11A96 -l SAPSSEXC.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(GSI) INFO: dbname = "HCD "

(GSI) INFO: vname = "DB6 "

(GSI) INFO: hostname = "UNKNOWN "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "HCCDEV"

(GSI) INFO: release = "6.1"

(GSI) INFO: version = "7600 "

(GSI) INFO: machine = "4x AMD64 Level 6 (Mod 44 Step 2)"

(DB) INFO: DYNPSOURCE deleted/truncated #20110917102202

(DB6) Using LOAD API for table DYNPSOURCE

(DB6) [IBM][CLI Driver] SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032

(DB6) ERROR: Setting SQL_USE_LOAD_OFF failed with dbcode -1224 .

(IMP) ERROR: EndFastload: rc = 2

(DB) INFO: disconnected from DB

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

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110917114811

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110917120711

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled May 7 2010 03:20:30

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -k 1g1gDEM50Dd01eqtdAM11A96 -l SAPSSEXC.log -stop_on_error -loadprocedure fast LOAD

DbSl Trace: DbSlConnect to 'HCD' as 'saphcd' failed

(DB) ERROR: db_connect rc = 256

DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver][DB2/NT64] SQL1279W Some indexes may not have been recreated

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

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110917123449

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110917130720

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled May 7 2010 03:20:30

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -k 1g1gDEM50Dd01eqtdAM11A96 -l SAPSSEXC.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(GSI) INFO: dbname = "HCD "

(GSI) INFO: vname = "DB6 "

(GSI) INFO: hostname = "UNKNOWN "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "HCCDEV"

(GSI) INFO: release = "6.1"

(GSI) INFO: version = "7600 "

(GSI) INFO: machine = "4x AMD64 Level 6 (Mod 44 Step 2)"

(DB) INFO: DYNPSOURCE deleted/truncated #20110917130736

(DB6) Using LOAD API for table DYNPSOURCE

(DB6) [IBM][CLI Driver] SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032

(DB6) ERROR: Setting SQL_USE_LOAD_OFF failed with dbcode -1224 .

(IMP) ERROR: EndFastload: rc = 2

(DB) INFO: disconnected from DB

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

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110917142958

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110917144005

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled May 7 2010 03:20:30

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -k 1g1gDEM50Dd01eqtdAM11A96 -l SAPSSEXC.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(GSI) INFO: dbname = "HCD "

(GSI) INFO: vname = "DB6 "

(GSI) INFO: hostname = "UNKNOWN "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "HCCDEV"

(GSI) INFO: release = "6.1"

(GSI) INFO: version = "7600 "

(GSI) INFO: machine = "4x AMD64 Level 6 (Mod 44 Step 2)"

(DB) INFO: DYNPSOURCE deleted/truncated #20110917144919

(DB6) Using LOAD API for table DYNPSOURCE

(DB6) [IBM][CLI Driver] SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032

(DB6) ERROR: Setting SQL_USE_LOAD_OFF failed with dbcode -1224 .

(IMP) ERROR: EndFastload: rc = 2

(DB) INFO: disconnected from DB

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

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110917160844

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110917150914

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled May 7 2010 03:20:30

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -k 1g1gDEM50Dd01eqtdAM11A96 -l SAPSSEXC.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(GSI) INFO: dbname = "HCD "

(GSI) INFO: vname = "DB6 "

(GSI) INFO: hostname = "UNKNOWN "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "HCCDEV"

(GSI) INFO: release = "6.1"

(GSI) INFO: version = "7601 Service Pack 1"

(GSI) INFO: machine = "4x AMD64 Level 6 (Mod 44 Step 2)"

(DB) INFO: DYNPSOURCE deleted/truncated #20110917151828

(DB6) Using LOAD API for table DYNPSOURCE

(DB6) [IBM][CLI Driver] SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032

(DB6) ERROR: Setting SQL_USE_LOAD_OFF failed with dbcode -1224 .

(IMP) ERROR: EndFastload: rc = 2

(DB) INFO: disconnected from DB

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

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110917163838

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110917165533

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled May 7 2010 03:20:30

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -k 1g1gDEM50Dd01eqtdAM11A96 -l SAPSSEXC.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(GSI) INFO: dbname = "HCD "

(GSI) INFO: vname = "DB6 "

(GSI) INFO: hostname = "UNKNOWN "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "HCCDEV"

(GSI) INFO: release = "6.1"

(GSI) INFO: version = "7601 Service Pack 1"

(GSI) INFO: machine = "4x AMD64 Level 6 (Mod 44 Step 2)"

(DB) INFO: DYNPSOURCE deleted/truncated #20110917170441

(DB6) Using LOAD API for table DYNPSOURCE

(DB6) [IBM][CLI Driver] SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032

(DB6) ERROR: Setting SQL_USE_LOAD_OFF failed with dbcode -1224 .

(IMP) ERROR: EndFastload: rc = 2

(DB) INFO: disconnected from DB

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

D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110917182726

[Frank-Martin]

Hi,

looks like DB2 crashes after starting LOAD. Please take a look at db2diag.log. If you do not find the reason for the crashes yourself please open a customer message.

Regards

Frank

[Former Member]

Hi Sudipta,

As Frank indicated, please go through the db2diag.log and try to extract the exact cause of db2 termination. And try to confirm some of the db2 parameters if indicated in db2diag.log

Similar discussion thread might help you -

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.udb.msg.doc%2Fdoc%...

Sometimes db2 memory related problems can be the cause as well. Try to check and confirm application heap memory/db2 heap memory parameters as well. (db2 get dbm cfg/db2 get db cfg commands via db2sid user)

Also we could see the R3load version -

SAP D:\usr\sap\HCD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE] Compiled May 7 2010

You could have used the latest R3load/kernel by using the already mentioned note.

Thanks