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 18.104.22.168.0 and later
Information in this document applies to any platform.
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
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