Sharepoint: The view cannot be displayed because the number of lookup and workflow columns it contains exceeds the threshold (8)

Question

I have following problem with my Sharepoint website. (The view cannot be displayed because the number of lookup and workflow columns it contains exceeds the threshold (8) enforced by the administrator) but any solution I have found online points me to change the throttle settings in web applications settings under central administration. My problem is I simply do not have Central Administration > Web Applications etc... The problem is appearing on a document library for me and I have explored very settings options on the site but cannot find anything about trottleing or column threshold. I just have Site Settings > Library settings etc...

How can I increase the column threshold in this case?

I am working on a Sharepoint website and have Workspace and Designer 2010.

Schizomycete

luckily i was showing data using ajax..the workaround i did is - fire two separate ajax calls to get separate 8 columns – Boozer

Answer 1

The information you found is correct. You must access the Central Administration site from the server itself. It sounds like you are not logging into the server, but using SPD and the Sharepoint site from your workstation. If you don't have access to RDP to the server, you must contact someone who has access.

On another note, it's not recommended to increase that threshold.

Schwerin

Answer 2

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.

Westmorland

Answer 3

Use caution when changing this setting:

This does have a very significant impact on SQL performance. In the article below you can see that in this persons tests, using 8 and executing the query there was about 7% CPU utilization on SQL. Moving that to 10 and executing a query that pulls back 10 columns increases the CPU utilization to almost 40%. http://sympmarc.com/2012/07/23/sharepoints-list-view-lookup-threshold-and-why-we-dont-change-it/

You can also read the whitepaper here: http://technet.microsoft.com/en-us/library/ff608068(office.14).aspx

Chelyabinsk