SharePoint 2013 Workflow Cancels (Suspends) with the error “The query to field ‘Author’ is not valid”

Hi,

Today, I stumbled into an issue. I copy-pasted some part of SPD 2013 workflow to another one. Both WFs are located on the same site and both uses lists which contain the same fields. After pasting I had to fix only step transition parts (on the bottom of every step), but after that the check WF for errors passed well. However, the new WF always failed with the following error message:

130319_01_cut

 

RequestorId: 7c396fe3-707c-7e6e-0000-000000000000. Details: RequestorId: 7c396fe3-707c-7e6e-0000-000000000000. Details: An unhandled exception occurred during the execution of the workflow instance. Exception details: System.ApplicationException: HTTP 400
{"Transfer-Encoding":["chunked"],"X-SharePointHealthScore":["1"],"SPClientServiceRequestDuration":["24"],"SPRequestGuid":["7c396fe3-707c-7e6e-ab6c-c1f8a977af5d"],"request-id":["7c396fe3-707c-7e6e-ab6c-c1f8a977af5d"],"X-FRAME-OPTIONS":["SAMEORIGIN"],"MicrosoftSharePointTeamServices":["15.0.0.4420"],"X-Content-Type-Options":["nosniff"],"X-MS-InvokeApp":["1; RequireReadOnly"],"Cache-Control":["max-age=0, private"],"Date":["Tue, 19 Mar 2013 07:42:06 GMT"],"Server":["Microsoft-IIS\/7.5"],"X-AspNet-Version":["4.0.30319"],"X-Powered-By":["ASP.NET"]}
{"error":{"code":"-1, Microsoft.SharePoint.SPException","message":{"lang":"en-US","value":"The query to field 'Author' is not valid. The $select query string must specify the target fields and the $expand query string must contains Author."},"innererror":{"message":"The query to field 'Author' is not valid. The $select query string must specify the target fields and the $expand query string must contains Author.","type":"Microsoft.SharePoint.SPException","stacktrace":" at Microsoft.SharePoint.SPListItemEntityCollectionCamlQueryBuilder.ParseSelectAndExpand()\u000d\u000a at Microsoft.SharePoint.SPListItemEntityCollectionCamlQueryBuilder.BuildCamlQuery()\u000d\u000a at Microsoft.SharePoint.SPListItemEntityCollectionCamlQueryBuilder..ctor(SPList list, RESTfulQuery restQuery, Nullable`1 itemId)\u000d\u000a at Microsoft.SharePoint.SPListItemEntityCollection.TryWriteAsOData(ODataWriter writer, RESTfulQuery query, ProxyContext proxyContext)\u000d\u000a at Microsoft.SharePoint.Client.ServerStub.Write(Object value, Uri path, ODataWriter writer, RESTfulQuery query, ProxyContext proxyContext)\u000d\u000a at Microsoft.SharePoint.Client.Rest.RestRequestProcessor.Process()\u000d\u000a at Microsoft.SharePoint.Client.Rest.RestRequestProcessor.ProcessRequest()\u000d\u000a at Microsoft.SharePoint.Client.Rest.RestService.ProcessQuery(Stream inputStream, IList`1 pendingDisposableContainer)","internalexception":{"message":"The query to field 'Author' is not valid. The $select query string must specify the target fields and the $expand query string must contains Author.","type":"Microsoft.SharePoint.Client.InvalidClientQueryException","stacktrace":""}}}}
at Microsoft.Activities.Hosting.Runtime.Subroutine`1.SubroutineChild.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

I tried to restart the farm, republish the WF, but all to no avail. It failed in the same place every time. After making several changes in WF I realized that it started to fail always on the same place, but this place changed.

Both times, this places were on the Assign task activity. After some time I realized that if I opened task activity, pressed OK without any changes and deployed the workflow, this place started to work as expected.

Solution. So, to overcome the issue, you could try to open all the task activities in WF, press OK without any changes and republish the WF.

Hope it helps somebody else :-).

2 thoughts on “SharePoint 2013 Workflow Cancels (Suspends) with the error “The query to field ‘Author’ is not valid”

Leave a Reply

Your email address will not be published. Required fields are marked *