Deadlock Detected When Globally Committing Multiple Sequentially Executing Integration Interfaces With ODI
(Doc ID 423988.1)
Last updated on OCTOBER 04, 2022
Applies to:Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.
This problem can occur on any platform.
When sequentially executing multiple ODI Integration Interfaces / Procedures, I would like to globally commit the entire job only after all Interfaces / Procedures have been correctly executed.
In order to do this, the "COMMIT" options of the Procedures and Knowledge Modules used in the Package have been set to:
- TRUE - for the final Interface / Procedure to be executed;
- FALSE - for all previous Interfaces / Procedures.
However, a deadlock situation arises at runtime.
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
|1st work around|
2nd work around