I have migrated a WSS 3.0 farm to SP Foundation 2013. One list has 6500 items. No view will display unless I raise the threshold to > 6500. Test view is filtered on one indexed column that displays only 3700 items when the threshold is raised. When I lower the threshold back to 5000 it fails with the standard threshold exceeded message. I have no sorting or grouping in the test view.

I have searched endlessly and all research says that this view should work. What am I missing? I migrated the list items and then created the indexed columns. Shouldn't that have worked? The list has been added to extensively since the original migration. I have deleted and recreated the indexed column. Any ideas?

  • Did you run the full crawl from central admin? Jul 12, 2018 at 7:29
  • I assume you mean search crawls? Yes, it is crawled every day. I'm not sure how that will affect the issue. Can you elaborate?
    – Jim
    Jul 12, 2018 at 12:08
  • Just making sure you have performed full crawl efter you have added columns to index? Can you paste your code? Jul 12, 2018 at 12:11
  • Have a similar problem... Did you managed to solve this?
    – M.P.
    Nov 20, 2019 at 8:05

1 Answer 1


Do you have multiple filters in that view? If so, make sure that the indexed columns is the first filter, otherwhise it will fail on the column that is not indexed.

  • No, the view that I'm testing with only has the one filter column which is in the first place, of course, and is indexed.
    – Jim
    Jul 12, 2018 at 14:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.