Forum Discussion
The attempted operation is prohibited because it exceeds the list view threshold for Document Lib
Using the ShareGate Tool, I have migrated On Premise SharePoint 2013 to SharePoint Online.
Users were updating this document library till day before yesterday. From Yesterday onward, the document library shows empty to the users. But it has files and folders.
The error message - The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. Does the document library has the same 5000 items threshold limit for the view ?
3 Replies
Did you get any further with this? I have found the same it it's most likely some change to the endpoint as we've seen it crop up in a few places that had no issues before.
We found that filtering on certain field is causing this result to be returned (file type) even when the filter should return less than 5k results, and infact it works normally when the filter is removed all together
Sajith G H - Yes document libraries have the 5,000 item list view threshold. This means that you have to configure views that display less than 5,000 items. If you are navigating to the library system page it should show the error on that page and you shouldn't need to display using the F12 Dev tools. It sounds like the page loads, but the library looks empty. That has me a little curious.
You'll need to configure a view that displays less than 5,000 items and make it the default view. Navigate to the Site Contents page, find the library. The site contents page will display the number of items in the library. Is it over 5,000? If not there is something else going on. From the site contents page select the ellipsis | Settings for the library. This will load the library settings page. This should get you started and allow you to create a view that displays less than 5,000 items. There are a bunch of good resources available online to help you work through this. I just searched and the SharePoint Maven post looks good https://sharepointmaven.com/how-to-overcome-sharepoint-5000-item-limit-threshold/
Nate Chamberlain also put a nice page together: https://natechamberlain.com/2018/05/21/how-to-resolve-sharepoint-list-view-threshold-error-the-view-cannot-be-displayed-because-it-exceeds-the-list-view-threshold/
- Is there any filter applied there? The 5.000 limit per view is there but you can certainly store much more documents than 5.000 and it should work without problems
