My Oracle Support Banner

Error "java.sql.SQLRecoverableException: IO Error: Got minus one from a read call" and Task Queued Forever (Waiting State) in ODI Load Plan (Doc ID 2044766.1)

Last updated on JULY 17, 2019

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

The initialize task which is first task in an Oracle Data Integrator (ODI() Load Plan remains in a **waiting** state forever.

The following error is logged in the Weblogic managed server log:

<> <pool-2-thread-15> <> <> <> <> <BEA-001156> <Stack trace associated with message <MESSAGE#> follows:

java.sql.SQLRecoverableException: IO Error: Got minus one from a read call
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
  at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)
  at ...
Caused By: oracle.net.ns.NetException: Got minus one from a read call
  at oracle.net.ns.Packet.receive(Packet.java:305)
  at oracle.net.ns.NSProtocol.connect(NSProtocol.java:308)
  at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1229)
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:326)
  at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)
  at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:234)
  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
  at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:390)
  at ...
>

In the odiagent.log file the following error is logged:

[<MANAGED_SERVER>] [ERROR] [ODI-1131] [] [tid: <TID>] [userId: <anonymous>] [ecid: <ECID>] [APP: oraclediagent] Agent <AGENT_NAME> encountered an error: ODI-10138: Unable to create DwgConnectConnection to MASTER repository. [[
weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool odiMasterRepository to allocate to applications, please increase the size of the pool and retry.. oracle.odi.core.repository.RepositoryResourceFailureException: ODI-10138: Unable to create DwgConnectConnection to MASTER repository.
weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool odiMasterRepository to allocate to applications, please increase the size of the pool and retry..
  at oracle.odi.core.persistence.dwgobject.DwgRepositoryConnectConnectionUtils.doGetMasterDwgConnectConnection(DwgRepositoryConnectConnectionUtils.java:85)
  at oracle.odi.core.persistence.dwgobject.DwgRepositoryConnectConnectionUtils.doGetMasterDwgConnectConnection(DwgRepositoryConnectConnectionUtils.java:97)
  at oracle.odi.core.persistence.dwgobject.DwgRepositoryConnectConnectionUtils.doGetMasterDwgConnectConnection(DwgRepositoryConnectConnectionUtils.java:39)
  at oracle.odi.core.persistence.dwgobject.DwgRepositoryConnectConnectionUtils.doGetMasterDwgConnectConnection(DwgRepositoryConnectConnectionUtils.java:31)
  at oracle.odi.core.security.SecurityManager.createDwgSecurityManager(SecurityManager.java:130)
  at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:523)
  at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:252)
  at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:550)
  at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:518)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
  at ...
Caused by: java.sql.SQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool odiMasterRepository to allocate to applications, please increase the size of the pool and retry..
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
  at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
  at com.sunopsis.sql.SnpsConnection.createConnection(SnpsConnection.java:390)
  at com.sunopsis.sql.SnpsConnection.connect(SnpsConnection.java:348)
  at oracle.odi.core.persistence.dwgobject.DwgRepositoryConnectConnectionUtils.doGetMasterDwgConnectConnection(DwgRepositoryConnectConnectionUtils.java:80)
  ... 34 more
Caused by: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool odiMasterRepository to allocate to applications, please increase the size of the pool and retry..
  at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:252)
  at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:470)
  at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:552)
  at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:512)
  at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:505)
  at org.springframework.jdbc.datasource.UserCredentialsDataSourceAdapter.doGetConnection(UserCredentialsDataSourceAdapter.java:162)
  at org.springframework.jdbc.datasource.UserCredentialsDataSourceAdapter.getConnection(UserCredentialsDataSourceAdapter.java:133)
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:217)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
  at java.util.concurrent.FutureTask.run(FutureTask.java:262)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  at java.lang.Thread.run(Thread.java:744)

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.