Troubleshooting
Problem
We had some exception regarding IO Error: Socket read timed out error for a flow updating data from SAP to Oracle.
The following are the stack trace of the error:
[ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource StDBResource:s2live_local.
[ADA.1.204] Cannot connect to the database with DataSource class "oracle.jdbc.pool.OracleDataSource".
IO Error: Socket read timed out
{MemData:exId=118.5053,exBundle=com.wm.pkg.art.i18n.resources.AdapterRuntimeResourceBundle,exError=118,exReason=5053,exDfltMsg=null,exWrapped=com.wm.adk.error.AdapterConnectionException: [ADA.1.204] Cannot connect to the database with DataSource class "oracle.jdbc.pool.OracleDataSource".
IO Error: Socket read timed out,exParmcnt=1,exParm=StDBResource:s2live_local,date=Wed May 29 06:09:09 CEST 2013,sessionId=SAPUser,sessionName=sap.rfc.Listener-"StSAPResource.SAPCRM.listener:EAICRM"-EAICRM-EUX950.SGP.ST.COM-0,sessionId=5ba87010c81511e281c5955b4cfe873a,serviceCallStack=[Ljava.lang.String;@19cd9c86,reason=[ADA.1.204] Cannot connect to the database with DataSource class "oracle.jdbc.pool.OracleDataSource".
IO Error: Socket read timed out,exceptionClass=com.wm.adk.error.AdapterConnectionException,stack=com.wm.adk.error.AdapterConnectionException: [ADA.1.204] Cannot connect to the database with DataSource class "oracle.jdbc.pool.OracleDataSource".
IO Error: Socket read timed out
at com.wm.adk.WmAdapter.createAdapterConnectionException(WmAdapter.java:276)
at com.wm.adapter.wmjdbc.connection.ConnectionInfo.handleSQLException(ConnectionInfo.java:1447)
at com.wm.adapter.wmjdbc.connection.ConnectionInfo.handleSQLException(ConnectionInfo.java:1461)
at com.wm.adapter.wmjdbc.connection.JDBCConnection.initializeConnection(JDBCConnection.java:335)
at com.wm.adk.connection.WmManagedConnectionFactory.createManagedConnection(WmManagedConnectionFactory.java:198)
at com.wm.app.b2b.server.jca.WmConnectionPool.createConnection(WmConnectionPool.java:1024)
at com.wm.app.b2b.server.jca.WmConnectionPool.getAvailConnection(WmConnectionPool.java:972)
at com.wm.app.b2b.server.jca.WmConnectionPool.getConnection(WmConnectionPool.java:496)
at com.wm.app.b2b.server.jca.WmConnectionManager.allocateManagedConnection(WmConnectionManager.java:415)
at com.wm.app.b2b.server.jca.WmXAConnectionManager.allocateConnection(WmXAConnectionManager.java:84)
at com.wm.adk.cci.connection.WmC...<truncated>
>>>BasicData:message=Cannot connect to the database with DataSource class "oracle.jdbc.pool.OracleDataSource".,date=Wed May 29 06:09:06 CEST 2013,reason=IO Error: Socket read timed out,exceptionClass=java.sql.SQLRecoverableException,stack=java.sql.SQLRecoverableException: IO Error: Socket read timed out
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
Document Location
Worldwide
Log InLog in to view more of this document
Was this topic helpful?
Document Information
Modified date:
20 March 2025
UID
ibm17205193