I have a 2010 site that has a document library with a threshold of 7500 items. The library is currently sitting at over 8000 items, so we have created multiple views that filter on indexed columns.
Each of these views work and return an item amount under the threshold with most returning around 500 items. The issue is, that when I go to filter on a column in the view, I get the following error for only SOME of the views:
I am pretty stumped on this one since there seems to be no consistency on when the error shows. For instance:
- View 'Starts with A' returns 538 items in 4 groups (Group By one indexed column), and it receives the error
- View 'Starts with T' returns 2262 items in 4 groups, and does not receive the error
I have compared the working views to the non-working views:
- CAML is the same (except for the filter criteria)
- View setup is the same (again, different filter criteria)
Also, there are no lookup fields in the library.
Any help/advice would be appreciated, thanks.