My Oracle Support Banner

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:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.


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

The following error message is received when reproducing the issue:

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

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.




To view full details, sign in with your My Oracle Support account.

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

In this Document

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