Export Issue for OBIEE reports where rows is more than 65000

User_5YLTI

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

Gianni Ceresa

Please remove copy/paste content from MOS documents. You can't post it in a public forum, if you want to post that content you would need to move your thread to

User_5YLTI

I hope I have removed the line properly. Now I have only mentioned what I have done and what's suggested

Gianni Ceresa

The "suggested solution" given by Doc ID 2161550.1 is the issue ...

That piece of information is accessible only to people having a valid support contract.

So simply says you applied the solution of that Doc ID and still it isn't working.