SharePoint Error - Number of Lookup Columns
-
When your indexed SharePoint content contains tables with several lookup columns, you can get and error message similar to the following when you rebuild your SharePoint source:
A SharePoint error was encountered while refreshing (Cannot load the items for the list "[List_Name]" of the SharePoint site "[Site_Name]". Reason: class CGLSharePoint::RemoteCallFailedException: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.0x80070093)
-
Possible Cause
-
The SharePoint content contains documents with lookup (and workflowstatus) fields exceeding the limit set by the SharePoint List View Lookup Threshold parameter, by default 8.
-
Possible Solutions
-
-
Increase the value of the SharePoint List View Lookup Threshold parameter (see SharePoint 2010/2013: List view Lookup threshold uncovered).
-
Reduce the number of lookup (and workflowstatus) fields in your SharePoint document.
-