OBIEE11g : XLS filesize problem Stream Error

OBIEE11g : XLS filesize problem Stream Error

Oracle solution to large file sizes being produced from OBIEE. Didnt work for me ... but who knows might work for you..


When you try to download as xlsx gives a input stream error THE FIX IS POINT 2 Below.

Solution:

Oracle solution for now will be fixed in 11.1.1.7.0 i think.


1) Go to the following path to edit controlmessages.xml file
/<OBIEE_HOME>/Oracle_BI1/bifoundation/web/msgdb/messages Fix: do the following changes

Change export "format=mht" to "format=excel"
Note: Replace the text "mht" to "excel" . Don’t forget to take the back up for the controlmessages.xml file before editing.

Backup all files.
　
This is for the stream ERROR


2) Go to the following path to edit config.xml file
<MW_HOME>/instances/instance1/config/OracleBIJavaHostComponent/coreapplication_obijh1
Fix: do the following changes
Before:
<XMLP>
<InputStreamLimitInKB>8192</InputStreamLimitInKB>
<ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing>
</XMLP>
<DVT>
<InputStreamLimitInKB>8192</InputStreamLimitInKB>
</DVT>
After:
<XMLP>
<InputStreamLimitInKB>0</InputStreamLimitInKB>
<ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing>
</XMLP>
<DVT>
<InputStreamLimitInKB>0</InputStreamLimitInKB>
</DVT>

Note: 0 represents unlimited.

Bounce all services just for good measure.