OBIEE 11.1.1.7.1 EXCEL 2007+ Download Error


I was attempted to export to excel 2007 and got a popup 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.

2 comments:

  1. Oracle fusion procurement education empowering present day organizations watch our loose tutorials80+ hours of wonderful motion pictures
    The mission-oriented video become bested tutorials &help

    Thank you for sharing.
    With first-rate regards
    oracle fusion procurement online training
    oracle fusion procurement training

    ReplyDelete
  2. Hi,
    this is very informative post.Thanks for sharing such a wonderful post.
    oracle fusion HCM training.

    ReplyDelete