My Oracle Support Banner

[STUCK] Threads and ODI 11g Sessions Accumulating in Waiting Status when Using a JRockit JVM (Doc ID 2459550.1)

Last updated on FEBRUARY 11, 2019

Applies to:

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

Symptoms

The following error is observed when attempting to execute Oracle Data Integrator (ODI) 11g artifacts with a JRockit Java:

... [ERROR] [ODI-1131] ... [APP: oraclediagent] Agent OracleDIAgent encountered an error: ODI-10138: Unable to create DwgConnectConnection to WORK repository. [[
A login timeout occured while connecting to the database oracle.odi.core.repository.RepositoryResourceFailureException: ODI-10138: Unable to create DwgConnectConnection to WORK repository.
A login timeout occured while connecting to the database
  at oracle.odi.core.persistence.dwgobject.DwgRepositoryConnectConnectionUtils.doGetWorkDwgConnectConnection(DwgRepositoryConnectConnectionUtils.java:145)
  at oracle.odi.core.persistence.dwgobject.DwgRepositoryConnectConnectionUtils.doGetWorkDwgConnectConnection(DwgRepositoryConnectConnectionUtils.java:177)
  at oracle.odi.core.persistence.dwgobject.DwgRepositoryConnectConnectionUtils.doGetWorkDwgConnectConnection(DwgRepositoryConnectConnectionUtils.java:172)
  at oracle.odi.core.security.SecurityManager.createDwgSecurityManager(SecurityManager.java:137)
  at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:817)
  at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:550)
  at ...
Caused by: oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:117)
  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.doGetWorkDwgConnectConnection(DwgRepositoryConnectConnectionUtils.java:140)
  ... 31 more

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.