Symptoms

We are getting an error when trying to run a workflow
 

Diagnoses

Workspace is showing the following error:

Message: Error occurred trying to Execute (SmoSPDocument) - Microsoft.SharePoint.Client.ServerException: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator. at Microsoft.SharePoint.Client.ClientRequest.ProcessResponseStream(Stream responseStream) at Microsoft.SharePoint.Client.ClientRequest.ProcessResponse() at SourceCode.SharePoint.Client.DocumentFunctions.GetDocuments(CamlQuery query, UInt32 rowLimit) at SourceCode.SharePoint.Client.DocumentFunctions.GetDocuments(RuntimeFieldl] fields, String folder, UInt32 rowLimit, Boolean recursiveAll) at SourceCode.SmartObjects.Services.SharePoint.Content.SmoSPDocument.callListMethod(Propertyt] inputs, Propertyt] returns, Method method) at SourceCode.SmartObjects.Services.SharePoint.Content.SmoSPDocument.Execute(Propertyt] inputs, RequiredProperties required, Propertyt] returns, Method method) ServiceName: SomeServiceName

I've checked in SharePoint Central Admin and the column lookup limit exceeds the number of looks for the libraries.
 

Resolution

We discovered that the SharePoint Content service instance was pointed toward the staging environment. After updating the service instance to point toward production, we were able to retry the process instances and resolve the issue.