My Oracle Support Banner

Deadlock Detected When Globally Committing Multiple Sequentially Executing Integration Interfaces With ODI (Doc ID 423988.1)

Last updated on JUNE 16, 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.

Symptoms

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.

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
Cause
Solution
 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.