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

I'm upgrade my sp 2007 to sp 2010 and I have a form library has more then 5000 items. Default view of form library filter items and show only 10-20 item to users.

After upgrade sp2010 All users get below error when going to form library expect site collection admins.

We get the error:

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

To view items, try selecting another view or creating a new view. If you do not have sufficient permissions to create views for this list, ask your administrator to modify the view so that it conforms to the list view threshold.

Solution

The setting for the list throttle

• Open the SharePoint Central Administration,
• go to Application Management --> Manage Web Applications
• Click to select the web application that hosts your list (eg. SharePoint - 80)
• At the Ribbon, select the General Settings and select Resource Throttling
• Then, you can see the 5000 List View Threshold limit and you can edit the value you want.
• Click OK to save it.