SAP J2EE Engine has stopped working suddenly

[Former Member]

Hi,

I have only SAP J2EE stack in WebAs installed on a machine couple of months ago and all the while it was working fine.But suddenly one day (precisely monday)i see that J2EE Server node is not starting up. But the central instance (which has processes MsgServer.exe,Enserver.exe) has started sucessfully but not the server node instance.

I am getting the following error in the log file

<-- Error log message starts here----

---

>

[Thr 3108] Tue Nov 15 11:53:06 2005

[Thr 3108] *** ERROR => invalid return code of process [bootstrap] (exitcode=66) [jstartxx.c 1433]

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

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

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

<-- Error log message starts here----

---

>

<- Trace error message starts here-->

#

#1.5#000E0C6021FB00000000001200000614000405862C538277#1131973734265#com.sap.sql.jdbc.NativeConnectionFactory##com.sap.sql.jdbc.NativeConnectionFactory#######Thread[Thread-1,5,main]##0#0#Error#1#/System/Database/sql/jdbc#Java#com.sap.sql_0002##SQL error occurred on connection jdbc:datadirect:sqlserver://blrkecsaptst1:1433;databasename=J2E: code=18,456, state="28000", message="[DataDirect][SQLServer JDBC Driver][SQLServer]Login failed for user 'SAPJ2EDB'.

=> (0,08001,[DataDirect][SQLServer JDBC Driver]An error occurred while attempting to log onto the database.)".#5#18456#28000#[DataDirect][SQLServer JDBC Driver][SQLServer]Login failed for user 'SAPJ2EDB'.

=> (0,08001,[DataDirect][SQLServer JDBC Driver]An error occurred while attempting to log onto the database.)#jdbc:datadirect:sqlserver://blrkecsaptst1:1433;databasename=J2E#<null>#

#1.5#000E0C6021FB00000000001300000614000405862C5392D1#1131973734265#com.sap.sql.jdbc.NativeConnectionFactory##com.sap.sql.jdbc.NativeConnectionFactory#######Thread[Thread-1,5,main]##0#0#Error##Plain###java.sql.SQLException: [DataDirect][SQLServer JDBC Driver][SQLServer]Login failed for user 'SAPJ2EDB'.

at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.ddtek.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

at com.ddtek.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

at com.ddtek.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)

at com.ddtek.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at com.ddtek.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)

at com.ddtek.jdbc.base.BaseConnection.connect(Unknown Source)

at com.ddtek.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)

at com.ddtek.jdbc.base.BaseConnection.open(Unknown Source)

at com.ddtek.jdbc.base.BaseDriver.connect(Unknown Source)

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

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

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

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

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

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:147)

at com.sap.engine.core.configuration.impl.ConfigurationHandlerFactoryImpl.<init>(ConfigurationHandlerFactoryImpl.java:30)

at com.sap.engine.core.configuration.impl0.ConfigurationManagerImpl.initInternal(ConfigurationManagerImpl.java:180)

at com.sap.engine.core.configuration.AbstractConfigurationManagerImpl.init(AbstractConfigurationManagerImpl.java:170)

at com.sap.engine.core.Framework.loadSingleManager(Framework.java:396)

at com.sap.engine.core.Framework.loadManagers(Framework.java:163)

at com.sap.engine.core.Framework.start(Framework.java:97)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

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.boot.FrameThread.run(FrameThread.java:58)

at java.lang.Thread.run(Thread.java:534)

#

#1.5#000E0C6021FB00000000001500000614000405862C53DC14#1131973734281#com.sap.engine.core.configuration##com.sap.engine.core.configuration#######Thread[Thread-1,5,main]##0#0#Error#1#/System/Server#Plain###Error while connecting to DB.

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

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

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

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

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:147)

at com.sap.engine.core.configuration.impl.ConfigurationHandlerFactoryImpl.<init>(ConfigurationHandlerFactoryImpl.java:30)

