When attempting to load the items from a list or library, Sharegate displays the following error:
This view cannot be displayed because the number of items exceeds the list view threshold defined in your Central Administration. You might need to set indexes on columns with which your view is filtered to be able to load this view.
|Any error code ending with: -120|
When a list or a library contains too many items, SharePoint can sometimes have problems loading the items in a given view. The maximum number of items that a view can display is defined by the List View Threshold setting in the SharePoint Central Administration and it is set to 5000 by default. If the view tries to load more items than the maximum, it will fail with the error specified above.
The error can also happen with a view that should display less items than the maximum, but that has a filter on a column that is not indexed. For example, if a view called "Recent items" displays the items that have a Modified date in the last week, then it can give this error even if there are less than 5000 items that were modified in the last week. This would happen if the Modified column is not indexed, because SharePoint would need to load all the items in order to determine which ones fit the filter and which ones don't.
There are 3 possible solutions to this issue:
- In Sharegate, select the Built-In view in the View selection drop-down at the top-right of the explorer that displays the items. This view is a special view created by Sharegate and it is designed to load any number of items, regardless of the List View Threshold. This will allow you to copy your items with all their metadata even if the number of items in the list exceeds the List View Threshold.
- If the problem originates from a view that has a filter on a column that is not indexed (as per the example above with the Modified column), indexing the column will allow you to load the items with the selected view. Indexing the column can be done by going in the list's settings in your browser, then clicking on Indexed Columns and finally clicking on Create a new index.
- This solution is not recommended because it can lead to performance issues on your SharePoint server, but increasing the value of the List View Threshold in the SharePoint Central Administration will also solve the issue (up to the new specified value).