Big pipe fails due to harvest errors / Import conguration fails
- 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