How to Fix OBIEE 11.1.1.7.1 EXCEL 2007+ Download Error | The Big Data - Business Intelligence by Sandeep Venu

Enter key word

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

About Sandeep Venu

    Blogger Comment
    Facebook Comment

4 comments:

Hadar said...

Thanks, It works!!!

Yağmur Dursun said...

Hi,
First thanks for your solution. I applied all steps. But nothing is changed. So I am confused about 3rd step. Do you mean change "Xmx1024M to 4096M" or "Xmx1024M to Xmx4096M"

mariah carey said...

All the points are, be appreciative of I personally try it.I get successful result thanks you done a remarkable work.

Krešimir Futivić said...

Works for me to;

Take look at
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=200744450384651&id=1614449.1&_afrWindowMode=0&_adf.ctrl-state=4vfpl253l_4

Top Links

Upgrading BI Publisher

Add Google Search

OBIEE- LDAP

Change Admin Password

Best Practices

ORACLE 11GR2

Host Files

Customization

OBIEE-SIEBEL

Bug Fixes

Setting Default

OBIEE Installation failed

OBIEE Installation

Oracle Databse

Oracle In Linux

Loopback Adapter

Weblogic Failed

Yum Commands

Weblogic Admin

Linux Static IP

OBIEE LDAP

Admin Paswword

Scaling

Weblogic Starting Error

Localizing BI

Physical Schemas

Multimedia Dashboard

Video in OBIEE

Variables in OBIEE

Ago 30 Days

Email Link

ODI Installation

AGO Function

Sort Pivote table

OBIEE Patch

Reset Sys password

Date Calculation

Add Row in Report

Increase Row limit

OBIEE with Essbase

Reset Weblogic

BIP Login Error

MDS and BI Platform

ORA 28001 Error

ORA 12560 TNS Protocal Error

ORA 12154 TNS Error

OBIEE ON AIX

Pre Requsite

AIX Commands

Commands