Error: "500 internal server error -The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold."

Backups for Microsoft SharePoint fail. The error message, "500 internal server error -The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold," appears in the Failure Reason column of the SaaS Status page.

Environment

  • Datto SaaS Protection 2.0 for Microsoft 365

Cause

The user account has reached the Microsoft API limit for the total number of SharePoint columns can be requested in a given period. Lookup, person, group, workflow status, and managed metadata columns are included in this count. For more information, refer to Microsoft's Software boundaries and limits for SharePoint Servers 2016 and 2019 article.

Resolution

SharePoint rate limits are not within Datto's scope of control. Contact Microsoft support to increase your API usage limits or for assistance with revising your configurations to avoid future throttling.