• Article Type: General
• Product: Primo
• Product Version: 4

Problem Symptoms:
pipe fails due to harvest errors
Errors in the harvest log :

Caused by: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: Could not execute JDBC batch update; SQL [insert into M_P_BULK_CONTEXT (BULK_NUMBER, IS_DELETED, STATUS, PUBLISHING_WORK_ID, CONTENT_COUNT, PRIORITY, STAGE, ERROR_MSG, LAST_TASK, CONTENT, CREATION_DATE, UPDATED_DATE, UPDATED_BY, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; ORA-00001: unique constraint (P41_PRM00.M_P_BULK_CONTEXT_PK_03) violated
; nested exception is java.sql.BatchUpdateException: ORA-00001: unique constraint (P41_PRM00.M_P_BULK_CONTEXT_PK_03) violated
-Errors in be_log during import:
ERROR [t-AllImport] [c-JDBCExceptionReporter] - ORA-00001: unique constraint (P41_PRM00.C_C_CODE_TABLES_PK_02) violated

Cause:
There is a hibernate unique constrain

Resolution:
To Resolve please open SI to Primo support to alter the HIBERNATE_SEQUENCE to a greater value.

Category: BO monitoring

Subject: Pipes Monitoring

• Article last edited: 10/8/2013