The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold!!!

While doing migration i got this issue with a big list...using lots of lookup columns type..


This is due to SharePoint’s new resource throttling settings for managing large lists. There is an easy fix in Central Administration.


Go to Central Administration and then browse to Application Management > Manage Web Application.  Select the web application you need. 

In General Settings choose Resource Throttling. Set the value in the List View Lookup Threshold textbox to a higher value (equal to or greater than the number of site columns you are using on the list where you saw the error).

Cheers!!!

Suneet