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 MARCH 10, 2017

Applies to:

BI Publisher (formerly XML Publisher) - Version 12c and later
Information in this document applies to any platform.

Symptoms

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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms