SharePoint Error - Number of Lookup Columns

Symptom

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.