Oracle Analytics Publisher

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

Issue with Bursting Query in Oracle Report: "There is no data to process" Error

Received Response
108
Views
1
Comments
Sree29
Sree29 Rank 1 - Community Starter

I have created a report in Oracle that outputs data correctly when run on its own. However, when I attach a bursting query and run it through an ESS job, I receive the error: "There is no data to process", even though there is data available.

Here is the bursting query I am using:

SELECT '1' AS KEY,
'Department Delete Report' AS TEMPLATE,
'TEXT' AS OUTPUT_FORMAT,
'en' AS LOCALE,
'FTP' AS DEL_CHANNEL,
'PSA_DEV2_V2' AS PARAMETER1,
NULL AS PARAMETER2,
NULL AS PARAMETER3,
'/in' AS PARAMETER4,
'Department_Delete_' || TO_CHAR(SYSDATE, 'YYYYMMDD') || '_' || TO_CHAR(SYSDATE, 'HHMMSS') || '.csv' AS PARAMETER5,
'TRUE' AS PARAMETER6 -- secure FTP or not
FROM DUAL;

I have verified that the report runs fine without the bursting and produces data. The bursting query seems correct, and I'm using the following setup for the FTP output file. I have enabled bursting option as well.

Despite these efforts, the ESS job always returns the "There is no data to process" error. Any insights or suggestions on what might be going wrong?

Thanks in advance for your help!

Answers