question

SA-2241 avatar image
0 Votes"
SA-2241 asked sadomovalex answered

List View Threshold Enforced by Administrator

SharePoint 2013 Foundation On-Prem

This error is from Excel that is linked to a Tasks list which is now exceeded the LVT, which I previously increased to 10,000. I have the same issue with most of my views on the tasks list itself and even after reading a lot of articles regarding indexing, filtering results and this still doesn't make sense to me.

Moving to the server first and a standard view that is created with the following filters.

The list currently has 10447 items;

  • Completed = 9304

  • In Progress = 1142

  • Not Started = 1

ViewName: Task Cleanup
- Status (indexed) = Completed AND
- Modified <= [Today]-60

So with the view using a indexed column as the 1st filter and the filtered result is under the LVT, I am not sure why this view is having the error?

"This view cannot be displayed because it exceeds the list view threshold (10000 items) enforced by the administrator."


What am I missing?









office-sharepoint-server-administrationoffice-sharepoint-server-customization
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

When using the server/administrator to look at this view, there were "0" results. I reduced the [modified] filter to 30 days (instead of 60) and there are now 5065 results.

Again this is clearly under the LVT of 10,000 so still not sure why this is not working.

I then removed the "Modified <= [Today]-60" filter leaving only the "Status (indexed) = Completed" in case the 2nd filter was causing the issue and still getting the LVT error.

0 Votes 0 ·

Hi @SA-2241

We are currently researching this issue, any update will be post here.
Thanks for your support and understanding. :)

Regards,
Elsie Lu

0 Votes 0 ·
SA-2241 avatar image
0 Votes"
SA-2241 answered

Is there anyone that can either explain this or provide direction to an article that does, thanks?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

sadomovalex avatar image
0 Votes"
sadomovalex answered

since you are working on-prem you may try the following: run SQL server profiler and check what exact SQL query is executed when you open your view and how many records it returns from the table. It looks like that it still gets all records (which causes throttling) and only after that filters them. In general what you did (limiting number of items by adding extra filters) should help with such problems.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.