Error Example:Verification failed: Error reading from entity '<dataentityname>': The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator. Cause:It’s due to a limitation in SharePoint – the default is maximum 8 lookup columns per list view (which includes lookups, workflow statuses, and people/group columns). There was a threshold increase on SP2013 to 12, it is assumed this also applies to SPO/O365. See the Microsoft Documentation on List Limits. Resolution/Workaround:Yuu need to reduce the number of lookup columns pulled by Cloud Connector. This can be done by creating/editing a view so that it contains no more than 8 (or 12, depending) lookup columns. They can also delete lookup-type columns that are unnecessary. Note - Although this amount can be possibly be adjusted by the administrator in Central Administration, this is highly discouraged by MS as it can cause performance issues. Each lookup is another join on the backend SQL, so increasing that will make everything take longer or even cause stability issues for the site. |
Lookup Columns it Contains Exceeds Threshold
