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 AUGUST 21, 2016

Applies to:

Oracle Agile PLM Framework - Version 9.2.1.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.evermind.sql.FilterStatement.executeBatch(FilterStatement.java:410)
at com.evermind.sql.FilterStatement.executeBatch(FilterStatement.java:410)
at com.evermind.sql.StatementBCELProxy.executeBatch(StatementBCELProxy.java:416)
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)

Cause

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 hundreds of Community platforms