Oracle Transactional Business Intelligence

Way to monitor custom scheduled BI Publisher report in the cloud?

Received Response
164
Views
6
Comments

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:

    1. 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.
    2. 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.

     

     

    history BI.JPG

  • 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

  • Hi Kristen & Melissa,

    was the reference to the web service helpful? Did you have a chance to check it yet?

     

    Thanks,

    Raphael

  • 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?

  • 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

  • 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.