PO – Exception of type java.sql.SQLRecoverableException caught: IO Error: The Network Adapter could not establish the connection
After last update Java (PO) system to SPS 25 (09/2022) in logs appeared the following error…
In Log Viewer You can find:
In DefaultTrace logs was a little more information:
2.#XXXX 10 24 21:55:39:562#+0200#Error#com.sap.sql.connect.datasource.DBDataSourceImpl#
com.sap.sql_0019#BC-JAS-PER-SQL#opensqlkernel#C0000A6A1EDA00480006A9F90000BE99#19559450000000004#sap.com/com.sap.lcr#com.sap.sql.connect.datasource.DBDataSourceImpl#PIAFXXX#2#JTA Transaction : 26733#C563056D512C11ED8F7500505691713E#c563056d512c11ed8f7500505691713e##0#Thread[SLD ContentSync Thread-0,5,Dedicated_Application_Thread]#Plain##
Exception of type com.sap.sql.log.OpenSQLException caught: Exception of type java.sql.SQLRecoverableException caught: IO Error: The Network Adapter could not establish the connection..#
#2.#XXXX 10 24 21:55:39:562#+0200#Error#com.sap.sql.connect.datasource.DBDataSourceImpl#
#BC-JAS-PER-SQL#opensqlkernel#C0000A6A1EDA00480006A9FA0000BE99#19559450000000004#sap.com/com.sap.lcr#com.sap.sql.connect.datasource.DBDataSourceImpl#PIAFXXX#2#JTA Transaction : 26733#C563056D512C11ED8F7500505691713E#c563056d512c11ed8f7500505691713e##0#Thread[SLD ContentSync Thread-0,5,Dedicated_Application_Thread]#Plain##
Exception of type com.sap.sql.log.OpenSQLException caught: Exception of type java.sql.SQLRecoverableException caught: IO Error: The Network Adapter could not establish the connection..
[EXCEPTION]
com.sap.sql.log.OpenSQLException: Exception of type java.sql.SQLRecoverableException caught: IO Error: The Network Adapter could not establish the connection.
at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:104)
at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:143)
at com.sap.sql.connect.datasource.DBDataSourceImpl.get(DBDataSourceImpl.java:289)
at com.sap.sql.connect.datasource.DBDataSourceImpl.getPooledConnection(DBDataSourceImpl.java:184)
at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:215)
Solution
The solution is to set JVM system parameter ‘oracle.jdbc.javaNetNio’ to value ‘false’ as seen below on the screen. Run configtool:
At the end restart the AS JAVA.