How do I solve – This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold enforced by the administrator?

Written by Cornelius J. van Dyk on . Posted in How Do I...

If you’ve ever migrated site collections from one farm to another, or upgraded from a 2007 farm to a 2010 farm, you may encounter this error the following error:

“This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator.”

image

 

This is caused by Resource Throttling that was introduced in SharePoint 2010.  The settings can easily be adjusted to cater to your specific environment and are set for each web application.  To adjust the limits, follow these steps:

  • Open Central Administration
  • Click “Application Management” in the left navigation menu.
  • Click “Manage Web Applications” on the Application Management page.
  • A list of all your web applications in the target farm will be displayed.  Select the target web application by clicking the white space between the Title and the URL.
  • The Ribbon should now light up.  Click on “General Settings”.  Do NOT click the gears icon above General Settings as it will take you to the General Settings page instead of the Resource Throttling page.
  • A dropdown menu will activate.  On this menu, click “Resource Throttling”.

 

image

 

  • On the Resource Throttling page, scroll down to the List View Lookup Threshold section.  By default, this value is set to 8.
  • Change the value to the desired number.
  • Scroll down and click “OK”.

 

image

 

Now when you navigate back to the list view in question, provided the lookups is less than the number you just set, the view should render normally.

 

image



Cheers
C




image

Tags: , ,

Trackback from your site.

Cornelius J. van Dyk

Born and raised in South Africa during the 70's I got my start in computers when a game on my Sinclair ZX Spectrum crashed, revealing it's BASIC source code. The ZX had a whopping 48K of memory which was considered to be a lot in the Commodore Vic20 era, but more importantly, it had BASIC built into the soft touch keyboard. Teaching myself to program, I coded my first commercial program at age 15.

After graduating high school at 17, I joined the South African Air Force, graduating the Academy and becoming a Pilot with the rank of First Lieutenant by age 20. After serving my country for six years, I made my way back into computer software.

Continuing my education, I graduated Suma Cum Laude from the Computer Training Institute before joining First National Bank where my work won the Smithsonian Award for Technological Innovation in the field of Banking and Insurance. Soon I met Will Coleman from Amdahl SA, who introduced me to a little known programming language named Huron/ObjectStar. As fate would have it, this unknown language and Y2K brought me to the USA in 1998.

I got involved with SharePoint after playing around with the Beta for SharePoint Portal Server 2003. Leaving my career at Rexnord to become a consultant in 2004, I was first awarded the Microsoft Most Valuable Professional Award for SharePoint in 2005, becoming only the 9th MVP for WSS at the time. I fulfilled a life long dream by pledging allegiance to the Flag as a US citizen in 2006. I met the love of my life and became a private consultant in 2008. I was honored to receive my ninth MVP award for SharePoint Server in 2013.

Leave a comment

You must be logged in to post a comment.