Summary

Getting unique constraint violated error while scheduling BIP report.

Content

Hi all,

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?

Exact error:

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]

Query: InsertObjectQuery(oracle.xdo.servlet.scheduler.toplink.XmlpSchedJob@6177463)

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (BI_BIPLATFORM.SYS_C0054217) violated

Version

12.2.1.3.0

Code Snippet

NA