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 17, 2021

Applies to:

Symptoms

When either

• running a Scenario with the startscen (.bat/.sh) script,
• or running multiple Scenarios in parallel

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

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