ODI API Calls via J2EE Agent Fail with "No LDAP connection available to process request" (Doc ID 2637332.1)

Last updated on JULY 28, 2023

Applies to:

Symptoms

The WebLogic environment is configured with Active Directory (AD), so the Oracle Data Integrator (ODI) J2EE Agent starts with a user from AD. Invoking ODI scenarios with ODI API via J2EE Agent fail with the following errors. There are no failed sessions in ODI operator.

Errors from J2EE Agent log:

[2020-02-05T16:13:18.834+00:00] [<managed_server_name>] [WARNING] [] [oracle.odi.agent] [userId: <anonymous>] [APP: oraclediagent] [partition-name: DOMAIN] [tenant-name: GLOBAL] Exception occurred in dequeueAndRunSession.[[
oracle.security.jps.JpsRuntimeException: oracle.igf.ids.IDSException: Operations error: entity=DC=<...>,DC=<...> op=find mesg=  
    at oracle.security.jps.internal.core.util.SubjectUtilInternal.getRolePrincipalHolderInternal(SubjectUtilInternal.java:806)
    at oracle.security.jps.internal.core.util.SubjectUtilInternal.getRolePrincipalHolderInternal(SubjectUtilInternal.java:759)
    at oracle.security.jps.util.SubjectUtil.getRolePrincipalHolder(SubjectUtil.java:676)
    at oracle.odi.core.security.SecurityManager.computeGrantedODIRoles(SecurityManager.java:1043)
    at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:899)
    at oracle.odi.core.security.SecurityManager.createAuthentication(SecurityManager.java:385)
    at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor$1.run(QueuedSessionsExecutor.java:161)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
    at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: oracle.igf.ids.IDSException: Operations error: entity=DC=<...>,DC=<...> op=find mesg=  
    at oracle.igf.ids.arisid.ArisIdServiceManager.findEntity(ArisIdServiceManager.java:1712)
    at oracle.igf.ids.UserManager.searchUser(UserManager.java:184)
    at oracle.security.jps.internal.common.util.JpsCommonUtil.searchUserIDS(JpsCommonUtil.java:1428)
    at oracle.security.jps.internal.core.util.SubjectUtilInternal.getRolePrincipalHolderInternal(SubjectUtilInternal.java:777)
    ... 13 more
Caused by: oracle.igf.ids.arisid.ArisIdConnectionException: Operations error: entity=DC=<...>,DC=<...> op=find mesg=   AdditionalInfo: No LDAP connection available to process request for DN: CN=<user_name>,OU=<...>,OU=<...>,OU=<...>,DC=<...>,DC=<...>.
    at com.oracle.ovd.arisid.OvdIdsStackProvider.mapResultCode(OvdIdsStackProvider.java:775)
    at com.oracle.ovd.arisid.OvdIdsStackProvider.doFind(OvdIdsStackProvider.java:1335)
    at com.oracle.ovd.arisid.ArisIdStackProvider.doFind(ArisIdStackProvider.java:172)
    at org.openliberty.arisid.Interaction.doFind(Interaction.java:1022)
    at oracle.igf.ids.arisid.ArisIdServiceManager.findEntity(ArisIdServiceManager.java:1628)
    ... 16 more
Caused by: oracle.ods.virtualization.service.VirtualizationException: oracle.ods.virtualization.engine.util.DirectoryException: No LDAP connection available to process request for DN: CN=<user_name>,OU=<...>,OU=<...>,OU=<...>,DC=<...>,DC=<...>.
    at oracle.ods.virtualization.operation.SearchOperation.process(SearchOperation.java:209)
    at oracle.ods.virtualization.operation.SearchOperation.process(SearchOperation.java:47)
    at oracle.ods.virtualization.service.DefaultVirtualizationSession.processOperation(DefaultVirtualizationSession.java:403)
    at oracle.ods.virtualization.service.DefaultVirtualizationSession.search(DefaultVirtualizationSession.java:190)
    at com.oracle.ovd.arisid.OvdIdsStackProvider.doFind(OvdIdsStackProvider.java:1326)
    ... 19 more
Caused by: oracle.ods.virtualization.engine.util.DirectoryException: No LDAP connection available to process request for DN: CN=<user_name>,OU=<...>,OU=<...>,OU=<...>,DC=<...>,DC=<...>.
    at oracle.ods.virtualization.engine.backend.jndi.JNDIConnectionPool.checkOutContext(JNDIConnectionPool.java:301)
    at oracle.ods.virtualization.engine.backend.jndi.BackendJNDI.getLDAPContext(BackendJNDI.java:1126)
    at oracle.ods.virtualization.engine.backend.jndi.BackendJNDI.getConnection(BackendJNDI.java:1027)
    at oracle.ods.virtualization.engine.backend.jndi.ConnectionHandle.getHolder(ConnectionHandle.java:470)
    at oracle.ods.virtualization.engine.backend.jndi.ConnectionHandle.search(ConnectionHandle.java:276)
    at oracle.ods.virtualization.engine.backend.jndi.JNDIEntrySet.initialize(JNDIEntrySet.java:223)
    at oracle.ods.virtualization.engine.backend.jndi.BackendJNDI.get(BackendJNDI.java:811)
    at oracle.ods.virtualization.engine.chain.Chain.nextGet(Chain.java:303)
    ...
]]

Cause