My Oracle Support Banner

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:

Oracle Agile PLM Framework - Version and later
Information in this document applies to any platform.


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


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

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(
at com.agile.admin.ldap.DirDAO.updateDirUsers(
at com.agile.upgrade.ldap.Migration.batchUpdateUsers(
at com.agile.upgrade.ldap.Migration.doIt(
at com.agile.upgrade.ldap.Migration.updateUsersFromLdap(
at com.agile.pc.cmserver.user.UserService.updateUsersFromLdap(
at com.agile.upgrade.ldap.MigrationTask.execute(



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




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
 If you know who is the problem user's Agile login id:
 If you do not know the problem user's Agile login id:
 If the problem is happening for all the LDAP users, and you wish to reset the information for all the LDAP users:

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