The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator
If you click on 'datasheet view', the query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.
Cause:
By default, the limit is 8 lookups per list for users.
Background:
While using farm admin account the error is not generating "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator." While using SharePoint user account including site collection owners the above error occurs.
Resolution:
Each new lookup column requires an additional SQL join. As the number of joins goes up it will have an effect on performance. By default, the limit is 8 lookups per list. As you have seen this limit does not apply to farm admins. You can change the limit for other users in the Resource Throttling settings of the web application in Central Administration but making changes to the resource limit can impact performance.
· Go to Central admin > Application Management > Manage Web Application.
· In the Web Application list, select the web application you need.
· Then go to General Settings > Resource Throttling.
http://4.bp.blogspot.com/-B1qddt14IU8/UnnMFR6XQ_I/AAAAAAAAAgU/1GVb2VZHheQ/s320/52.bmp
· In the Resource Throttling window, scroll down to List View Lookup Threshold and change the value to the number that suits your needs.
http://1.bp.blogspot.com/-GysTRymjJi0/UnnLkmV3yCI/AAAAAAAAAgE/9bFKXCeimUI/s320/51.bmp
· Click OK.
