My Oracle Support Banner

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 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:

However, a deadlock situation arises at runtime.

Remarks: An Interface / Procedure IP2 needs to read data inserted into a datastore by a previous one (IP1), even if IP1 has not been committed.


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

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