I have a BI Publisher report, which I want to burst and FTP the output. The FTP is working fine.
When the report is run standalone it gets executed and gives output, but when it is being scheduled through BI Publisher scheduler, getting the below error.
Can someone who has faced/not faced the same issue provide the resolution/inputs.
Thanks in advance.
I believe the below table would be handled by OBI itself, and column JOB_ID (primary key of table) on which the unique constraint is getting violated would be a sequence, then why its trying to insert the same value in this column?
Job submission failed:
oracle.xdo.servlet.scheduler.processingexception: exception [eclipselink-4002] (Eclipse Persistence Services - 2.6.5.v20170607 -
b3d05bd): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (BI_BIPLATFORM.SYS_C0054217) violated
Error : 1
Call: INSERT INTO XMLP_SCHED_JOB (JOB_ID, BURSTING, BURSTING_PARAMETERS, CREATED, DATA_LOCATOR, DELETED, DELIVERY_DESCRIPTION, DELIVERY_PARAMETERS,
END_DATE, INSTANCE_ID, ISSUER, JOB_GROUP, JOB_SET_ID, JOB_TYPE, LAST_UPDATED, NOTIFICATION_PARAMETERS, OWNER, PARENT_JOB_ID, REPORT_PARAMETERS, REPORT_URL, RUN_TYPE, SCHEDULE_CONTEXT, SCHEDULE_DESCRIPTION, SCHEDULE_PARAMETERS, SCHEDULE_SOURCE, SHARED_OPTION, START_DATE, STATUS, STATUS_DETAIL, STORAGE_TYPE, USER_DESCRIPTION, USER_JOB_NAME, XML_DATA_AVAILABLE, XML_DATA_COMPRESSED, XML_DATA_CONTENT_TYPE, XSCHURL) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [36 parameters bound]
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (BI_BIPLATFORM.SYS_C0054217) violated