Thursday 16 February 2012

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

SharePoint list doesn’t display the items. Get an error this view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by Administrator

The default lookup threshold is set to 8 in a web application by default. To resolve this,

Navigate to the Central Administration

Click on Application and select the web application

In my case its http://sharepoint.portal

From the ribbon bar, select General Settings > Select Resource Throttling
  
Now set List view Lookup threshold to 20


Note the maximum number you can set is between 1 to 1000

7 comments:

  1. Thanks , I have just been searching for information about this subject for a long time
    and yours is the best I have came upon so far. But, what about the conclusion?
    Are you positive about the supply?
    my web page: foodtv.com

    ReplyDelete
  2. Good afternoon, thanks alot : ) for a seriously useful posting, I would not
    ordinarily attach responses but appreciated your blog post
    therefore felt I would say thanks for your insight / Eloise
    Here is my weblog dating site reviews

    ReplyDelete
  3. Hi there, all is going sound here and ofcourse every one is sharing information,
    that's actually good, keep up writing.
    My web site > how to lose weight naturally and fast

    ReplyDelete
  4. It's hard to find well-informed people about this subject, but you seem like you know what you're talking about!

    Thanks
    Feel free to visit my web blog :: fircdel.com

    ReplyDelete
  5. 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

    ReplyDelete
  6. Greetings! I know this is kinda off topic however
    I'd figured I'd ask. Would you be interested in exchanging links or maybe guest authoring a blog post or vice-versa?
    My blog covers a lot of the same topics as yours and I think we
    could greatly benefit from each other. If you might be interested feel free to shoot me an email.
    I look forward to hearing from you! Awesome blog by the way!


    Here is my web-site DUI Attorney

    ReplyDelete