Categories
How to avoid 'NO_DATA_TO_PROCESS' errors in BI Bursting schedule

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 ?
Answers
-
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.
0 -
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.
0 -
Naresh,
Please take a look at the below doc , this is not directly related to ur problem but seems to be a work around
Also check the below blog post might be helpful
0 -
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 ??
0 -
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.
0 -
Through event trigger option data model section we have avoided this error.
0 -
Hi Veluru
Can you please explain how you avoided this error. Ex or screenshot please
0 -
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,
0