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 SEPTEMBER 22, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.4.0 to 12.2.1.4.230306 [Release 12c]
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 to 12.2.1.4.230306
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

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!

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