Business Intelligence Publisher 11.1.1.7 Report Fails From BI Analytics Dashboard With Error 'oracle.xdo.XDOException: oracle.xdo.servlet.data.DataException: Invalid parameters requested.[[at oracle.xdo.online.DataCache.getDataFile'

(Doc ID 2231399.1)

Last updated on JULY 16, 2018

Applies to:

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

Symptoms

Business Intelligence Publisher 11.1.1.7 Enterprise Edition , Administration and System Configuration issues

 

 

 

 

 

 

 

While running a BI Publisher Enterprise Edition (OBIEE) report the following error occurs:

[bi_server1] [ERROR] [] [oracle.xdo] [tid: 00] [userId: <anonymous>] [ecid: 6000-0000000000003fb6,0] [APP: bipublisher#11.1.1] Illegal parameter value: STAGE=All
[bi_server1] [WARNING] [] [oracle.xdo] [tid: 00] [userId: <anonymous>] [ecid: 6000-0000000000003fb6,0] [APP: bipublisher#11.1.1]

oracle.xdo.XDOException: oracle.xdo.servlet.data.DataException: Invalid parameters requested.[[at oracle.xdo.online.DataCache.getDataFile(DataCache.java:430)

Some additional observations:

1. the report runs find via the BI Publisher URL.
2. The report runs fine under Bi Analytics- Catalog
3. The report errors under the BI Analytics - Dashboard - with error message "invalid parameters requested"" with STAGE and P_SPEC parameters set to 'All' Values. If the parameters are set to a specific value in the table and parameter :SPECIES by P_SPEC is replaced within the data model query a 'no data found' error is received.

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