J2ee Status info unavilable in MMC

[Former Member]

HI ,

My Abap system is working fine.In MMC j2ee status info unavailable.

Earlier its working fine.services also working fine.J2ee procees table

also empty.

In work directory dev_dsipatcher is also not updating.

Unable to login Visual admin and Config tool also .

Please guide me and suggest me .

Thanks

Nekkalapu

[Former Member]

Hi,

As per your update above there is a mismatch in JDBC URL and driver class.

Please set it as per below combination.

Driver class:

com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC URL:

jdbc:sqlserver://<dbhost>:<port>;databaseName=<dbname>

or

Driver class:

com.sap.nwmss.java.sqlserver.SQLServerDriver

JDBC URL:

jdbc:nwmss:sqlserver://<dbhost>:<port>;databasename=<dbname>

Regards,

Kavitha

[Former Member]

Hi,

Thanks for your reply.sorry wrongly posted secure store parameters.

Please find the below my secure store parameters.

admin/host/QQA GGN-SAP1

admin/password/QQA **********

admin/port/QQA 50004

admin/user/QQA J2EE_ADMIN

jdbc/pool/QQA/ClassName com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc/pool/QQA/Password **********

jdbc/pool/QQA/Url jdbc:sqlserver://GGN-SAP1:1433;databasename=QQA

jdbc/pool/QQA/User SAPQQADB

Kindly suggest me how to proceed further.

Thanks

Nekkalapu

[sivakumar_kilari3]

Hi,

Check your J2EE_ADMIN password in ABAP stack.

Thanks,

Siva

[Former Member]

Hi ,

J2ee_admin password is working fine and able login through j2ee_admin password also.

Thanks

Nekkalapu

[Former Member]

HI All,

Please suggest how to proceed further.

[Former Member]

HI all,

Please suggest how to proceed further.

Thanks

Nekkalapu

[Former Member]

Hello,

Please perform the below two steps.

1. Compare JDBC URL in QQA with other systems in the landscape and correct accordingly.

2. Check OS user SAPQQADB password is working and make sure it's not locked.

Hope it helps.

Thanks,

Siva Kumar

[Former Member]

HI ,

1) Already compared JDBC URL with my Development system.

2)Please expalin how will check teh OS level user id SAPQQADB password working or not?

Advance thanks

Regards

Nekkalapu

[Former Member]

Hi,

Since your QAA is running on Windows, I don't think you can check. Please check with your Windows team to verify SAPQAADB user account status.

Thanks,

Siva Kumar

[Former Member]

Hi

Actually its a database user ,please suggest i am using sql server 2005

regards

nekkalapu

[Former Member]

Hi,

It does not matter, what DB you are using. SAP<SID>DB is the OS user that establish the connection to Java DB. If this user is locked, DB initialization fails. It could be one of the reasons for your problem.

Thanks,

Siva Kumar

[Former Member]

Hi

Thanks for your prompt replies.

I am chceking through My computer right clik option Manage Local user and groups lo SAP<sid> DB user is not dispalying .

Its dispalying only when i open the SQL management studio the only its showing.

Is their any otherway to find out this? Please not that My ABAP system is working fine

Advance thanks

Rgeards

Nekkalapu

[Former Member]

Hello,

I should have asked this question in the first place.

Why you had to restart your system (ABAP+JAVA)? Was there any configuration changes happened?

Thanks,

Siva Kumar

[Former Member]

Hi Siva,

Thanks for your reply.

3 months w eapplies OS level(microsft) patches after that rebooted the system after that only abap is running j2ee is down.

Thanks

Nekkalapu

[rajesh_kumar71]

Hi,

Kindly post the full log , and try to find the line such as "caused by the system out of memory or something .........."

regards,

S.Rajeshkumar

[Former Member]

Hi

i have posted the full log only ,there is no such type of "memory" realtaed iinformation

[rajesh_kumar71]

Hi ,

Can you check the link and this solution may help you :

regards,

S.Rajeshkumar

[rajesh_kumar71]

Hi ,

Can you check the link and this solution may help you :

regards,

S.Rajeshkumar

[rajesh_kumar71]

Hi ,

Can you check the link and this solution may help you :

regards,

S.Rajeshkumar

[cathal_ohare]

HI,

Since the configtool will not run this tells us that there is a connection problem to your database, this is the first place to start troubleshooting as the j2ee engine will most likley get the same error when it starts up. Useful logs to check:

system.log (in the configtool directory)

jvm_bootstrap.out (in the work directory)

Kind regards,

Cathal

[rajesh_kumar71]

Hi ,

Can you please check this

regards,

S.Rajeshkumar

[rajesh_kumar71]

Hi ,

Can you please check this

regards,

S.Rajeshkumar

[Former Member]

Hello,

In first place, please verify if Java Stack is Up or down at the moment.

Thanks

[Former Member]

Hi ,

Java system down ,dev_dipatcher is not updating in work directory.

