6 Viewing and Managing Report History
This chapter describes the BI Publisher job history features including republishing data from history, sending the job output to new destinations, and getting error information on report jobs that did not complete successfully.
This chapter includes the following sections:
6.1 Viewing Report Job History and Saved Output
The Report Job History page displays information about running and completed report jobs. You can access this page and then search for the report job history; or, you can access this page from the context of a specific report.
To search for job history, navigate to this page in one of the following ways:
-
From the Home Page: Under Browse/Manage click Report Job History
-
On the global header: Click Open, and then click Report Job History
To access this page from the context of a specific report perform one of the following:
-
From the catalog: Navigate to the report in the catalog and then click Job History
-
From the report viewer, click Actions and then click Job History
Figure 6-1 shows the Report Job History page.
Use the Report Job History page to:
-
View the status and details of running and completed report jobs
-
Cancel a running job
-
Monitor a running job
-
View job submission details
-
Download or view the XML data produced from the report (if you selected Save Data for the report)
-
Download or view the report document (if you selected Save output)
-
Republish the report data using other formats or templates (if you selected Save Data for the report)
-
Delete report jobs from history
6.2 Viewing Job History for a Specific Report
If you navigated to the Report Job History page from the context of a specific report, then the jobs for that report are automatically displayed in the table with the following default filters applied:
-
Report Path - equals the path to the report from which you launched the Report Jobs History page
-
Start Processing - equals to or later than one week ago.
-
Owner - equals your user ID
-
Scope - equals All Histories (Possible values for scope are: Public and Private job histories)
-
Status - equals All (Possible values for status are: Success, Failed, Running, Has output errors, Canceled, Cancelling, Has delivery errors, and Skipped)
Use the following procedure to further filter the results.
6.3 Searching for Report Job History
To search for report job history:
-
Enter values for the Filter criteria to search for a specific job history or group of completed report jobs. You can filter the results based on the following:
-
Report Job Name - the name assigned to the job when it was submitted.
-
Report Path - the path to the report. If the report resides under Shared Folders, do not include "Shared Folders" in the path. If the report resides under "My Folders," the first node is "~" plus your user name. For example, if you are logged in as Administrator and the report resides under "My Folders/Operational Reports", enter "~Administrator/Operational Reports".
-
Schedule Context - reserved for future use.
-
Start Processing - the date and time at or after which the request started processing.
-
End Processing - the date and time at or before which the request ended processing.
-
Status - can equal one of the following statuses:
-
Success - the job completed without errors
-
Failed - the job failed
-
Running - the job is currently running
-
Has output errors - the job completed, but with errors
-
Cancelled - the job was cancelled
-
Cancelling - the job is in the process of being cancelled
-
Has delivery errors - the job cannot be delivered
-
Skipped - the job was skipped
For more information on error statuses, see Section 6.10, "Getting Error and Warning Information for Reports."
-
-
Owner - the user ID of the user who submitted the job.
-
Scope - Public or Private.
-
-
Click Search. The jobs that meet the filter criteria are displayed in the Report Job Histories table.
The table initially displays 33 matching records. This number is displayed in the upper right corner of the table. Move the vertical scroll bar down to the lowest point to fetch 33 more records. The number displayed in the upper right corner updates to inform you of the number of records that have been fetched so far. You can continue fetching more records to the table in increments of 33 by moving the scroll bar down.
You can sort the table by a particular column by clicking the column heading and selecting the up arrow or down arrow for ascending or descending.
6.4 Viewing Details of a Job History
To view details of a job history:
-
Click the Report Job Name to view a detail page for the job, as shown in Figure 6-2.
-
To view delivery information for each output, click the expand icon next to the output name, as shown in Figure 6-3.
-
Click Return to return to the Report Job History page.
6.5 Downloading Data from a Report Job
For the data to be available, the Save Data for Republishing option must be enabled when the job is created. For information on setting this option, see Section 4.3, "Setting Output Options."
To download data from a report job:
-
Click the Report Job Name to view the detail page for the job.
-
From the Output & Delivery region, click the XML Data download button.
-
When prompted, select the location to save the file.
6.6 Republishing a Report from History
For the data to be available, the Save Data for Republishing option must be enabled when the job is created. For information on setting this option, see Section 4.3, "Setting Output Options."
To republish a report from history:
-
Click the Report Job Name to view the detail page for the job.
-
From the Output & Delivery region, click Republish. This launches the Report Viewer.
-
From the Report Viewer you can now apply a new layout, choose a different output type or export the report. Because you are using data the retrieved from the previous report run, any parameters are not updatable.
-
To return to the Report Job History page, click the Actions menu and select Return.
6.7 Sending an Output to a New Destination
For the output to be available from the history table, the Save Output option must be enabled when the job is created. For more information on setting this option, see Section 4.3, "Setting Output Options."
Note:
The send functionality does not create any history nor does it save the delivery status. It simply sends the output to the destination selected.
To send an output to a new destination:
-
Click the Report Job Name to view the detail page for the job.
-
From the Output & Delivery region, locate the output that you want to send to a new destination and click Send. This launches the Send dialog, as shown in Figure 6-4.
-
Select the delivery type and click Add Destination. Enter the appropriate fields for your delivery type.
-
When finished adding destinations, click Submit.
6.8 Monitoring Running Jobs
While a job is in running status, you can monitor the stages of the report processing,
To view the status, rest your cursor over the Running status indicator in the results table. The status displays with the instance ID of the cluster instance handling the processing. The status is shown in Figure 6-5.
Note that the status does not automatically update while you are viewing the page. To check for updates to the status, refresh the page.
Table 6-1 lists the processing stages of a job.
Table 6-1 Processing Stages of Jobs
| Processing Stage | Substages |
|---|---|
|
Job Processor |
Sending to Job Queue In job queue In job processor Job processor completed Job processor caused exception |
|
Data Fetching |
Fetching XML Data XML Data Fetched Before calling data model pre-trigger After calling data model pre-trigger Before calling data model post-trigger After calling data model post-trigger |
|
Fetching Bursting Control File (for bursting jobs only) |
Fetching bursting control XML Bursting control xml fetched |
|
Data Processor |
In data processor Parsing control file (applies only to bursting jobs) Control file parsed (applies only to bursting jobs) Cutting data based on split key (applies only to bursting jobs) Data cutting completed (applies only to bursting jobs) Total sub-jobs (applies only to bursting jobs) Data processor completed |
|
Report Processor Once the job reaches this stage, outputs can be viewed as they are completed by clicking the Report Job Name. |
In report processor Rendering report document Report document rendering completed Report processor completed Error rendering report document |
|
Delivery Processor The value of <delivery> can be e-mail, fax, File, FTP, Print, or WebDAV, depending on the destinations selected for the report. |
In <delivery> processor Delivering to <delivery> processor Document delivered to <delivery> server <Delivery> processor completed |
6.9 Canceling a Running Job
To cancel a running job:
-
Click anywhere within the table row for the report job to select it (except the job name link). You can select multiple jobs by pressing Ctrl + Shift and then clicking the additional rows. Deselect a row by clicking it again. Note that a job must be in Running status to cancel it.
-
Click the Cancel running jobs icon at the top of the table, as shown in Figure 6-6.
-
Click OK on the confirmation dialog.
6.10 Getting Error and Warning Information for Reports
If a report job fails or completes with warnings, you can view the message by resting the cursor over the error or warning status indicator in the results table. A sample message is shown in Figure 6-7.
For more complete diagnostic information on errors or warnings, you can view the diagnostic log files for the job in Oracle Fusion Middleware Control.
For details, see "Viewing Log Messages" in Oracle Fusion Middleware Administrator's Guide for Oracle Business Intelligence Publisher.
6.11 Deleting a Job History
To delete a job history:
-
Click anywhere within the table row for the report job to select it. You can select multiple rows.
-
Click the delete icon at the top of the table.
-
Click OK on the confirmation dialog.
6.12 Refreshing the Report Job History Page
To refresh the report job history page:
-
To refresh the Report Job History page, click the Refresh button at the top of the page, as shown in Figure 6-8.
