Database Connections are not Restored Automatically when a Database used by ODI is Bounced
(Doc ID 2523046.1)
Last updated on OCTOBER 18, 2019
Applies to:
Oracle Data Integrator - Version 11.1.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
On Oracle Data Integrator (ODI), when a Package runs in a loop connecting multiple times to a database instance, in the event that the database instance crashes...
... the Package does not reconnect automatically after the database instance is restored, and the following error message is received:
ODI-1226: Step <STEP NAME> after 1 attempt(s).
ODI-1228: Task <TASK NAME> fails on the target connection <NAME>.
Caused By: java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.getAutoCommit(PhysicalConnection.java:2168)
at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter$OnDisconnectCommandExecutionHandler.invoke(OnConnectOnDisconnectDataSourceAdapter.java:231)
at com.sun.proxy.$Proxy32.getAutoCommit(Unknown Source)
at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.sunopsis.sql.SnpsConnection$ConnectionProxyInvocationHandler.invoke(SnpsConnection.java:143)
at com.sun.proxy.$Proxy35.getAutoCommit(Unknown Source)
at com.sunopsis.sql.SnpsConnection.connect(SnpsConnection.java:499)
at ...
To demonstrate the problem, consider the ODI Package below:
The "Extract Data" Procedure step above just connects to a target database, and extracts the data.
In the event of a database crash (or shutdown due to maintenance), the connection will not be re-established, and the error above will arise.
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 |