Article ID: 2489707 - View products that this article applies to.
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:
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 the Managed 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 increase the List view lookup threshold, or modify the list to have no more than the permitted number of lookup columns.
After the list or threshold is changed, refresh the list by disconnecting and reconnecting it in SharePoint Workspace. To do this, follow these steps:
A SharePoint administrator can change the List view lookup threshold in the Resource Throttling properties for the web application from General Settings in Central Administration. However, increasing this value is likely to cause performance problems. For more information on the SharePoint List view lookup threshold, see the entry in the "List and library limits" section on the following web site: http://technet.microsoft.com/en-us/library/cc262787.aspx
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.