at com.sap.engine.core.configuration.impl0.ConfigurationManagerImpl.initInternal(ConfigurationManagerImpl.java:180)

at com.sap.engine.core.configuration.AbstractConfigurationManagerImpl.init(AbstractConfigurationManagerImpl.java:170)

at com.sap.engine.core.Framework.loadSingleManager(Framework.java:396)

at com.sap.engine.core.Framework.loadManagers(Framework.java:163)

at com.sap.engine.core.Framework.start(Framework.java:97)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

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.boot.FrameThread.run(FrameThread.java:58)

at java.lang.Thread.run(Thread.java:534)

Caused by: java.sql.SQLException: [DataDirect][SQLServer JDBC Driver][SQLServer]Login failed for user 'SAPJ2EDB'.

at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.ddtek.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

at com.ddtek.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

at com.ddtek.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)

at com.ddtek.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at com.ddtek.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)

at com.ddtek.jdbc.base.BaseConnection.connect(Unknown Source)

at com.ddtek.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)

at com.ddtek.jdbc.base.BaseConnection.open(Unknown Source)

at com.ddtek.jdbc.base.BaseDriver.connect(Unknown Source)

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

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

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

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

... 15 more

#

#1.5#000E0C6021FB00020000000000000614000405862C5494F7#1131973734328#com.sap.engine.core.cluster.impl6.JoinPortListener##com.sap.engine.core.cluster.impl6.JoinPortListener.run()#######SAPEngine_Application_Thread[impl:3]_32##0#0#Error##Plain###java.lang.NullPointerException#

#1.5#000E0C6021FB00020000000100000614000405862C5497CD#1131973734328#com.sap.engine.core.cluster.impl6.JoinPortListener##com.sap.engine.core.cluster.impl6.JoinPortListener.run()#######SAPEngine_Application_Thread[impl:3]_32##0#0#Error##Plain###java.lang.NullPointerException

at com.sap.engine.core.cluster.impl6.ClusterManagerImpl.getClusterMonitor(ClusterManagerImpl.java:2254)

at com.sap.engine.core.cluster.impl6.JoinPortListener.waitForThisElementConstruction(JoinPortListener.java:120)

at com.sap.engine.core.cluster.impl6.JoinPortListener.access$000(JoinPortListener.java:30)

at com.sap.engine.core.cluster.impl6.JoinPortListener$SocketProcessor.run(JoinPortListener.java:137)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:94)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:162)

#

<--

---

Trace error message ends here--->

I have't not changed any passwords of db users like SAPJ2EDB but i don't know why i am getting this error suddenly.

Can anyone throw light on this issue.

Thanks and Regards,

Satish

[Former Member]

Hello Satish,

It looks like the configuration of the J2EE Instance is missing. Have you changed the database of the instance?

Kind Regards

Vyara

[detlev_beutner]

Hi Satish,

you're sure your DB is up and running?!

Best regards

Detlev

[Former Member]

Hi Detlev,

The DB (SQL 2000) is started and i have verified through

Window service console and SQL Server Service Manager.

Even the Config tool (i.e offline tool) is throwing the following error message when started.

""PATHHASH" = ?#

#1.5#C000AC19E95B000100000008008420AE0004059711CA16E0#1132046303500#/System/Server##com.sap.engine.core.configuration#######Thread[AWT-EventQueue-0,6,main]##0#0#Error#1#com.sap.engine.core.configuration#Plain###[DataDirect][SQLServer JDBC Driver][SQLServer]Invalid object name 'J2EE_CONFIG'.

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

java.sql.SQLException: [DataDirect][SQLServer JDBC Driver][SQLServer]Invalid object name 'J2EE_CONFIG'.

at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.ddtek.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

at com.ddtek.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

at com.ddtek.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)

at com.ddtek.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at com.ddtek.jdbc.sqlserver.tds.TDSRPCNonCursorExecuteRequest.submitPrepare(Unknown Source)

