My Oracle Support Banner

ODI Studio Fails with "The connection is closed" Error Message if Left Unattended or Idle (Doc ID 2445750.1)

Last updated on SEPTEMBER 25, 2018

Applies to:

Data Integration Platform Cloud - Version 18.3.3 and later
Autonomous Data Integration Platform Cloud - Version 18.3.3 and later
Oracle Data Integrator - Version and later
Information in this document applies to any platform.


After ten minutes of inactivity, Oracle Data Integrator (ODI) Studio disconnects from the repositories and fails with the following error message:

java.sql.SQLException: The connection is closed: The connection is closed
  at oracle.ucp.util.UCPErrorHandler.newSQLException(
  at oracle.ucp.util.UCPErrorHandler.newSQLException(
  at oracle.ucp.jdbc.proxy.JDBCConnectionProxyFactory.invoke(
  at oracle.ucp.jdbc.proxy.ConnectionProxyFactory.invoke(
  at com.sun.proxy.$Proxy30.rollback(Unknown Source)
  at sun.reflect.GeneratedMethodAccessor270.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
  at java.lang.reflect.Method.invoke(
  at com.sun.proxy.$Proxy31.rollback(Unknown Source)


>Fatal NI connect error 12170.

TNS for Linux: Version - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version - Production
TCP/IP NT Protocol Adapter for Linux: Version - Production
 Time: 05-SEP-2018 17:56:15
 Tracing not turned on.
 Tns error struct:
   ns main err code: 12535
TNS-12535: TNS:operation timed out
   ns secondary err code: 12560
   nt main err code: 505
TNS-00505: Operation timed out
   nt secondary err code: 110
   nt OS err code: 0
 Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=***.***.***.***)(PORT=<PORT_NUMBER>))




To view full details, 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 a vibrant support community of peers and Oracle experts.