"The report cannot be rendered because of an error" Intermittently Failing But Will Run Successfully When The DM Is Saved (Doc ID 2157723.1)

Last updated on JULY 05, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.2 to 12.2 [Release 12.2]
Information in this document applies to any platform.

Symptoms

In BI Publisher 12.2.1:

1. a. When any report is run online (View Report) the first time it runs fine.

    b. Then going back to the Catalog and selecting to run it again fails with:

The report cannot be rendered because of an error


2. Then IF one goes to Edit the report's Data Model and Save it, it will NOW run again successfully.

3. Additionally, after a successful run, if one does NOT choose a Parameter then it will ALSO run successfully.

4 a. A particular report, 'Actual On Hand vs On Order Report', is being used as an example of the issue.

   b. All reports (they were migrated from 11.1.1.7 instance) are exhibiting the issue.

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