Skip Headers
Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Publisher
11g Release 1 (11.1.1)

Part Number E22257-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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:

To access this page from the context of a specific report perform one of the following:

Figure 6-1 shows the Report Job History page.

Figure 6-1 Report Job History Page

Report job history page

Use the Report Job History page to:

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:

Use the following procedure to further filter the results.

6.3 Searching for Report Job History

To search for report job history:

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

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

  1. Click the Report Job Name to view a detail page for the job, as shown in Figure 6-2.

    Figure 6-2 Job Detail Page

    Job Details page
  2. To view delivery information for each output, click the expand icon next to the output name, as shown in Figure 6-3.

    Figure 6-3 Delivery Information

    Delivery information
  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:

  1. Click the Report Job Name to view the detail page for the job.

  2. From the Output & Delivery region, click the XML Data download button.

  3. 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:

  1. Click the Report Job Name to view the detail page for the job.

  2. From the Output & Delivery region, click Republish. This launches the Report Viewer.

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

  4. 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:

  1. Click the Report Job Name to view the detail page for the job.

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

    Figure 6-4 Send Dialog

    Send dialog
  3. Select the delivery type and click Add Destination. Enter the appropriate fields for your delivery type.

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

Figure 6-5 Job Status

Job status

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:

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

  2. Click the Cancel running jobs icon at the top of the table, as shown in Figure 6-6.

    Figure 6-6 Canceling Running Jobs

    Canceling running jobs
  3. 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.

Figure 6-7 Sample Error Message

Sample error messages

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:

  1. Click anywhere within the table row for the report job to select it. You can select multiple rows.

  2. Click the delete icon at the top of the table.

  3. Click OK on the confirmation dialog.

6.12 Refreshing the Report Job History Page

To refresh the report job history page:

  1. To refresh the Report Job History page, click the Refresh button at the top of the page, as shown in Figure 6-8.

    Figure 6-8 Refreshing Report Job History

    Refreshing report job history