Solving “The attempted operation is prohibited because it exceeds the list view threshold” error

While working in SharePoint 2010, you may receive the following error:

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: <nativehr>0x80004005</nativehr><nativestack></nativestack>The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.

I got this error while trying to change the site URL in Site Settings.

The resolution to this error is:

1. Navigate to Central Administration.

2. Go to Application Management > Manage Web Application and click on your web application to select it.

3. In the Ribbon, click on General Settings drop-down and choose “Resource Throttling”.

4. In the “List View Threshold”, increase the value (by a factor of 2, for example) and click OK.

5. Try to replicate the error.  If the error persists, increase the value again until the error goes away.

 

Advertisements

13 Responses to “Solving “The attempted operation is prohibited because it exceeds the list view threshold” error”


  1. 1 Rod November 14, 2011 at 11:35 am

    I’m trying to delete an Access Database in an Office 365 site and receive the same error message: “The attempted operation is prohibited because it exceeds the list view threshold.” I do not find on the Office 365 Administration pages how to change Resource Throttling. Can you help me?

  2. 2 Mauricio March 16, 2012 at 12:11 am

    Thank you, I appreciate it

  3. 3 Sanjay May 23, 2012 at 3:37 am

    Thank you so much, It resolved my issue. I had to increase 15000 before I can rename my site URL.

  4. 4 Anthony June 19, 2012 at 4:27 am

    Great Solution, it worked like a charm for my problem.

  5. 5 Fatma August 2, 2012 at 3:25 am

    Thanks … helped me

  6. 6 Addis Abebayehu August 13, 2012 at 3:29 pm

    Thank you so much. this resolves my issue too.

  7. 7 Pat January 12, 2013 at 12:03 am

    If by ‘solution’ you mean masking the problem until your list grows too large again, rinse, repeat until the server melts then yeah, nice solution.

  8. 8 andrei338 January 12, 2013 at 8:33 am

    Valid point – this is just a temporary fix and is not a substitute for a governance plan to deal with the ever-growing size of content in your list.

  9. 9 Promesses August 7, 2013 at 7:57 am

    Hi,
    I’ve got the same problem today even if I grow up immeasureably the number for the list view treshold but the problem persists.

    The server is not on the real active directory (AD), it’s on a development active directory (DEVAD).
    The active directory (AD) users have this error when trying to connect to the site.
    Furhtermore, sharepoint locals users (from DEVAD) do not have this error.

    I think I have the problem cause the server is not in the real AD.
    I don’t kow how to solve it…

    Thx

  10. 10 Dr. Slice December 5, 2013 at 2:51 pm

    This is seriously the worst answer ever. Stop telling SharePoint users to go around governance tools.

    • 11 Dist February 4, 2015 at 3:12 am

      Then it would be nice to give a better answer then the one mentioned in this article. Just screaming that this is “the worst answer ever” doesn’t solve my problem.

  11. 12 Jodrik November 27, 2014 at 4:00 am

    Thank you very much for this work-around!


  1. 1 Error:The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. Trackback on June 10, 2012 at 4:44 am

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




RSS Information Week Headlines

  • An error has occurred; the feed is probably down. Try again later.

RSS SharePoint Team Blog

  • An error has occurred; the feed is probably down. Try again later.

RSS InfoPath Team Blog

  • An error has occurred; the feed is probably down. Try again later.

RSS Joel Oleson Blog

  • An error has occurred; the feed is probably down. Try again later.

RSS Susan Hanley’s KM Blog

  • An error has occurred; the feed is probably down. Try again later.

Blog Stats

  • 350,848 hits

%d bloggers like this: