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 OCTOBER 10, 2019
Applies to:
Oracle Data Integrator - Version 10.1.3.5.0 and laterInformation in this document applies to any platform.
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
...
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 |