The List View Threshold Has Been Exceeded

Error Example:

An error occurred while executing connection '<connectionName>': Error reading from entity '<entityName>': The list view threshold, which is defined by the SharePoint administrator, has been exceeded.
To solve this issue contact your administrator or reduce the size of the reading batch, which is currently 5000.

Cause:

This is caused when the list/library in SharePoint has more items than the view threshold limit (default is 5000 items), and the user has a view defined with a filter or a sort.

This can also happen with the "Folder=;" parameter as that counts as a filter.

Resolution/Workaround:

You need to do one of the following to change their view settings:

• Update the current view to remove the filter/sort. (Note - AllItems.aspx DOES sort on Name or ID!)
• Create a new view without filter/sort.
• Update the connection string to not use a view. You need to add the "List=;" parameter and update the URL to the base site.​​
  
  

Options #1 and #2 are the easiest, but #3 is best for some cases.

   
There is an optional workaround if you must have some type of filter. You need to create the view with: No sorting, no grouping, "View in folders" disabled, and have the filter enabled on an indexed field. This should work then if the filtered result is less than 5000 items (if more, it will error again). See this page from MS about handling larger libraries/lists which cover indexing fields.

Note - the "Folder=;" parameter is considered a filter! If the library has more than 5k items in total, it cannot be used!

 

For more information regarding the upload of a large number of files to SharePoint, please refer to our Best Practices Article.