How to Fix OBIEE 11.1.1.7.1 EXCEL 2007+ Download Error

OBIEE 11.1.1.7.1 EXCEL 2007 DOWNLOAD ERROR

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

This error is observed when a report with larger number or rows is downloaded using Excel 2007+ in OBIEE 11.1.1.7.1

The symptoms are that the system doesnot respond for some time and after a while a pop-up saying
''There was an error processing your download. Please check with your administrator' comes up.

Steps to Fix

Step-1: 

Make sure that the following paramerters are given in the instance config file.

<Views>
<Pivot>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DefaultRowsDisplayedInDownload>650000</DefaultRowsDisplayedInDownload>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DisableAutoPreview>false</DisableAutoPreview>
<MaxVisibleColumns>50000</MaxVisibleColumns>
<MaxVisiblePages>10000</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxCells>400000</MaxCells>
<MaxVisibleSections>55000</MaxVisibleSections>
</Pivot>
<Table>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DefaultRowsDisplayedInDownload>650000</DefaultRowsDisplayedInDownload>
<MaxVisiblePages>10000</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxCells>400000</MaxCells>
<MaxVisibleSections>55000</MaxVisibleSections>
</Table>
<Charts>
<MaxVisibleColumns>50000</MaxVisibleColumns>
<MaxVisiblePages>10000</MaxVisiblePages>
<MaxVisibleRows>100000</MaxVisibleRows>
<MaxVisibleSections>55000</MaxVisibleSections>
<JavaHostReadLimitInKB>10240</JavaHostReadLimitInKB>
</Charts>
<Cube>
<CubeMaxRecords>10000000</CubeMaxRecords>
<CubeMaxPopulatedCells>100000000</CubeMaxPopulatedCells>
</Cube>
</Views>

Step 2:

Open <INSTANCE_HOME>\config\OracleBIJavaHostComponent\coreapplication_obijh1\config.xml, search for:

<XMLP>
<InputStreamLimitInKB>8192</InputStreamLimitInKB>
</XMLP>

* Replace 8192 with 0 and restart the OPMN processes.

0 means that this limit is deactivated. If this solves the issue and you would like to limit the maximum input size (in kilobytes) for requests that are sent to the JavaHost service, then gradually increase the parameter's value until you can export correctly.

Note: It is HIGHLY recommended that you do not leave it unlimited except for testing purposes as it acts as a "governor" for machine resources.

Additionally be carefull to change the InputStreamLimitInKB in the XMLP tag, as there is another one under the DVT tag

Step 3:

1. Take a back-up copy of opmn.xml located in the directory:

<INSTANCE_HOME>/config/OPMN/opmn

·         Open opmn.xml

·         Find the OracleBIJavaHostComponent parameter:

<process-type id="OracleBIJavaHostComponent" module-id="CUSTOM">

<module-data>

<category id="start-parameters">

<data id="start-executable" value="$ORACLE_HOME/jdk/bin/java"/>

<data id="start-args" value="-server -Xmx1024M -Djava.security.manager=default -DXDO_FONT_DIR=$ORACLE_HOME/common/fonts -Djava.security.policy=$ORACLE_INSTANCE/config/$COMPONENT_TYPE/$COMPONENT_NAME/java.policy

-Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration –

·         Change the heap size to 4096M.

·         Save the changes.

Then re-start the OBIEE components in Enterprise Manager.

This should fix the export issue for larger reports,

Till Next time..

SHARE SHARE SHARE

About test