locked
the attempted operation is prohibited because it exceeds the list view threshold enforced RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have done  MOSS2007  migrate to SP2010 after all is running smothe base but now I have facing issue when try to configured Library Based Retention Schedule on document library,

    and apply this then get the error like "the attempted operation is prohibited because it exceeds the list view threshold enforced"Retaintion Error

    Kindly check belwo screen for review

    Already check threshold limit by CA,all is right configuration.

    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Share Point Application Developer,TCS

    Thursday, May 16, 2013 10:12 AM

Answers

  • Question
    Sign in to vote
    2
    Sign in to vote

    The first question is: Are you sure that there's only 150 items in the library? The view might be a lot smaller but if there's over 5000 in total then it'll still trip the boundary (unless you're clever but that doesn't come out of the box).

    Assuming you are, what does the list consist of, i'm wondering if the lookup threshold might be being breached and misreported.

    As to fixing it, the simplest thing is to increase the threshold limit and see if that works. It is not a good idea for the long term, the cap is set at 5k for a reason, perfomance suffers with large lists and there are ways around it that scale a lot better.

    For now, try upping the limit to something large (during non critical business hours) and see if that allows you to view the list. I'm not sure off the top of my head if the update to the webapp will force an IIS reset but there is a chance.

    • Marked as answer by Qiao Wei Friday, May 24, 2013 9:44 AM
    Thursday, May 16, 2013 5:43 PM

All replies

  • Question
    Sign in to vote
    10
    Sign in to vote

    Hi, to solve this you just have to increase the list vie threshold value.

    • Open Central Administration.
    • Go to Application Management > Manage Web Application and select your web application
    • In the Ribbon, click on General Settings drop-down and choose “Resource Throttling”.
    • In the “List View Threshold”, increase the value
    • Try to replicate the error: If it persists, increase the value again

    Hope this helps !

    Fabrice DG, Technical Solutions Professional, EMEA at AvePoint
    Follow my technical blog (french).

    Please remember to click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if it was useful.

    • Proposed as answer by juanMa2V Thursday, March 17, 2016 3:47 PM
    Thursday, May 16, 2013 1:24 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    hi,

    But i have already check,

    List View Threshold entry is 5000 and my document list have only 500 item.

    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Share Point Application Developer,TCS

    Thursday, May 16, 2013 2:07 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Do you have also tried to change the List View Threshold for Auditors and Administrators value (20.000 is the limit) ?

    Fabrice DG, Technical Solutions Professional, EMEA at AvePoint
    Follow my technical blog (french).

    Please remember to click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if it was useful.

    Thursday, May 16, 2013 2:20 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    yes,

    can i change all value,if change how much increase and any impact for other.

    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Share Point Application Developer,TCS

    Thursday, May 16, 2013 4:02 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    You should increase until it works :)

    I've got another idea... do you have workfows in your list ?

    Fabrice DG, Technical Solutions Professional, EMEA at AvePoint
    Follow my technical blog (french).

    Please remember to click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if it was useful.

    Thursday, May 16, 2013 4:47 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    no,

    no workflow apply on this document library

    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Share Point Application Developer,TCS

    Thursday, May 16, 2013 5:31 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Well, i've no more idea to help you. I was thinking about hidden workflow libraries but seems not to apply in your case.

    Fabrice DG, Technical Solutions Professional, EMEA at AvePoint
    Follow my technical blog (french).

    Please remember to click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if it was useful.

    Thursday, May 16, 2013 5:37 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Might be its happen because of branding and migrate from moss2007 to sp2010.

    Let me try.

    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Share Point Application Developer,TCS

    Thursday, May 16, 2013 5:39 PM
  • Question
    Sign in to vote
    2
    Sign in to vote

    The first question is: Are you sure that there's only 150 items in the library? The view might be a lot smaller but if there's over 5000 in total then it'll still trip the boundary (unless you're clever but that doesn't come out of the box).

    Assuming you are, what does the list consist of, i'm wondering if the lookup threshold might be being breached and misreported.

    As to fixing it, the simplest thing is to increase the threshold limit and see if that works. It is not a good idea for the long term, the cap is set at 5k for a reason, perfomance suffers with large lists and there are ways around it that scale a lot better.

    For now, try upping the limit to something large (during non critical business hours) and see if that allows you to view the list. I'm not sure off the top of my head if the update to the webapp will force an IIS reset but there is a chance.

    • Marked as answer by Qiao Wei Friday, May 24, 2013 9:44 AM
    Thursday, May 16, 2013 5:43 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Yes, I will check then update you.

    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Share Point Application Developer,TCS

    Thursday, May 16, 2013 5:47 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    how to get to Central Administration?

    • Proposed as answer by eluft Tuesday, November 12, 2013 4:47 PM
    • Unproposed as answer by eluft Tuesday, November 12, 2013 4:47 PM
    Monday, October 21, 2013 11:58 PM
  • Question
    Sign in to vote
    2
    Sign in to vote
    I had something similar happen today. We were getting that error on a view that should only ever return a couple hundred records. The filter criteria in the view used a column that was a 'Person or Group type and the criteria was equal to [Me]. In reviewing the data, I had found that a user had put in a person that was no longer valid within our Active Directory. In order to correct, I removed the 'Assigned to' criteria from the view so that I could access the errant record, removed the person from the record, re-attached the 'Assigned to' in the search criteria and was able to access the view successfully.
    Tuesday, November 12, 2013 4:54 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks Fabrice, your solution helped me with a process that uploads (batch) 10,000+ PDF files.
    Thursday, March 17, 2016 3:49 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks Work for me!!
    Monday, June 5, 2017 1:47 PM