Java stack down

[Former Member]

Hello Guru's,

We are facing strange issue with our solman system. We recently had to restart SAP and database because of some maintainance activity, from then on Java stack is not coming up. Abap is working fine but the issue is only with Java stack not able to connect to database.System details are solman 7.1 with windows 2008 R2 and Mssql 2008 R2. Until restart of database everything was working fine and we havent done any parameter or any change on the system. Even config tools fails to connect.Please find the attached logs and let me know incase any body has faced similar issue.

Thanks in advance.

Regards

Prashant

dev_bootstrap.zip

dev_jcontrol.zip

jvm_bootstrap.out.zip

[former_member198633 · Accepted solution]

Hello Prashant,

According to the "Caused by:" event in the jvm_bootstrap.out log:

"Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: The TDS protocol stream is not valid.."

This seems to be a DB driver related issue. This note should be relevant here according to the error:

1428134 - sqljdbc driver fails to establish secure connection

Another useful note would be: 1398807 - Microsoft SQL Server: JDBC driver support matrix

Best Regards,

Peter Tari

[Former Member]

Dear All,

Thanks for your reply's.

We have resolved the issue, sorry for replyinh lately.

As suggested by Peter we followed the below note and it did the trick.

1428134 - sqljdbc driver fails to establish secure connection

Thanks everyone for giving valuable suggestions.

Regards

Prashant.

[former_member185239]

Hi Prashant,

You need to check the SAPSR3DB user at database level.

If you are not able to connect the database , then the return code will be RC=66

Also do check the error.log at database level and check the below return code.

2 and 5 => Invalid userid

6 =>  Attempt to use a Windows login name with SQL Authentication

7 => Login disabled and password mismatch

8 => Password mismatch

9 => Invalid password

11 and 12 => Valid login but server access failure

13 => SQL Server service paused

18 => Change password required

With Regards

Ashutosh Chaturvedi

[Former Member]

Hello Ashutosh,

The user SAPSIDDB is having correct credentials and no user j2ee_admin is not locked in the ABAP side.

Thanks

Prashant

[former_member185954]

Hello Prashant,

As Peter pointed out, this seems to be related to your JDK, check if some OS patches that you maybe unaware about changed your JDK version.

Regards,

Siddhesh

[Sriram2009]

Hi Prashant

Could you check this SAP KBA

1950926 - System cannot start due to login SQLServerException

BR

SS

[former_member185239]

Hi Prashant,

Have you perform a kernel upgarde?

Are you have to open the Configtool?

Can you please give a  try to replace the mssjdbc folder(on the affected system) with the existing system where the system is up and running.

With Regard

Ashutosh Chaturvedi

[former_member198633]

Hello Prashant,

The logs you attached complain about connectivity issues between the AS Java and the DB: that was the exit code 66. But the actual root cause of the connection failure is in the jvm_bootstrap log. The error there talks about the Microsoft JDBC driver not being able to establish connection to the DB. The note I copied above describes the very same situation and the solution is to update the JDBC driver. Have you managed to look into this possibility?

Best Regards,

Peter

[divyanshu_srivastava3]

Hi Prashant,

This is a know issues.

Refer below KBA to get thsi fixed.

1602004 - J2EE System fails with "exitcode = 66"

Regards,

[Former Member]

Hi Divyanshu,

We are not running on Oracle db, please find below the log_bootstrap.

[May 12, 2015 9:23:11 AM ] [Bootstrap module]> Problem occurred while performing synchronization.
[May 12, 2015 9:23:45 AM ] --------------------------------------------------
[May 12, 2015 9:23:45 AM ] Bootstrap MODE:
[May 12, 2015 9:23:45 AM ] <SINGLE INSTANCE>
[May 12, 2015 9:23:45 AM ]  determined by parameter [ID003739700].
[May 12, 2015 9:23:45 AM ] --------------------------------------------------
[May 12, 2015 9:23:51 AM ] Exception occurred:
com.sap.engine.bootstrap.SynchronizationException: Database initialization failed! Check database properties!
at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:477)
at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:156)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:946)
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:370)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.<init>(DBConnectionPool.java:131)
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:156)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:946)
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.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: The TDS protocol stream is not valid..
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSChannel.throwSSLConnectionFailed(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)
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:308)
... 14 more

[May 12, 2015 9:23:51 AM ] [Bootstrap module]> Problem occurred while performing synchronization.

[manumohandas82]

Hi Prashanth ,

Please confirm whether you are able to connect to the Config tool using the default configuration loaded from the DB .

If not send the screenshot of the DB Connection parameters in Config tool

Thanks ,

Manu

[manumohandas82]

Hi Prashanth ,

What database are you on . ?   Can you connect to the config tool using the default properties ?

Check the following thread

J2EE Engine start error: Database initializatio... | SCN

997510 - Troubleshooting J2EE Engine 6.40/7.0 Bootstrap Issues

Thanks ,

Manu

[Former Member]

Hello Manu,

Thanks for the reply, we are running on MSSQL 2008 R2.

I have already referred the note but couldn't get through the issue.