Sharepoint 2010 5000 list threshold issue
Posted on 2016-10-23
I have a user who has created a view to display all documents checked out to him across all folders. Apparently this report used to work correctly but recently he has been receiving the message that he's exceeded the 5,000 item list threshold. I spoke with him about it and was assured that at most he would have 500 or so documents checked out.
This morning I made (temporary) changes to the site to allow the view to work. Changing to 20,000 still gave the error, changing to 200,000 allowed the view to finish.
But there is only 473 items in the view?
No idea why this would be happening. Clearly I can't leave the value at 200,000 but he needs this view to work.
Is this a bug in Sharepoint or is there some other reason the view is normally failing?