8 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:
      http://blogs.technet.com/b/stefan_gossner/archive/2010/05/07/using-csharp-c-code-in-powershell-scripts.aspx

      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!

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