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
Posted by at

7 comments:

  1. Anonymous24 October 2012 at 17:40

    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. Anonymous29 October 2012 at 07:14

    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. Anonymous29 October 2012 at 15:23

    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. Anonymous30 October 2012 at 19:00

    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. Unknown23 July 2013 at 07:36

    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. Anonymous16 November 2013 at 19:44

    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
  7. Anonymous28 November 2014 at 18:39

    electronic cigarette, smokeless cigarettes, buy electronic cigarette, smokeless cigarette, best electronic cigarettes, e cigarette

    ReplyDelete

Subscribe to: Post Comments (Atom)