WCI Collaboration Log Shows Unique Constraint Violations When Executing the Role Synchronization Job (Doc ID 1199594.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle WebCenter Collaboration - Version 10.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Dec-2013***

Symptoms

WebCenter Collaboration logs show recurring job failure errors similar to the one below:

2010-09-01 20:50:46,881 ERROR [RoleSynchronizationJob] service.AdministrationWebService (AdministrationWebService.java:36) - Failed to execute synchronizeAllCommumityMemberships

com.plumtree.core.pdo.PDOException: [plumtree][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (WCCOLLABDBUSER.PK_CSTASKASSIGNMENT) violated

at com.plumtree.core.pdo.PDOException.toPDOException(PDOException.java:54)
at com.plumtree.collaboration.tasklist.Task.synchronizeTaskAssignedToNameWithPortal(Task.java:850)
at com.plumtree.collaboration.service.AdministrationWebService.synchronizeCollaborationState(AdministrationWebService.java:31)
at com.plumtree.collaboration.project.RoleSynchronizationJob.handleAlarm(RoleSynchronizationJob.java:41)
at com.plumtree.core.scheduler.AsynchronousJob.run(AsynchronousJob.java:48)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.plumtree.openkernel.impl.openjdbc.OKJDBCDupKeyException: [plumtree][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (WCCOLLABDBUSER.PK_CSTASKASSIGNMENT) violated

at com.plumtree.openkernel.impl.openjdbc.OpenJDBCStatement.dupKeyCheck(OpenJDBCStatement.java:504)
at com.plumtree.openkernel.impl.openjdbc.OpenJDBCPreparedStatement.executeUpdate(OpenJDBCPreparedStatement.java:72)
at com.plumtree.collaboration.tasklist.Task.synchronizeTaskAssignedToNameWithPortal(Task.java:846)
... 4 more

Caused by:
com.plumtree.openkernel.impl.openjdbc.OKJDBCDupKeyException: [plumtree][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (WCCOLLABDBUSER.PK_CSTASKASSIGNMENT) violated

at com.plumtree.openkernel.impl.openjdbc.OpenJDBCStatement.dupKeyCheck(OpenJDBCStatement.java:504)
at com.plumtree.openkernel.impl.openjdbc.OpenJDBCPreparedStatement.executeUpdate(OpenJDBCPreparedStatement.java:72)
at com.plumtree.collaboration.tasklist.Task.synchronizeTaskAssignedToNameWithPortal(Task.java:846)
at com.plumtree.collaboration.service.AdministrationWebService.synchronizeCollaborationState(AdministrationWebService.java:31)
at com.plumtree.collaboration.project.RoleSynchronizationJob.handleAlarm(RoleSynchronizationJob.java:41)
at com.plumtree.core.scheduler.AsynchronousJob.run(AsynchronousJob.java:48)
at java.lang.Thread.run(Thread.java:595)

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