8/15/11

Error when trying to view a library in Datasheet view

You receive the following error when selecting Datasheet view in a Sharepoint 2010 library
The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.0x8007009

Cause:  List View Threshold feature - If the number of library columns of type Lookup, Person or Group, and Workflow Status exceeds the threshold enforced by the List View Threshold, an error is returned when trying view the contents of the library in the Datasheet view.

Resolution: Change the Resource Throttling settings under Central Administration | Application Management | Manage Web Application | Your Web Application | General Settings | Resource Throttling. Set the List View Lookup Threshold value to a number larger than the number of lookup and workflow status column in the library and view. The default value is set to 8.

No comments:

Post a Comment