You synchronize a SharePoint site to SharePoint Workspace. The workspace is created successfully, but one or more lists contain no data. All of these lists have multiple lookup columns. No error is displayed, however, error logs on the server contain the following error:
The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator
Note A lookup column links to another list for possible field values. For example, "Product" might obtain possible values from a list of products and versions.
The unsynchronized lists include more lookup columns than allowed by the lookup column threshold. By default, SharePoint will only process 8 lookup columns in response to a query. The SharePoint server blocks queries that exceed this threshold rather than providing an incomplete response.
You may get this error for a list that appears to contain fewer lookup columns than the threshold allows. This is due to hidden lookup columns associated with certain data types. For example, if a list column is using theManaged Metadata content type, the list will include the hidden lookup columns TaxCatchAll and TaxCatchAllLabel, which perform lookups to a system taxonomy list. Because these columns do not appear in the column list, it may appear that you are below the lookup column threshold after you have exceeded it.
A SharePoint site administrator must make one of the following changes:
After the list or threshold is changed, refresh the list by disconnecting and reconnecting it in SharePoint Workspace. To do this, follow these steps:
Article ID: 2489707 - Last Review: 11/19/2014 18:52:00 - Revision: 9.0