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 9.3.0.0 and later
Information in this document applies to any platform.


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)

Changes

 

Cause

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.