How can I avoid ThresholdException while fetching data using REST query

Question

I have a list in SP 2010 from which a Java program fetches data using a REST query.

http://sharepointfarm/sites/testsite/_vti_bin/listdata.svc/OurList?$select=Id,Title

The XML response currently shows the below error, even after using a select query.

<message>
The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.
</message>
<type>Microsoft.SharePoint.SPQueryThrottledException</type>

This article mentions the select parameter does not restrict the ViewFields on the server.

Is there any way out to fetch the data into Java? Can we split the query to avoid the ThresholdException?

We need to fetch all records in the list.

Answer 1

try this.

Via Central Administration: Manage web applications / Select the web application, then from the drop down list 'General Settings' select 'Resource Throttling' / change the value of 'List View Lookup Threshold'

Or via PowerShell:

$wa = Get-SPWebApplication http://YourSharePointSite
$wa.MaxQueryLookupFields = 20
$wa.Update()