Product DocsMenu

Coveo Platform 7.0 >
Administrator Help > Troubleshooting > SharePoint Error - Number of Lookup Columns

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

People who viewed this topic also viewed