Pages

Wednesday 8 April 2015

ICN Sync duplicated key exception

Caused by: org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [MERGE INTO navigator.wPIo0ATdivsta1h_MANIFEST AS TS USING (VALUES('EC18F932-7155-CE06-8760-4C7E89100000')) AS DAT(OBJECTID) ON TS.OBJECTID = DAT.OBJECTID WHEN NOT MATCHED THEN INSERT (OBJECTID, SUBSCRIPTIONID, ISCONTAINER) VALUES (DAT.OBJECTID, '106295c1-3e59-4124-9074-52fe7dd9517d', 0);]; Violation of UNIQUE KEY constraint 'M_wPIo0ATdivsta1h_I2'. Cannot insert duplicate key in object 'navigator.wPIo0ATdivsta1h_MANIFEST'. The duplicate key value is (EC18F932-7155-CE06-8760-4C7E89100000).; nested exception is com.ibm.websphere.ce.cm.DuplicateKeyException: Violation of UNIQUE KEY constraint 'M_wPIo0ATdivsta1h_I2'. Cannot insert duplicate key in object 'navigator.wPIo0ATdivsta1h_MANIFEST'. The duplicate key value is (EC18F932-7155-CE06-8760-4C7E89100000).
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:228)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:522)
at com.ibm.ecm.sync.core.db.spring.BaseSpringDAO.createRepositoryObjectWithCallerTransaction(BaseSpringDAO.java:108)
at com.ibm.ecm.sync.core.db.spring.RepositorySpringDAO.registerRepositoryObjectWithSameRegistrationsAsParent(RepositorySpringDAO.java:530)
at com.ibm.ecm.sync.api.RepositoryController.procesNotification(RepositoryController.java:333)
... 31 more
Caused by: com.ibm.websphere.ce.cm.DuplicateKeyException: Violation of UNIQUE KEY constraint 'M_wPIo0ATdivsta1h_I2'. Cannot insert duplicate key in object 'navigator.wPIo0ATdivsta1h_MANIFEST'. The duplicate key value is (EC18F932-7155-CE06-8760-4C7E89100000).

at sun.reflect.GeneratedConstructorAccessor37.newInstance(Unknown Source) 

No comments:

Post a Comment