Only Dev_Jccontrol & Dev_bootstrap & jvm_bootstrp.out log files

updating.

when i am trying connect config tool I am getting error "Error

occured while working with configuration(scanning) MSG:Error while connecting to DB"

My database connection working fine .

dev_jccontrol :

,[Thr 3028] Tue Sep 20 19:40:18 2011

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

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

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

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

[cathal_ohare]

Dear Customer,

Please look in the jvm_bootstrap.out for the error the j2ee engine gets when connecting to the database and post it to the thread.

Kind regards,

Cathal

[Former Member]

HI ,

Thanks for your prompt response ,please fnd the required information below:

jvm_bootstrap.out File:

-

---

Bootstrap MODE:

<INSTANCE GLOBALS>

determined by parameter [ID0042249].

-

---

Exception occurred:

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

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

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

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

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

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 com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:364)

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

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

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

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

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

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

Caused by: com.sap.sql.log.OpenSQLException: Could not load class com.sap.nwmss.jdbc.sqlserver.SQLServerDriver.

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

... 14 more

Caused by: java.lang.ClassNotFoundException: com.sap.nwmss.jdbc.sqlserver.SQLServerDriver

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

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

at java.lang.Class.forName0(Native Method)

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

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

... 17 more

[Bootstrap module]> Problem occurred while performing synchronization.

[cathal_ohare]

Hi,

Ok looks like problems with the database drivers, these notes shouls help:

939811 MSS: JDBC DataSources in the SAP Java Application

639702 JDBC Driver for Microsoft SQL Server

Make sure the drivers exists and the databse connection parameters in the secure store in the configtool are ok. (after you get the error in the configtool click ok and you should be able to access the configtool).

Kind regards,

Cathal

[Former Member]

Hi Cathal,

Thanks for your prompt response.

I have checked the 939811 & 639702 notes same entries are exsting in my configtoll secure store .

Please find the confgitoll entries below:

admin/host/QQA GGN-SAP1

admin/password/QQA **********

admin/port/QQA 50004

admin/user/QQA J2EE_ADMIN

jdbc/pool/QQA/ClassName com.sap.nwmss.jdbc.sqlserver.SQLServerDriver

jdbc/pool/QQA/Password **********

jdbc/pool/QQA/Url jdbc:nwmss:sqlserver://GGN-SAP1:1433;databasename=QQA

jdbc/pool/QQA/User SAPQQADB

Please suggest how to proceed further

Advance thanks

Nekkalapu

[cathal_ohare]

Hi,

The error cauing the issue is:

Caused by: java.lang.ClassNotFoundException: com.sap.nwmss.jdbc.sqlserver.SQLServerDriver

So the secure store may be set correctly but does the mentioned file exist, I suggest downloading the jdbc driver again, the notes mentioned should help.

Kind regards,

Cathal

[Former Member]

Hi Cathal,

Please suggest how to proceed further.

Thanks

Nekkalapu

[Former Member]

Hi,

Are you able to connect or open the config tool?

If java.lang.ClassNotFoundException is present as a cause for the bootstrap error, most likely the driver class specified in Secure Store is incorrect, or the driver jar file cannot be found. In this case check whether the path to the driver jar files is configured correctly in Secure Store.

Eg. jdbc/pool/<SID>/ClassName : oracle.jdbc.driver.OracleDriver

But if you are getting "java.sql.SQLException: No suitable driver" exception is present, it may indicate an incorrect URL: The driver class configured in the secure store could be loaded with the driver path specified but it could not be assigned to the JDBC URL. Check the entries in the secure store (/usr/sap/<SID>/SYS/global/security/data/SecStore.properties).

E.g. jdbc/pool/<SID>/Url : jdbc:oracle:thin:@<hostname>:<port>:<SID>

Please check if you are able to open the configtool?

Wating for reply

Dbalhara

[Former Member]

Hi ,

Thanks for you reply

I am able to open the conforg tool First message "Do you want to use the default DB settings" after clicking yes button,"Error occured while working with configuration(Scanning) MSG:error while connecting to DB" eroor message pop up after click ok button i able to see the secure store parameters.

Bleow are the secure store parameters:

admin/host/QQA GGN-SAP1

admin/password/QQA **********

admin/port/QQA 50004

admin/user/QQA J2EE_ADMIN

jdbc/pool/QQA/ClassName com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc/pool/QQA/Password **********

jdbc/pool/QQA/Url jdbc:nwmss:sqlserver://GGN-SAP1:1433;databasename=QQA

jdbc/pool/QQA/User SAPQQADB

Kindly suggest me how to proceed further.

Thanks

Nekkalapu

[Former Member]

HI

Please suggest how to proceed further.

[Former Member]

Hi,

If it a windows system, this may also be caused due to lack of shared memory.My suggestion isgo for a reboot of the server.

Note : please take a proper shut down of SAP.

Regards,

Sriram Pingali