SAP BI not start in iSeries 525

[Former Member]

Hi all experts and gurus

We have a problem with the SAP BI instance in iSeries 525.

iSeries had a problems (disk controller card) and reinstall the operating system, then the folders /usr/sap... had another owner and we have to change to user: R3OWNER. The ABAP instance correct, but JAVA instance not start, the last weekend the system work fine but today not start.

Log messages found in the path \usr\sap\sbd\DVEBMGS00\work

__________________________________________________________________

dev_ms

[Thr 1] Tue Aug 17 12:02:38 2010

[Thr 1] *** ERROR => MsSClientHandle: no server provides service ENQ (4), requested from C1031D95_SBD_00 [msxxserv_mt.4711]

[Thr 1] Tue Aug 17 12:03:46 2010

[Thr 1] *** ERROR => MsSClientHandle: no server provides service ENQ (4), requested from C1031D95_SBD_00 [msxxserv_mt.4711]

[Thr 1] Tue Aug 17 12:13:48 2010

[Thr 1] *** ERROR => MsSCheckConnections: no response from client C1 (127.0.0.1) after 300 secs received [msxxserv_mt.3205]

[Thr 1] *** ERROR => MsSCheckConnections: disconnect now [127.0.0.1] [msxxserv_mt. 3209]

dev_w0

M Tue Aug 17 12:02:35 2010

