Select Page

Art of BI: Export to Excel Error in OBI12c

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.

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

Scripting Out the Logins, Server Role Assignments, and Server Permissions

Imagine there are over one hundred logins in the source server and you need to migrate them all over to the destination server. Wouldn’t it be awesome if we could automate the process by generating the scripts for the required tasks?

JP Chen | October 1, 2015

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS