The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. - SharePoint Customization - SharePoint for All - Dell Community

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.

This question is not answered

We have a qDiscussionView web part configured to only return 50 top level discussions per page.  the discussion list it is using is quite large, over 115,000 items.

We have temporarily increased the threshold on the Prod site for testing.We have tested dropping this value back to the normal 5000 from 160000 and the same error occurs.  Please be aware that this could cause the SQL servers to become unstable when the site is in use if left.  what do you recommend. 

All Replies
  • Hi Carrie,

      I don't understand quite well what the error is.

    You say "value back to the normal 5000 from 160000 and the same error occurs." What's the error? When it happens?

    What's your QWP and SP version?

    Nic

  • Nic,

    The error is what I put in the discussion title:  “The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator”

    QWP is 5.6 and SP2010 enterprise.

  • Did you ever find a way around this?  Or a solution?

  • Hi Tempsandy,

     

    SharePoint limit the list view threshold to 5000(default) for performance consideration. Quick Apps for SharePoint is running on SharePoint, so it will effect by this limitation. I can provide below suggestions to solve this issue:

    1. Modify the list view threshold according to your business. But I STRINGLY suggest you don’t do that. That may cause some performance issue in SharePoint.
    2. Use the CAML filter to narrow the items. But the first thing you must do is that setting the index to the list, then use CAML filter to query the item by this index filed, it will work if the returned items is less than the threshold.

    Kenny.