Obiee 11.1.1.7.1 download issue with excel 2007:Unable to download..contact administrator

In 11.1.1.7.0, when attempting to export an analysis to Excel 2007 nothing happens. The browser works for a few seconds and then stops without an Excel file being generated. In 11.1.1.7.1 the following message is encountered:
Error: "There was an error processing your download. Please check with your administrator."  
Steps to fix the issue:

Step1)

Modify config.xml:

1. Open the 'config.xml' file: <INSTANCE_HOME>\config\OracleBIJavaHostComponent\coreapplication_obijh1\config.xml

2. Search for this section:

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

3. Replace 8192 with 0. 

<XMLP>
  <InputStreamLimitInKB>0</InputStreamLimitInKB>
</XMLP>

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.

Step2) 

Modify xdo.cfg

1. Open the 'config.xml' <INSTANCE_HOME>\config\OracleBIJavaHostComponent\coreapplication_obijh1\xdo.cfg

2. In the xdo.cfg file, change the setting for 'xlsx-keep-values-in-same-column' to True. 

Note: If the entry does not exist, then you can add it in the following format: 

<property name="xlsx-keep-values-in-same-column">true</property>
add this between the <properties>  and </properties> tags

Step3) 

Modify opmn.xml

1.Open the 'config.xml' file: <INSTANCE_HOME>\config\OPMN\opmn\config.xml

2. Change the heap size to 4096M 

search for data id="start-args" value="-server -Xmx1024M 

and update to data id="start-args" value="-server -Xmx4096M 

Save the changes and Restart all OPMN services.

Thanks,

Naveen