ODI Shows Session Running While DB Side Sessions Completed

(Doc ID 2129410.1)

Last updated on MAY 30, 2016

Applies to:

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

Symptoms

An ODI package containing many steps like interfaces and ODI procedures (which calls database procedures) executed with Local (No Agent) still shows as RUNNING in the ODI operator log after 2 hours, even though the process successfully completed on database. For example the package is hanging in step number 10, but the database side procedure for this step  is already finished.

There are no errors reported in the ODI Operator.

Cause

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