How To Modify ODI Timeout Values

(Doc ID 423721.1)

Last updated on OCTOBER 19, 2017

Applies to:

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

Goal

A timeout

Oracle Data Integrator Timeout: connection with URL XXX and user YYY.
  at com.sunopsis.sql.SnpsConnection.a(SnpsConnection.java)
  ...

or

...
Caused By: oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:117)
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
  ...

is signaled when launching an Oracle Data Integrator (ODI) Scenario with either:

Where and how is it possible to increase the values of the appropriate Timeout settings?

Solution

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