I have a notification (BIP report) that I am testing in Prod, which is a copy of one we are using in Prod. It is scheduled to run every 30 minutes. When it completes with a status of Success, there is no output generated for my test notification. If I click 'Republish' the report output appears on the report output page. I am guessing there is something wrong with the bursting definition, but I cannot figure this out. The data model Properties are identical (except for name, of course). The schedules are identical, down to the second. The data set is slightly different (I am testing a fix) and the bursting SQL query appears to be accurate. The Report Job Name I am using is 'MJP Move to HR Notification Fix Test', which is used in the where clause of the data set and bursting query. I'm at a loss, as I have looked at everything. What could I be missing in my troubleshooting? I have scoured MOS, CCC, and followed the guide. Thanks in advance for your assistance!

Thank you @Kevin M-Oracle and @Mallikarjuna Kuppauru-Oracle , I truly appreciate the help. I had verified the bursting option before, so that wasn't the root cause. However, I found the solution to my problem, which was user error, of course. Maybe this helps someone else, but I compared the Data Model SQL to the Bursting SQL and found there was a slight difference. I corrected that and it resolved my problem. I am guessing that a best practice is this: assure that your Data Model query matches the query within the bursting definition.

Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Publisher

'No output available' with Report Status 'Success'

Accepted answer

1071

Views

Comments

Answers

Bhaskar Konar Rank 8 - Analytics Strategist

Mar 3, 2025 2:30PM

https://community.oracle.com/products/oracleanalytics/discussion/comment/54423#Comment_54423

Very helpful information.
Thanks for sharing @MarkPescatrice!

0

MFA for Oracle Community

Oracle Analytics Publisher

Categories

'No output available' with Report Status 'Success'

Answers