Business Intelligence Publisher 12c Scheduled Reports Hang At A Status Of Active, And /logs/bipublisher/bipublisher.log Shows Either Sql- Or Ora- Errors During The Report Processing
(Doc ID 2238710.1)
Last updated on DECEMBER 05, 2021
Applies to:BI Publisher (formerly XML Publisher) - Version 12c and later
Information in this document applies to any platform.
Business Intelligence Publisher Enterprise 12c, OBIEE Scheduler related issues
When using the BI publisher web service to schedule a report the scheduled reports hang at a status of 'Active', and never complete or progress to an error status.
After upgrade BI publisher to Oracle BI Publisher 220.127.116.11.0, users report experiencing severe issues with the error handling for BI Publisher reports.
Review of the logfile at /user_projects/domains/bi/servers/bi_server1/logs/bipublisher/bipublisher.log shows an SQL or ORA error has occurred, but the report is still shows as actively running.
The scheduled tasks stay at a status of 'Active', and no error message is shown to the users (or in the report job history).
Because the status stays 'active', the application also keeps polling the status while waiting for the report to finish.
If an error occurs, the status of the report execution should be set to failed and the actual error message is shown.
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