My Oracle Support Banner

ODI Load Plans are Getting Stuck when LDAP Server Goes Down in Load Balanced Environment (Doc ID 2768369.1)

Last updated on APRIL 23, 2021

Applies to:

Oracle Data Integrator - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Data Integrator (ODI) is configured to use two LDAP servers for External Authentication through a Load Balancer.

ODI Server >   Load Balancer   > LDAP Server 1
                                             > LDAP Server 2

When one of the LDAP Server goes down, the Load Plan being executed gets struck. When the failover happens, Load Plan tries to validate once as a default behavior and once it fails, the Load Plan never completes. Sometimes the Load Plan hangs as well.

For example, when a Load Plan has multiple steps, say 10 steps and when ODI is executing 5th steps and when one of the LDAP server goes down, 5th step is completed, but subsequent steps are not executed and Load Plan fails and is struck and agent log displays the below errors:

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
References


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