if you click on click
to '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 coming "The query cannot be completed because the number of lookup columns
it contains exceeds the lookup column threshold enforced by the
administrator." But
while using SharePoint user account including site collection owners this
" error occurs.
Resolution:
Each new lookup column
requires an additional SQL join. As the number of joins goes up it will
have a 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.
· In the Resource Throttling window, scroll down
to List View Lookup Threshold and change the value to the number that suits
your needs.
· Click OK.
Issue will get Resolve. Please Comment if you need any
Help!!!!
