LDAP Synchronizing Is Not Working In Agile (Doc ID 2518771.1)

Last updated on OCTOBER 13, 2023

Applies to:

Symptoms

LDAP Synchronizing is not working.
Log shows the below error:

ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1552509348320> <BEA-000337> <[STUCK] ExecuteThread: '17' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "1,259" seconds working on the request "com.agile.pc.cmserver.user.UserSessionBean_qy39gj_EOImpl", which is more than the configured time (StuckThreadMaxTime) of "1,200" seconds in "server-failure-trigger". Stack trace:
java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(SocketInputStream.java:152)
java.net.SocketInputStream.read(SocketInputStream.java:122)
oracle.net.nt.MetricsEnabledInputStream.read(TcpNTAdapter.java:759)
oracle.net.ns.Packet.receive(Packet.java:312)
oracle.net.ns.DataPacket.receive(DataPacket.java:106)
oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:306)
oracle.net.ns.NetInputStream.read(NetInputStream.java:250)
oracle.net.ns.NetInputStream.read(NetInputStream.java:172)
oracle.net.ns.NetInputStream.read(NetInputStream.java:90)
oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124)
oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80)
oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:452)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:414)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1006)
oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:15398)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:15546)
oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:264)
weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:216)
com.agile.admin.ldap.DirDAO.updateDirUsers(DirDAO.java:566)

and also 

ERROR ORA-01013: user requested cancel of current operation

java.sql.BatchUpdateException: ORA-01013: user requested cancel of current operation

       at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:15709)
       at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:264)
       at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:216)
       at com.agile.admin.ldap.DirDAO.updateDirUsers(DirDAO.java:566)
       at com.agile.upgrade.ldap.Migration.batchUpdateUsers(Migration.java:461)
       at com.agile.upgrade.ldap.Migration.doIt(Migration.java:290)
       at com.agile.upgrade.ldap.Migration.updateUsersFromLdap(Migration.java:97)
       at com.agile.pc.cmserver.user.UserService.updateUsersFromLdap(UserService.java:266)
       at com.agile.pc.cmserver.user.UserSessionBean.updateUsersFromLdap(UserSessionBean.java:2034)
       at com.agile.pc.cmserver.user.UserSessionBean_qy39gj_EOImpl.__WL_invoke_2(Unknown Source)
       at com.agile.pc.cmserver.user.UserSessionBean_qy39gj_EOImpl.__WL_invoke_1(Unknown Source)
       at com.agile.pc.cmserver.user.UserSessionBean_qy39gj_EOImpl.__WL_invoke(Unknown Source)

Cause

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