J2EE service missing

[Former Member]

Hi,

I have installed a dual stack for PI on a windows 2003 /MS SQL.

The installation went well and we started accessing the system.

But we are now not able to connect to any of JAVA services.. like sld.

And when we are trying to connect to http://host:50000 also nothing is connecting.

When we checked in SAP MMC everything is green.. but there is no java component at all....

Normally when you install a dual stack and if j2ee has got some problems then the SAP MMC should be yellow.. but here it is green..

In SAP MMC below the ABAP WP Table we should be able to see j2ee process table which I am not able to see...

I tried to start J2EE Engine from SMICM..but it hasnot came up...

Please suggest.

Thanks & Regards

Mrutyunjay

[former_member433984 · Accepted solution]

is this 6.40 or 7.00?

do you have latest SAP MMC update (in 6.40 j2ee administration was not implemented in SAP MMC at the beginning, you need latest version)

you can use sapcontrol.exe with option "J2EEGetProcessList" to check if your java instance is running

[Former Member · Accepted solution]

Hi Yaroslav,

Thanks for your response.

this is 7.0...

currently I cannot verify sapcontrol as I am out of my office..

Besides not visible in MMC the j2ee service is also not running... as we are not able to connect at 50000 ..

regards

Mrutyunjay

[Former Member · Accepted solution]

I am not able to connect to DB through configtool.

It is seems it is not able to reach the database...

The error message is as follows

com.sap.engine.frame.core.configuration.ConfigurationException: Error while conn

ecting to DB.

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnection

Pool.createConnection(DBConnectionPool.java:360)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnection

Pool.<init>(DBConnectionPool.java:125)

at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceH

andler.<init>(PersistenceHandler.java:38)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.<init

>(ConfigurationCache.java:149)

at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBoots

trapImpl.init(ConfigurationManagerBootstrapImpl.java:236)

at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBoots

trapImpl.<init>(ConfigurationManagerBootstrapImpl.java:49)

at com.sap.engine.configtool.visual.ConfigTool.loadClusterData(ConfigToo

l.java:99)

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

87)

at com.sap.engine.configtool.visual.ConfigTool.<init>(ConfigTool.java:82

)

at com.sap.engine.configtool.visual.ConfigTool.main(ConfigTool.java:961)

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:25)

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

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

)

Caused by: java.sql.SQLException: [NWMss][SQLServer JDBC Driver]Error establishi

ng socket to host and port: DEVSAP01:1439. Reason: Connection refused: connect

at com.sap.nwmss.jdbc.base.BaseExceptions.createException(Unknown Source

)

at com.sap.nwmss.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Sou

rce)

at com.sap.nwmss.jdbc.base.BaseConnection.connect(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseConnection.setupImplConnection(Unknown So

urce)

at com.sap.nwmss.jdbc.base.BaseConnection.open(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseDriver.connect(Unknown Source)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(Nativ

eConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(Open

SQLDataSourceImpl.java:608)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQL

DataSourceImpl.java:285)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnection

Pool.createConnection(DBConnectionPool.java:302)

... 14 more

I have stopped the database and tried.. and the error remained the same..

it implies it is not able to reach the database...

Where would be configuration of DB for configtool please suggest?

And this could be the reason for J2EE not coming up!

regards

Mrutyunjay

[former_member433984 · Accepted solution]

check "jdbc/pool" in config tool ("secure store" tree)

even you cannot connect to DB it will read SecStore.properties file

[Former Member · Accepted solution]

Hi Yaroslav,

I checked the secstore.properties..

The following are what i see...

admin/host/DPX

admin/password/DPX

admin/port/DPX

admin/user/DPX

jdbc/pool/DPX/ClassName

jdbc/pool/DPX/Password

jdbc/pool/DPX/Url

jdbc/pool/User

The user ids and passwords given are correct.

Please suggest how can we use these values to fix the problem.

Thanks & Regards

Mrutyunjay

[former_member433984 · Accepted solution]

check this

jdbc/pool/DPX/Url

is there correct host, DB, port specified?

[Former Member · Accepted solution]

Yaroslav..... U r correct.

jdbc/pool/DPX/Url was wrongly mentioned...

It shouldbe

jdbc:nwmss:sqlserver://DEVSAP01\DEVSAPPI:1439;databasename=DPX

but was

jdbc:nwmss:sqlserver://DEVSAP01:1439;databasename=DPX which is wrong..

It took correctly in all the installatins.. but for Dual stack installation we faced this.

Thanks a Ton.