Business Intelligence

Get Involved. Join the Conversation.

Topic

    Manoj Deole
    Issue while scheduling BI Publisher report - 12.2.1.3.0
    Topic posted May 27, 2019 by Manoj Deole, tagged BI Publisher 
    25 Views, 1 Comment
    Title:
    Issue while scheduling BI Publisher report - 12.2.1.3.0
    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
    Image:
    Code Snippet:

    Comment

     

    • Pradeep Sharma

      This will require investigation as we are not able to recreate this on our side. We had a similar issue with another customer and engineering team had to run a script to fix the sequence number issue. Please raise a service request so that engineering team can investigate and help fix the issue. If an SR already exist, please let us know.