Analytics / BI Publisher Bursting Report Hanging In Running Status Indefinately And Returning Following Warning In The Bipublisher.log: "Data processor failed::[INSTANCE_JOB_ID=####]::NO_DATA_TO_PROCESS"

(Doc ID 2346765.1)

Last updated on JANUARY 10, 2018

Applies to:

Primavera Analytics Cloud Service - Version 17.11.0.0 and later
Primavera Analytics - Version 17.11.0.0 and later
Primavera Unifier - Version 17.11.0.0 and later
Primavera Unifier Cloud Service - Version 17.11.0.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 17.11.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
When attempting to run a scheduled job for a bursting report, the job stays in a Running status indefinitely. 

Note:

EXPECTED BEHAVIOR
-----------------------
When attempting to run a scheduled job for a bursting report, for the job execution to move from a running to a completed status.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Create a report job to schedule an existing bursting report.
    1. Click New -> Report Job
    2. Schedule report Job window opens up .
    3. Select a bursting report on General tab
    4. Check that the output record is added with the format same as mentioned in the bursting query.
    5. In Schedule Tab select the frequency / Start and End date
    6. Check Use Trigger and select Use Data Model specified in the report .
    7. Select the trigger name form the drop down. “Status” in this case
    8. In Notification Tab check the Notify By checkbox and mention the email Address .
    9. Click Submit
    10. Give the Report Job a name
    11. Click Submit
  2. Go to the report location then click More > History
  3. Note that the report is showing indefinitely in a running status.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms