When Synchronizing LDAP Users, the Following Error Occurs: java.sql.BatchUpdateException: ORA-00001: unique constraint (AGILE.UK_AGILEUSER) violated (Doc ID 569483.1)

Last updated on MARCH 03, 2023

Applies to:

Symptoms

When executing an LDAP synchronization (sync), and Oracle Unique Constraint error occurs:

Error:

java.sql.BatchUpdateException: ORA-00001: unique constraint (AGILE.UK_AGILEUSER) violated"

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:380)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9080)
...
at com.agile.admin.ldap.DirDAO.updateDirUsers(DirDAO.java:482)
at com.agile.upgrade.ldap.Migration.batchUpdateUsers(Migration.java:346)
at com.agile.upgrade.ldap.Migration.doIt(Migration.java:183)
at com.agile.upgrade.ldap.Migration.updateUsersFromLdap(Migration.java:90)
at com.agile.pc.cmserver.user.UserService.updateUsersFromLdap(UserService.java:206)
at com.agile.upgrade.ldap.MigrationTask.execute(MigrationTask.java:50)
at com.agile.common.server.eventmgr.RunnableEvent.run(RunnableEvent.java:52)

Steps

The issue can be reproduced at will with the following steps:

1. Log into Java Client as admin user
2. Go to Admin tab > User Settings > Users
3. Click "Refresh Users from LDAP Directory"
4. Check Agile Application Server log. See the error
5. Error is also seen in ldap-migration.log under %Agile_Home%\agileDomain\servers\{server_name}-Agile\logs

Changes

Cause

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