We have an OBIEE version of 12.2.1.4 in linux server where most of the reports fetch data more than 65000. We have raised an Oracle SR where they have proposed the following solution :
<XMLP>
<InputStreamLimitInKB>0</InputStreamLimitInKB>
<ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing>
</XMLP>
also in config.xml I did the following change:
<MessageProcessor>
<SocketTimeout>5000</SocketTimeout>
</MessageProcessor>
In Instanceconfig.xml :
<ODBC>
<ResultRowLimit>65000</ResultRowLimit>
</ODBC>
Again in Oracle Doc the following solution is suggested :
<XMLP>
<InputStreamLimitInKB>0</InputStreamLimitInKB>
<ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing>
</XMLP>
To:
<XMLP>
<InputStreamLimitInKB>2048</InputStreamLimitInKB>
<ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing>
</XMLP>
Save and exit the file.
Start the OBIEE, and test the same report once more.
One should be able to export more than 65000 rows.
None of the solutions has worked for me. Please suggest what can be done if data count is more than 65000