M kernel runs with dp version 241000(ext=110000) (@(#)

M length of sys_adm_ext is 576 bytes

M ***LOG Q01=> ThInit, WPStart (Workproc 0 1 686) [thxxhead.c 1290]

M ThInit: running on host C1031D95

M calling db_connect ...

C DB4 SQL Reparse Activated

C R3INLPGM: RmtExeLib from /usr/sap/SBD/SYS/exe/run/DBSLDB4RMT

C R3INLPGM: RmtExeLib is SAPSBDUC

C *** ERROR => CPFB755 occured. Refer to job log.

[dbsldb4dbi.c 1033]

C DBSLENCWT: rc=9998, msg=

C *** ERROR => CPF0006 occured. Refer to job log.

[dbsldb4dbi.c 1107]

C *** ERROR => Command: CALL PGM(SAPSBDUC/CHGR3SYSLE) PARM('*ADD') :Failed

[dbsldb4.cpp 15406]

C Dumping cursor lists on disconnect:

C Dump of all cursor list sizes:

C con[0]: cl=0 wh=0 dfc=0 reo=0 free=19 total=19

___________________________________________________________________________________________

We need your support please for resolve this issue.

Thanks in advance

Enrique Espindola

[Former Member]

Hi Enrique,

sounds as if the jdbc drivers exist... now it's difficult for me to say anything more from the information I have.

Have you opened a ticket with SAP?

Best regards

Christoph

[Former Member]

Hi Enrique,

I recommend to check SAP note 1096017. This note provides very good information how to solve problems with saposcol processes that don't start correctly.

Best regards

Christoph

[Former Member]

Christoph

I check the system and did not find the folder in the IFS, you know how to create and start the instance of JAVA?, I need your help. Only currently active instance of ABAP.

db2_classes.jar file exist in the system

Only exist in /sapmnt/SBD/jdbc inthis path exist two subfolder ntv with file db2_classes.jar and subfoder tbx with file jt400.jar.

Best regards.

Edited by: Enrique Espíndola Barajas on Aug 24, 2010 3:40 AM

[Former Member]

Hi Enrique,

this looks like problems with the DB connection. Seems you're using the native JDBC driver. Then check if your JDBC driver link exists:

/usr/sap/SBD/SYS/jdbc/ntv/db2_classes.jar

This link should point to /QIBM/ProdData/OS400/Java400/ext/db2_classes.jar which obviously must exist as well.

Best regards

Christoph

[Former Member]

Christoph

I'll review the issue of JDBC driver.

The system is working correctly after executing the command FIXR3OWNS.

However, when SAP started, I had to finish the process SAPOSCOL because other jobs will not start in the subsystem R3_00.

Subsystem R3_01 processes are well.

After initiating the process in ST06 SAPOSCOL. But this is not normal, what else I can check?

Thank you very much for your support.

[Former Member]

Hi Enrique,

as for the issue with CHGR3SYSLE that was seen in the log, I recommend to run FIXR3OWNS on your kernel library (SAPSBDUC) as a QSECOFR like user.

And regarding Java I can't see anything from your logs. Is there a JCONTROL process? e.g. dev_jcontrol file?

Best regards

Christoph

[Former Member]

Thanks Christhop, I run FIXR3OWNS LIB(SAPSBDUP>) OBJ(ALL)* and process finally OK.

This is information about the dev_jcontrol

-

---

trc file: "/usr/sap/SBD/DVEBMGS00/work/dev_jcontrol", trc level: 1, release: "701"

-

---

node name : jcontrol

pid : 688

system name : SBD

system nr. : 00

started at : Wed Aug 18 12:24:20 2010

arguments :

arg[00] : jcontrol

arg[01] : pf=/usr/sap/SBD/SYS/profile/SBD_DVEBMGS00_C1031D95

arg[02] : -DSAPSTART=1

arg[03] : -DCONNECT_PORT=65000

arg[04] : -DSAPSYSTEM=00

arg[05] : -DSAPSYSTEMNAME=SBD

arg[06] : -DSAPMYNAME=C1031D95_SBD_00

arg[07] : -DSAPPROFILE=/usr/sap/SBD/SYS/profile/SBD_DVEBMGS00_C1031D95

arg[08] : -DFRFC_FALLBACK=ON

arg[09] : -DFRFC_FALLBACK_HOST=localhost

[Thr 1] Wed Aug 18 12:24:20 2010

[Thr 1] *** WARNING => INFO: Unknown property [instance.box.number=SBDDVEBMGS00c1031d95] [jstartxx_mt. 841]

[Thr 1] *** WARNING => INFO: Unknown property [instance.en.host=C1031D95] [jstartxx_mt. 841]

[Thr 1] *** WARNING => INFO: Unknown property [instance.en.port=3201] [jstartxx_mt. 841]

[Thr 1] *** WARNING => INFO: Unknown property [instance.system.id=0] [jstartxx_mt. 841]

**********************************************************************

JStartupReadInstanceProperties: read instance properties [/usr/sap/SBD/DVEBMGS00/j2ee/cluster/instance.properties:/usr/sap/SBD/DVEBMGS00/SDM/program/config/sdm_jstartup.properties]

-> ms host : C1031D95

-> ms port : 3901

-> OS libs : /usr/sap/SBD/DVEBMGS00/j2ee/os_libs

-> Admin URL :

-> run mode : normal

-> run action : NONE

-> enabled : yes

**********************************************************************

**********************************************************************

Used property files

-> files [00] : /usr/sap/SBD/DVEBMGS00/j2ee/cluster/instance.properties

-> files [01] : /usr/sap/SBD/DVEBMGS00/SDM/program/config/sdm_jstartup.properties

**********************************************************************

**********************************************************************

Instance properties

-> ms host : C1031D95

-> ms port : 3901

-> os libs : /usr/sap/SBD/DVEBMGS00/j2ee/os_libs

-> admin URL :

-> run mode : normal

-> run action : NONE

-> enabled : yes

**********************************************************************

**********************************************************************

Bootstrap nodes

-> [00] bootstrap : /usr/sap/SBD/DVEBMGS00/j2ee/cluster/instance.properties

-> [01] bootstrap_ID3790000 : /usr/sap/SBD/DVEBMGS00/j2ee/cluster/instance.properties

-> [02] bootstrap_ID3790050 : /usr/sap/SBD/DVEBMGS00/j2ee/cluster/instance.properties

**********************************************************************

**********************************************************************

Worker nodes

-> [00] ID3790000 : /usr/sap/SBD/DVEBMGS00/j2ee/cluster/instance.properties

-> [01] ID3790050 : /usr/sap/SBD/DVEBMGS00/j2ee/cluster/instance.properties

-> [02] sdm : /usr/sap/SBD/DVEBMGS00/SDM/program/config/sdm_jstartup.properties

**********************************************************************

[Thr 1] JStartupIOS4JDKInit: OS is 6.1.

[Thr 1] JStartupIOS4JDKInit: OS4DefaultProperties file /usr/sap/SBD/SYS/j2ee/OS4Default.properties rewritten.

[Thr 1] JStartupIOS4JDKInit: Class cache already exists.

[Thr 1] SigISetDefaultAction : default handling for signal 20

[Thr 258] JControlDPMessageProxy: Thread 258 started as handler thread for R/3 dispatcher messages.

[Thr 1] JControlExecuteBootstrap: execute bootstrap process [bootstrap]

[Thr 1] [Node: bootstrap] java home is set by profile parameter

Java Home: /QIBM/ProdData/Java400/jdk14

[Thr 1] JStartupICheckFrameworkPackage: can't find framework package /usr/sap/SBD/SYS/exe/run/jvmx.jar

**********************************************************************

JStartupIReadSection: read node properties [bootstrap]

-> node name : bootstrap

-> node type : bootstrap

-> node execute : yes

-> java path : /QIBM/ProdData/Java400/jdk14

-> java parameters : -Djco.jarm=1 -verbose:gc -Djava.ext.dirs=/QIBM/ProdData/Java400/jdk14/lib/ext

-> java vm version : 1.4.2

-> java vm vendor : Classic VM (IBM Corporation)

-> java vm type : <default>

-> java vm cpu : PowerPC

-> heap size : 256M

-> root path : /usr/sap/SBD/DVEBMGS00/j2ee/cluster

-> class path : ./bootstrap/launcher.jar

-> OS libs path : /usr/sap/SBD/DVEBMGS00/j2ee/os_libs

-> main class : com.sap.engine.offline.OfflineToolStart

-> framework class : com.sap.bc.proj.jstartup.JStartupFramework

-> registr. class : com.sap.bc.proj.jstartup.JStartupNatives

-> framework path : /usr/sap/SBD/SYS/exe/run/jstartup.jar:/usr/sap/SBD/SYS/exe/run/jvmx.jar

-> parameters : com.sap.engine.bootstrap.Bootstrap ./bootstrap ID0037900

-> debuggable : yes

-> debug mode : no

-> debug port : 60000

-> shutdown timeout : 120000

**********************************************************************

[Thr 1] JStartupIGetJ2EELibrary: Default J2EE library computed as: SAPJ2EE00.

**********************************************************************

JControlStartJLaunch: program = /usr/sap/SBD/SYS/exe/run/jlaunch

-> arg[00] = /usr/sap/SBD/SYS/exe/run/jlaunch

-> arg[01] = pf=/usr/sap/SBD/SYS/profile/SBD_DVEBMGS00_C1031D95

-> arg[02] = -DSAPINFO=SBD_00_bootstrap

-> arg[03] = -nodeId=-1

-> arg[04] = -file=/usr/sap/SBD/DVEBMGS00/j2ee/cluster/instance.properties

-> arg[05] = -syncSem=103

-> arg[06] = -nodeName=bootstrap

-> arg[07] = -jvmOutFile=/usr/sap/SBD/DVEBMGS00/work/jvm_bootstrap.out

-> arg[08] = -stdOutFile=/usr/sap/SBD/DVEBMGS00/work/std_bootstrap.out

-> arg[09] = -locOutFile=/usr/sap/SBD/DVEBMGS00/work/dev_bootstrap

-> arg[10] = -mode=BOOTSTRAP

-> arg[11] = pf=/usr/sap/SBD/SYS/profile/SBD_DVEBMGS00_C1031D95

-> arg[12] = -DSAPSTART=1

-> arg[13] = -DCONNECT_PORT=64999

-> arg[14] = -DSAPSYSTEM=00

-> arg[15] = -DSAPSYSTEMNAME=SBD

-> arg[16] = -DSAPMYNAME=C1031D95_SBD_00

-> arg[17] = -DSAPPROFILE=/usr/sap/SBD/SYS/profile/SBD_DVEBMGS00_C1031D95

-> arg[18] = -DFRFC_FALLBACK=ON

-> arg[19] = -DFRFC_FALLBACK_HOST=localhost

-> lib path = LIBPATH=/QIBM/ProdData/Java400/jdk14/PASE64/lib:/QSYS.LIB/SAPJ2EE00.LIB:/usr/sap/SBD/DVEBMGS00/j2ee/os_libs:/usr/sap/SBD/SYS/exe/run:/usr/sap/SBD/SYS/exe/run

-> exe path = PATH=/QIBM/ProdData/Java400/jdk14/bin:/usr/sap/SBD/DVEBMGS00/j2ee/os_libs:/usr/sap/SBD/SYS/exe/run:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:/usr/bin:.

**********************************************************************

[Thr 1] Wed Aug 18 12:24:21 2010

[Thr 1] JStartupICreateProcess: fork process (pid 698)

[Thr 1] Wed Aug 18 12:24:32 2010

[Thr 1] *** ERROR => invalid return code of process [bootstrap] (exitcode = 66) [jstartxx_mt. 1642]

[Thr 1] JControlExecuteBootstrap: error executing bootstrap node [bootstrap] (rc = 66)

[Thr 1] JControlCloseProgram: started (exitcode = 66)

[Thr 1] JControlCloseProgram: good bye... (exitcode = 66)

___________________________________________________

The next information is about the log_bootstrap_ID0037900.0 file

[Aug 18, 2010 10:26:55...] [Bootstrap module]> Problem occurred while performing synchronization.

[Aug 18, 2010 12:24:25...] -

---

[Aug 18, 2010 12:24:25...] Bootstrap MODE:

[Aug 18, 2010 12:24:25...] <INSTANCE GLOBALS>

[Aug 18, 2010 12:24:25...] determined by parameter [ID0037900].

[Aug 18, 2010 12:24:25...] -

---

[Aug 18, 2010 12:24:30...] Exception occurred:

com.sap.engine.bootstrap.SynchronizationException: Database initialization failed! Check database properties!

at java.lang.Throwable.<init>(Throwable.java:195)

at java.lang.Exception.<init>(Exception.java:41)

at com.sap.engine.bootstrap.SynchronizationException.<init>(SynchronizationException.java:55)

at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:477)

at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:147)

