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 ?
