Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to avoid 'NO_DATA_TO_PROCESS' errors in BI Bursting schedule

Received Response
2367
Views
12
Comments
Veluru Naresh
Veluru Naresh Rank 2 - Community Beginner
edited Apr 16, 2024 8:01AM in Oracle Analytics Publisher

Summary

How to avoid 'NO_DATA_TO_PROCESS' errors in BI Bursting schedule

Content

Hi,

we have a bursting report which has scheduled on daily basis and the schedule is completing with the 'Success' status when there is data to process.

But when there is no data to process, the process is completing with the status 'Failed' and with 'NO_DATA_TO_PROCESS' error.

Can someone guide me how to avoid this failed notifications ?

«1

Answers

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics & AI Lead

    Naresh,

    Please take a look at the below doc , this is not directly related to ur problem but seems to be a work around

    Doc ID 1925999.1

    Also check the below blog post might be helpful

    https://blogs.oracle.com/xmlpublisher/no-data-found

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics & AI Lead

    Naresh - can you test if you can implement logic in the bursting query ?? like a case statement if the record count of the main query is null exit, if not null move on to the actual bursting query ??

  • Veluru Naresh
    Veluru Naresh Rank 2 - Community Beginner

    Hi YGUTTIKONDA,

    Following tail of the your note 1925999.1 I found out one option to achieve this requirement through 'Event Triggers'. Below is the document and using this we can skip the current schedule if there is no data.

    Thanks for your response.

  • Veluru Naresh
    Veluru Naresh Rank 2 - Community Beginner

    Thanks again for your response. The document will not help for our scenario since the notifications are ON for multiple vendors and if I change the query to have at least one record to retun then that record will be sent to the all vendors each time when there is no data. These notifications are related to the payroll data so, we can't send some default values.

  • Veluru Naresh
    Veluru Naresh Rank 2 - Community Beginner

    Hi,

    Thanks for your response. I tried to do that but even then I am getting the same error because the bursting query is not returning any value for that schedule run.

  • Veluru Naresh
    Veluru Naresh Rank 2 - Community Beginner

    Through event trigger option data model section we have avoided this error.

  • Chandra Thangavelu
    Chandra Thangavelu Rank 1 - Community Starter

    Hi Veluru

    Can you please explain how you avoided this error. Ex or screenshot please

  • Clyde
    Clyde Rank 2 - Community Beginner

    Hi Chandra,

    Please refer the below document for adding an Event Trigger:

    BI Publisher Schedule Error: "There is no data to process" (Doc ID 2957419.1)

    Regards,

  • Anjum H M
    Anjum H M Rank 1 - Community Starter

    Hi @Clyde

    Is it possible to implement this without Event Triggers? If yes Please help.

    Thanks!

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics & AI Strategist
    https://community.oracle.com/products/oracleanalytics/discussion/comment/69176#Comment_69176

    Hi Anjum,

    It is not possible to achieve this without using schedule triggers.

    Thanks.