OBIEE 12c: Why "export to csv" exports lesser number of rows than what is configured in ResultRowLim

Arindam Saha

In instanceconfig.xml file I have set :

<ODBC>

            <ResultRowLimit>500000</ResultRowLimit>

</ODBC>

Also, <DefaultRowsDisplayedInDownloadCSV>500000</DefaultRowsDisplayedInDownloadCSV> is set as my requirement is to have 500k records in the exported csv file.

But this doesn't work. I can download the CSV successfully, but it has the records upto 499801 rows and then it shows error:

<div>

<script type="text/javascript" src="res/v-DBoTHFvj6ls/b_mozilla/browserdom.js"></script>

<script type="text/javascript" src="res/v-DBoTHFvj6ls/b_mozilla/common.js"></script><div class="ErrorMessage">Exceeded configured maximum number of allowed input records.</div><div style="margin-top:2pt" onclick="SAWMoreInfo(event); return false;"><img class="ErrorExpanderImg" border="0" alt="" src="res/v-DBoTHFvj6ls/sk_blafp/common/errorplus.gif" align="absmiddle">  <a href="javascript:void(null)" class="ErrorExpander">Error Details</a><div style="margin-left:15px;display:none" compresssrc="res/v-DBoTHFvj6ls/sk_blafp/common/errorminus.gif">

<div class="ErrorCodes">Error Codes: <span dir="ltr">EKMT3FK5</span></div>Location: saw.httpserver.processrequest

</div></div></div>

But if I modify the instanceconfig.xml file as follows:

<ODBC>

            <ResultRowLimit>600000</ResultRowLimit>

</ODBC>

I can now export to csv successfully with 500k records.

Can someone please explain why is this behavior OR how are they connected ?

       

Charles M

Hi -

Take a look at these notes:

OBIEE 11g: Error: "Exceeded configured maximum number of allowed input records. Error Codes: EKMT3FK5:OI2DL65" when Exporting or Opening a Large Report (Doc ID 1487839.1)

OBIEE11G: Export to CSV Displays Less Rows than Max Rows Limit Set in the OBI Repository (rpd) and nQSError: 60008 error (Doc ID 1930870.1)

Let me know if they help.

Regards,

Charles