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

Tag: sharepoint , threshold Author: samwu2007 Date: 2012-12-23

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.

Other Answer1

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.

Other Answer2

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%.

You can also read the whitepaper here:

Other Answer3

Please go through this link it will Help you to solve this issue and also provide you some more information if you have large site collection and number of Lists .

Other Answer4

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.