Art of BI: Export to Excel Error in OBI12c
Author: Bill Anderson | | November 30, 2017
In Oracle BI 12c version 12.2.1.2.0 you may notice an error when trying to export to Excel using the Export Link at the bottom of a report on a dashboard.
First you see the following popup depending on the size of the report you Export to Excel:
You receive the below error:
Look at the Oracle BI Java Host (OBIJH) config.xml file located:
/ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIJH/config.xml
and see if you see the below:
Change the snippet of code to the below:
Bounce the OBIJH1 service and try to run the export again and it should be successful.
Related Posts
How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified
The “ORA-12154: TNS Oracle error message is very common for database administrators. Learn how to diagnose & resolve this common issue here today.
How to Recover a Table from an Oracle 12c RMAN Backup
Our database experts explain how to recover and restore a table from an Oracle 12c RMAN Backup with this step-by-step blog. Read more.
Data Types: The Importance of Choosing the Correct Data Type
Most DBAs have struggled with the pros and cons of choosing one data type over another. This blog post discusses different situations.