Check for errors in workflow instance

Check for errors in workflow manager instance status details on an order that is stuck in the queue state

When orders get stuck in queued state.

Step-by-step guide

  • Open SQL Server Management Studio
  • Click on Databases/WFInstanceManagementDB/Tables

Instance table

  • Select Top 1000 Rows from dbo.Instances
  • Locate the order you want to check and scroll right until you see the WorkflowStatusDetails field

WorkflowStatusDetails

  • Copy the Value in WorkflowStatusDetails (Ctrl + C) and paste it in a notepad document (Ctrl + V)

WorkflowStatusDetails in Notepad

RequestorId: 4f010e05-e3bc-20e5-0000-000000000000. Details: An unhandled exception occurred during the execution of the workflow instance.
Exception details: System.UnauthorizedAccessException: The remote server returned an error: (401) Unauthorized.
Manage claim is required for this operation..TrackingId:1af8b369-7227-4662-91ef-2124ee4e75d2_GRIG51C30,TimeStamp:2014-04-07 15:14:10 --->
System.Net.WebException: The remote server returned an error: (401) Unauthorized.
at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
at Microsoft.ServiceBus.Messaging.ServiceBusResourceOperations.GetAsyncResult`1.EndGetResponse(GetAsyncResult`1 thisPtr, IAsyncResult ar)
at Microsoft.ServiceBus.Messaging.IteratorAsyncResult`1.StepCallback(IAsyncResult result)
--- End of inner exception stack trace ---

Server stack trace:

Exception rethrown at [0]:
at Microsoft.ServiceBus.Common.AsyncResult.End[TAsyncResult](IAsyncResult result)
at Microsoft.ServiceBus.NamespaceManager.OnEndQueueExists(IAsyncResult result)
at Zipper.ZervicePoint.ProcessSystem.Activities.SendCommand`1.EnsureQueue(String serviceBusUri, String queueName)
at Zipper.ZervicePoint.ProcessSystem.Activities.SendCommand`1.PutCommandOnQueue(NativeActivityContext context)
at Zipper.ZervicePoint.ProcessSystem.Activities.SendCommand`1.OnPreComplete(NativeActivityContext context, ActivityInstance completedInstance)
at System.Activities.Runtime.ActivityCompletionCallbackWrapper.Invoke(NativeActivityContext context, ActivityInstance completedInstance)
at System.Activities.Runtime.CompletionCallbackWrapper.CompletionWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)