OBIEE 12c: Error While Downloading To Excel – There was an error processing your download:

Error:

We are getting error while downloading to EXCEL in OBIEE12c version:

“There was an error processing your download.
Please check with your administrator.”

Solution:

Modifying the JavaHost parameters resolves the issue.

11g: <INSTANCE_HOME>/config/OracleBIJavaHostComponent/coreapplication_obijh1/config.xml
12c: <DOMAIN_HOME>/BI/config/fmwconfig/biconfig/OBIJH/config.xml

Step 1: Backup the Config.xml file in Domains/BI/config/fmwconfig/biconfig/OBIJH.

Step 2: Increase the InputStreamLimitInKB in the Config.xml file.

<XMLP>
<InputStreamLimitInKB>2048000</InputStreamLimitInKB>
<ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing>
</XMLP>

Step 3: Stop & restart the OBIEE services and re-test the issue.