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
Last updated on MARCH 10, 2017
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 126.96.36.199.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms