Intermittent "java.sql.SQLRecoverableException: IO Error: Connection reset" "ODI-1131" Or "ODI-1414" Messages Signaled When Running An ODI Scenario (Doc ID 1282792.1)

Last updated on MAY 02, 2017

Applies to:

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

Symptoms

When either

the following messages are intermittently signaled by Oracle Data Integrator (ODI):

java.sql.SQLRecoverableException: IO Error: Connection reset
 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:421)
 at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:531)
 at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:221)
 at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverE
 ...

or

ODI-1414: Error connecting to agent Internal : a JDBC error occurs while connecting to the master repository:
oracle.odi.core.config.MasterRepositoryResourceFailureException: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is
nested exception is oracle.odi.jdbc.datasource.connectiontimeoutexception: A login timeout occured while connectng to database
 at oracle.odi.core.repository.Repository.getMasterRepository (Repository.java: 74)
 at oracle.odi.core.OdiInstance.createMasterRepository (OdiInstance.java: 501)
 at oracle.odi.core.OdiInstance. <init> (OdiInstance.java: 553)
 ...

or

2011-08-12 14:35:10.092 INCIDENT_ERROR ODI-1131 Agent Internal encountered an error: ODI-1428: internal error
Error while executing.
oracle.odi.runtime.agent.PreparationException: Create DwgConnectConnection to work repository failed; nested exception is oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database
 at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doPrepareAgentTask(StartScenRequestProcessor.java:240)
 at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.proces
 ...

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms