Categories
- All Categories
- 4 Oracle Analytics Videos
- 13.7K Oracle Analytics Forums
- 5.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 57 Oracle Analytics News
- 32 Oracle Analytics Trainings
- 53 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Way to monitor custom scheduled BI Publisher report in the cloud?
Summary
Looking for way to monitor the status of scheduled jobs inside the fusion cloud environment
Content
We have multiple critical scheduled reports and process that drive other audited processes internally. Enabling a failure notification covers failed runs, but we've had situations where the scheduled run is stopped by a downtime and doesn't reschedule and therefore doesn't know it failed (and therefore doesn't notify of failure). Ideally we'd have something outside the system looking for our critical process and checking last run date to see if the thresholds have been exceeded then perform some other action, but really would take any viable solution at this point. There seems to be a general absence on this type of information for the cloud offering. Wondering what others have done or know about?
Answers
-
We have had similar issues with our critical BI reports we have scheduled. Most notable we have several daily scheduled reports to key stakeholders. After each upgrade I have had to cancel and reschedule the reports due to the report scheduler stopping unexpectedly if the job runs during any downtime of the system. The job essentially gets 'stuck' and doesn't know to resume to normal once the downtime is over.
Oracle currently has 2 bugs.
Both seem as if they are fixed in current product versions (Rel 8) according to the bug however not sure the accuracy as I have not tested in new upgrade/patches/ and such.
- Bug 19664296 : ZQF: DAILY SCHEDULED BI REPORTS IN THE BIP DID NOT RUN AS SCHEDULED (FA)
- Bug 19562950 : SCHEDULED JOBS IN BIEE NOT REACTIVATED AFTER FA REL 8 DROPPED
Their are a few methods I use to see if a BI report went through okay or not:
- On all BI jobs I schedule I have a reporting inbox that gets CC'ed on everything. Having the inbox allows me to audit what is sent for the day. Something that is supposed to be sent daily is easy to catch especially when i don't see it in the inbox.
- I have attached a history BI screen. When in BI you can go to Home > Report Jobs. I have all my report jobs scheduled so the frequency of the Job is the first string in the Report Job Name. If the status is active I can then assume that the job should still be sending through. When clicking the history link you can view all past jobs ran. If you see an active job however no history for a job sending on an expected day then you can assume the report never got sent through successfully.
These are my audit methods I was able to think of and use for now until something better comes up.
0 -
Hi,
there are web services that can be used to fetch the required information. For instance:
https://<your-instance>/xmlpserver/services/PublicReportService?WSDL
The web services can be called by any integration tool, java program or even from within Fusion/Cloud Applications.
Regards,
Raphael
0 -
Hi Kristen & Melissa,
was the reference to the web service helpful? Did you have a chance to check it yet?
Thanks,
Raphael
0 -
I tried the web service, but I am stuck getting the data into the data model; I think I need a user name?
I found this Oracle doc - https://support.oracle.com/epmos/faces/DocumentDisplay?id=2086077.1
and this external site - https://apps2fusion.com/oracle-fusion-online-training/fusion-applications/fusion-payroll/1423-creating-bi-publisher-report-from-a-web-service
Is there a tutorial or video?
0 -
Hi Melissa,
did find any better solution on this? I have a similar requirement. if you have any BI report on this, could you kindly share on this post.
thanks & regards
Rohini
0 -
Hi Rohini,
We don't have a great solution (imo), but we have a solution that works. I ended up using Nagios and Fusion SOAP Web Services to monitor our critical processes, extracts, and reports.
The following WS are in use:
- ReportService v2
- ScheduleService v2
I looked at using esswebservice for the ESS processes, but ended up writing a SQL report to check for status and return the report output via the ReportService WS. Same with extracts. The SQL is simple that I used. Rohini, do you intend to do something similar or were asking for the sake of the community? Creation and some maintenance for this type of exercise in a large organization is not easy.
Thanks.
0