10 Responses to This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold enforced by the administrator

  1. Nancy says:

    Thanks for all the great stuff you post- it’s a big help. A question: we want to run a Powershell script to flag every list view where the list view 8-column threshold has been exceeded. How can we query for such a result set?

    • MJ says:

      If you have a large site collection with many sites then the below could be rather time consuming but it would work and I don’t know of a more effective way off the top of my head.

      You could very easily write a recursive method in C# to go through every list of every web in a site collection and count the number of managed metadata fields (or check for lists that error). You could then report the lists/libraries that you discover.

      If you specifically wanted to run this via PowerShell then you could run your C# code using an approach like this:

      It should all be very straightforward to do. Let me know if you struggle with it. :)

  2. Pingback: Ansicht kann nicht angezeigt werden (SharePoint 2010) | Dieters Blog

  3. Shukkoor says:

    Very useful information , Thanks a Lot

  4. jr says:

    Thanks. Just upgraded content from SP2007 to SP2010 and bumped into this ‘problem’….

  5. Kam says:

    Just to add here, one of my user is getting the same error but I have checked in the setting List View Lookup Threshold property is set to 5000.

    Can someone advise.

  6. Vijay Chavan says:

    very nice…. successfully worked!

  7. Larry W. Virden says:

    So, what I found in our case is that the user’s library was one that was part of a InfoPath based workflow ticket system. Each time the infopath was updated, a new content type was created and a new status column as well.

    We found that if we modified the view in question, that was sufficient – no change was needed in central admin.

    However – remember that making that change in central admin is going to slow down the system as the number of lookup columns and status columns increase.

  8. Qasim says:

    Thanks alot

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s