Friday, April 10, 2015

SharePoint The attempted operation is prohibited because it exceeds the list view threshold

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.
SharePoint introduced the view list threshold to protect the server from unintentional load caused by large queries. For example querying a list of 25000 items could cause a lot of load, especially when multiple users are performing this action. In central admin there is a list view threshold setting for both administrators and general users. This can be found by:

  1. Log into central administration
  2. Go to Application Management and then Manage Web Applications
  3. Pick the web application which you want to change the setting for
  4. On the ribbon select General Settings and then Resource Throttling 
  5. Now the LVT can be set
It's not recommended to set the List View Threshold higher as it can lead to load and performance problems. If you have a large list that needs querying, indexing fields may help with the problem.

No comments:

Post a Comment