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 JUNE 06, 2018

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:

Error: "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(




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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