at com.ddtek.jdbc.sqlserver.tds.TDSRPCExecuteRequest.doPrepExec(Unknown Source)

at com.ddtek.jdbc.sqlserver.tds.TDSRPCExecuteRequest.execute(Unknown Source)

at com.ddtek.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Source)

at com.ddtek.jdbc.base.BaseStatement.commonExecute(Unknown Source)

at com.ddtek.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)

at com.ddtek.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)

at com.sap.sql.jdbc.basic.BasicPreparedStatement.executeQuery(BasicPreparedStatement.java:97)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:270)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:241)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBAccessDefault.getConfiguration(DBAccessDefault.java:578)

at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.readConfig(PersistenceHandler.java:102)

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

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.getCachedConfiguration(ConfigurationCache.java:879)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.getCachedConfiguration(ConfigurationCache.java:913)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.openConfiguration(ConfigurationCache.java:783)

at com.sap.engine.core.configuration.impl.ConfigurationHandlerImpl.openConfiguration(ConfigurationHandlerImpl.java:694)

at com.sap.engine.configtool.batch.Scanner.scan(Scanner.java:44)

at com.sap.engine.configtool.visual.ConfigTool.loadClusterData(ConfigTool.java:100)

at com.sap.engine.configtool.visual.ConfigTool.initScan(ConfigTool.java:86)

at com.sap.engine.configtool.visual.ConfigTool.scanAction(ConfigTool.java:237)

at com.sap.engine.configtool.visual.ConfigTool.actionPerformed(ConfigTool.java:209)

at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)

at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)

at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)

at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)

at javax.swing.AbstractButton.doClick(AbstractButton.java:289)

at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)

at javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:943)

at java.awt.Component.processMouseEvent(Component.java:5100)

at java.awt.Component.processEvent(Component.java:4897)

at java.awt.Container.processEvent(Container.java:1569)

at java.awt.Component.dispatchEventImpl(Component.java:3615)

at java.awt.Container.dispatchEventImpl(Container.java:1627)

at java.awt.Component.dispatchEvent(Component.java:3477)

at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)

at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)

at java.awt.Container.dispatchEventImpl(Container.java:1613)

at java.awt.Window.dispatchEventImpl(Window.java:1606)

at java.awt.Component.dispatchEvent(Component.java:3477)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)

at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)

#

#1.5#C000AC19E95B000100000009008420AE0004059711CA16E0#1132046303500#/System/Logging##com.sap.tc.logging.FileLog.[setFormatter()]#######Thread[AWT-EventQueue-0,6,main]##0#0#Warning##Java#SAP_LOGGING_FORMATTER_ERROR##Trying to change a formatter on active log ! The reset() method must be first called!#1#.
system.log# #1.5#C000AC19E95B00010000000A008420AE0004059711CA5178#1132046303515#/System/Server##com.sap.engine.core.configuration#######Thread[AWT-EventQueue-0,6,main]##0#0#Info#1#com.sap.engine.core.configuration#Plain###Properties for connect through secure store not set. Please check your connect properties. Trying to connect via plain user/password.# #1.5#C000AC19E95B00010000000B008420AE0004059711CA5178#1132046303515#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory#######Thread[AWT-EventQueue-0,6,main]##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0015#com.sap.sql.log.OpenSQLResourceBundle#Value "" is not allowed for parameter .#2#url##

"

1)is it due to mismatch of the passwords of the user SAPJ2EDB in database and J2EE Engine and Securestore of config tool

2)is there some DB related problem ?

3)i think the problem is similar to this one

But the solution there is not so clear

4)After i changed the password both in the database as well as in configtool >Secure Tool>/jdbc/pool/J2E/password..but i am getting java.sql.SQLException: [DataDirect][SQLServer JDBC Driver][SQLServer]Invalid object name 'J2EE_CONFIG' this error.

Any idea on what needs to be done to fix this problem

Regards,

Satish