How to avoid 'NO_DATA_TO_PROCESS' errors in BI Bursting schedule

Veluru Naresh

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 ?

Veluru Naresh

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.

Fusion Apps, BI Publisher, Bursting a BI Publisher Report or HCM Extract Results in Report Failures, Error Message "NO_DATA_TO_PROCESS" (Doc ID 1605001.1)

Veluru Naresh

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.

YGUTTIKONDA

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

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

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

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

Chandra Thangavelu

Hi Veluru

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

Clyde

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

Hi @Clyde

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

Thanks!

MandeepGupta

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.