6 Viewing and Managing Report History

This topic describes the 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.

Topics:

Viewing Report Job History and Saved Output

The Report Job History page displays information about running and completed report jobs.

You can access the Report Job History page and then search for the report job history. You can also access this page from the context of a specific report. Use one of the following to select Report Job History.

Browse/Manage in the Home page.
Open on the global header.

Use the Report Job History page to:

View the status and details of running and completed report jobs.
Identify the critical 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.

Viewing Job History for a Specific Report

If you navigate to the Report Job History page from the context of a specific report, then the jobs for that report are automatically displayed with the default filters applied.

To view the job history of a specific report:

Perform one of the following:
- From the Catalog, navigate to the report, and click Job History.
- From the Report Viewer, navigate to the report, and click Job History.
In the Report Job History page, specify the filters if required and click Search.
Following are the default filters:
- 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. Includes Private Job Histories and Public Job Histories.
- Status - Equals All. Includes all the possible values for status — Success, Failed, Running, Has output errors, Canceled, Cancelling, Has delivery errors, Skipped, and Waiting.

Searching for Report Job History

Specify the filter criteria for searching a 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:

Filter	Description
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 (~) and 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 have 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. Canceled - The job was cancelled. Cancelling - The job is in the process of being canceled. Has delivery errors - The job cannot be delivered. Skipped - The job was skipped. Waiting - The job is queued.
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.

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.

Viewing Details of a Job History

Use the Report Job History page to view the details of a job history.

To view details of a job history:

In the Report Job History page, click the Report Job Name to view a detail page for the job.
To view delivery information for each output, click the expand icon next to the output name.
Click Return to return to the Report Job History page.

Downloading Data from a Report Job

You can view the details of a report job, download the XML data, and save the file to your preferred location.

You must enable the Save Data for Republishing option when you create the job to make the data available for republishing. See Setting Output Options.

To download XML data from a report job:

In the Report Job History page, click the report job name in the Report Job Histories table to view the job detail page.
In the Output & Delivery section, click the XML Data download button.
When prompted, select the location to save the file.

Republishing a Report from History

You can republish a report from history.

You must enable the Save Data for Republishing option when you create the job to make the data available for republishing. See Setting Output Options.

To republish a report from history:

In the Report Job History page, click the Report Job Name to view the job detail page.
From the Output & Delivery section, 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, you cannot update the parameters.
To return to the Report Job History page, click the Actions menu and select Return.

Sending an Output to a New Destination

You can send the output of a report to a new destination.

You must enable the Save Output option when you create the job to make the output available in the history table. See 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:

In the Report Job History page, click the Report Job Name to view the job detail page.
In the Output & Delivery section, locate the output that you want to send to a new destination, and click Send.
In the Send dialog, do the following:
1. Select the delivery type
2. Click Add Destination
3. Enter the appropriate fields for your delivery type.
After you finish adding the destinations, click Submit.

Monitoring Running Jobs

You can monitor the stages of the report processing when a job is in running status.

To monitor a running job:

In the Report Job History page, hover over the Running status indicator in the Report Job Histories table.
The status displays with the instance ID of the cluster instance handling the processing.
To check the latest status, refresh the page. The status does not automatically update while you are viewing the page. See Processing Stages of Jobs.

Processing Stages of Jobs

This topic lists the processing stages of a job.

Processing Stage Substages

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 valid values for `<delivery>` are email, fax, File, FTP, Print, WebDAV, or Document Cloud Services, depending on the destinations selected for the report.	In `<delivery>` processor Delivering to `<delivery>` processor Document delivered to `<delivery>` server `<Delivery>` processor completed

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 valid values for <delivery> are email, fax, File, FTP, Print, WebDAV, or Document Cloud Services, depending on the destinations selected for the report.

In <delivery> processor

Delivering to <delivery> processor

Document delivered to <delivery> server

<Delivery> processor completed

Canceling a Running Job

You can cancel a running job.

To cancel a running job:

In the Report Job History page, 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 clicking the additional rows. Deselect a row by clicking it again. You can only cancel a job that has the status, Running.
Click the Cancel Running Jobs icon at the top of the table,
The image shows the Report Job Histories page with a cursor pointing to the cancel icon.

Description of the illustration GUID-C6D6A15B-E7E9-4BAD-B793-DF848664FB6C-default.gif
Click OK in the confirmation message.

Getting Error and Warning Information for Reports

If a report job fails or completes with warnings, you can view the error and warning information.

To get error and warning information for a report:

In the Report Job History page, hover over the error or warning status indicator in the results table

The job details page will also have the error and warning associated with that job. See Viewing Log Messages in Administrator's Guide for Oracle Business Intelligence Publisher.

For more complete diagnostic information on errors or warnings, you can view the diagnostic log files for the job in Oracle Fusion Middleware Control.

Deleting a Job History

You can delete a job history.

To delete a job history:

In the Report Job History page, click anywhere within the table row for the report job to select it (except the job name link).

You can select multiple rows.
Click the Delete icon at the top of the table.
Click OK on the Confirmation dialog.