I have an Oracle Stored procedure as the data source for a report. On occasion, the stored procedure may legitimately return no data.
However, Business Objects returns the following error 'No data to fetch, data providers have not been successfully refreshed (DMA007)'. I want to schedule this report in Broadcast Agent, but it does not execute if there is no data to fetch, whereas I want it to still distribute the empty report!
Any help would be appreciated.
Many Thanks
However, Business Objects returns the following error 'No data to fetch, data providers have not been successfully refreshed (DMA007)'. I want to schedule this report in Broadcast Agent, but it does not execute if there is no data to fetch, whereas I want it to still distribute the empty report!
Any help would be appreciated.
Many Thanks