My Oracle Support Banner

Failure to Terminate Database Sessions when Exectuing Procedures Within ODI Studio Using "Stop Immediate" or "stopsession.sh" Command Line (Doc ID 2887366.1)

Last updated on AUGUST 19, 2022

Applies to:

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

Symptoms

When selecting to terminate an executed Oracle Data Integrator (ODI) job by accessing the job in the Operator tab within ODI Studio Client and right clicking and selecting "Stop Immediate", the session will terminate in ODI, BUT the database session will continue to run at the database level.

The Operator log will report no inserts of rows or no creation of tables, but the database session remains active and continues to create tables and make inserts which it should not.

Same behavior occurs when using the stopsession.sh command

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.