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 APRIL 23, 2021
Applies to:
BI Publisher (formerly XML Publisher) - Version 11.1.1.7.x and laterInformation 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
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
Symptoms |
Cause |
Solution |
References |