Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 185 Oracle Analytics News
- 40 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 63 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
ESS job fails if no data is returned by BI Publisher report's data model

Shakher Sharma
Rank 4 - Community Specialist
Description
Prevent ESS job from failing in case no data is returned by underlying BI Publisher report's Data Model
Use Case and Business Need
ESS job created for BI Publisher report fails in case no data is returned by report's Data Model.
Even creating a Scheduled Trigger to stop report from running in case no data is returned doesn't help. ESS job still runs, finds no data available, and fails.
The only possible solution is to use a workaround of appending a blank record to the report in case no data is returned. This solution though prevents ESS job from failing by creating a blank report, but is not elegant by nature.
Original Idea Number: 0c363694cf
Tagged:
1