at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:946)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

-

---

==[ Caused by: ]==----

---

com.sap.engine.frame.core.configuration.ConfigurationException: Error while connecting to DB.

at java.lang.Throwable.<init>(Throwable.java:180)

at java.lang.Exception.<init>(Exception.java:29)

at com.sap.exception.BaseException.<init>(BaseException.java:145)

at com.sap.engine.frame.ServiceException.<init>(ServiceException.java:54)

at com.sap.engine.frame.core.configuration.ConfigurationException.<init>(ConfigurationException.java:66)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:365)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.<init>(DBConnectionPool.java:130)

at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.<init>(PersistenceHandler.java:38)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.<init>(ConfigurationCache.java:149)

at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.init(ConfigurationManagerBootstrapImpl.java:236)

at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.<init>(ConfigurationManagerBootstrapImpl.java:49)

at com.sap.engine.bootstrap.Synchronizer.<init>(Synchronizer.java:74)

at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:474)

at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:147)

at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:946)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Caused by: com.sap.sql.log.OpenSQLException: Could not load class com.ibm.db2.jdbc.app.DB2iSeriesDriver.

at java.lang.Throwable.<init>(Throwable.java:195)

at java.lang.Exception.<init>(Exception.java:41)

at java.sql.SQLException.<init>(SQLException.java:40)

at com.sap.sql.log.OpenSQLException.<init>(OpenSQLException.java:447)

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:106)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:143)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:608)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:285)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:307)

... 13 more

Caused by: java.lang.ClassNotFoundException: com.ibm.db2.jdbc.app.DB2iSeriesDriver

at java.lang.Throwable.<init>(Throwable.java:217)

at java.lang.Exception.<init>(Exception.java:59)

at java.lang.ClassNotFoundException.<init>(ClassNotFoundException.java:65)

at com.sap.engine.offline.FileClassLoader.findClass(FileClassLoader.java:611)

at com.sap.engine.offline.FileClassLoader.loadClass(FileClassLoader.java:600)

at com.sap.engine.offline.FileClassLoader.loadClass(FileClassLoader.java:578)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:330)

at java.lang.Class.forName(Class.java:165)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:134)

... 16 more

[Aug 18, 2010 12:24:30...] [Bootstrap module]> Problem occurred while performing synchronization.

-

---

Thanks in advance for your support.

Enrique