Clarity: Scheduled BO report remains in processing status when report schedule output format is set to Excel.

Document ID : KB000051554
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When the schedule format of a Business Objects report is set to Microsoft Excel (Data Only) and is scheduled to run via Clarity, it remains in a "processing" status. The report is successfully generated in Business Objects and can be viewed via Infoview and CMC. However, as it is not yet completed in Clarity, it is not accessible via the Report library. The same report can be successfully generated when the report is run in immediate mode.

This will occur for any report format other than Webi or Crystal reports.

Steps to Reproduce:

  1. Log in BO Central Management Console.
  2. Go to Home > Folder > CA Reports > CA Clarity.
  3. Select any report e.g. Key Tasks and Milestone Status.
  4. Select Schedule tab.
  5. Select Format sub tab.
  6. Change the format to Microsoft Excel (Data Only).
  7. Set options as appropriate and update:
    • Change Column width based on objects in the: to Details.
    • Check Export object formatting, Export Images, Maintain Column alignment, Export page header and page footer.
  8. In Clarity go to Reports and Jobs > Reports > Available reports
  9. Select the report amended in Business Objects e.g. Key Tasks and Milestone Status
  10. Schedule the report and monitor

Expected Results: The Key Tasks and Milestone Status reports gets completed and is accessible via the Report Library.

Actual Results: The Key Tasks and Milestone Status reports remains in processing status indefinitely.

Solution:

WORKAROUND:
Run the report in immediate mode.
Or
Leave the report format as Crystal Report (default mode) in Business Objects, schedule the report and then when accessing the report use the save to excel feature.

STATUS/RESOLUTION:
Resolved in Clarity 13.3

Keywords: CLARITYKB, CLRT-56610, clarity13resolved, clarity133resolved.