E-BIP/XMLP: BI Publisher Report Using Bursting Run Through Query Report Scheduler Goes To "No Success" When Generating Empty Data (Doc ID 2474380.1)

Last updated on JULY 07, 2020

Applies to:

Symptoms

Problem statement
-------------------------
While running a BI Publisher process that uses bursting to output type of Email with no output created, the process goes to "No Success".

Error
----------
The following error message is received when reproducing the issue:

“Peoplecode Exit(1) Abort invoked by Application at PSXPQRYRPT.MAIN.ExecRpt. (108,543)”

Steps
-----------
In order to replicate the issue, follow the below steps:

1. Login into PIA.
2. Navigate to Reporting Tools > BI Publisher > Report Definition.
3. Edit a publisher report based on a query data source with bursting.
This issue only occurs when in the report definition “Bursting” is used.
4. Schedule a BI publisher report with destination e-mail for this report (make sure the query does not produce any output).
Navigation: Reporting tools > BI Publisher > Query Report Scheduler
5. Check the output in the Process Monitor.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.