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 laterInformation in this document applies to any platform.
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
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
Symptoms |
Changes |
Cause |
Solution |
References |