Can you provide some more details? Are at the end all workflow messages processed? Do you know how many workflow messages are processed per batch run? You can monitor the number of tasks created during the execution. The messages will be bundled with 100 instances per task.
• Yes, All workflow messages are processed without any issue but took long time some time one hour or two hours to clear the queue
• There only 4 to 5 workflows having nearly 25 to 30 tasks and reaming workflows are complete in 1 to 5 levels (simple once).
How many different workflow types do you have? How many legal entities? Do you have workflow configurations, which do have many nodes and are complex?
• Other than standard we have nearly 25 workflow type
• One legal entity
• Complex once only 5(Most used once are 3) reaming are completes with in 1to 5 levels.
Have you checked with the database administrator if the database is healthy or are there some blocks, long running queries or fragmented indexes related to the workflow tables?
• Will check with my admin about this.
Recently we are getting below error messages for some different instances and still we are working on it to track the issue.
Error1:-
Workflow Instance ID: 102115 failed to find a bookmark for the workflow message id f9610ac1-c72e-4a58-b141-4712125e4f05 message type AcknowledgeWorkItemCompleted.
Error2 :-
Workflow Instance ID: 102403 System.Activities The instance ID provided by the workflow host, 583d9eae-28ad-404d-ad6b-d8e37ae209bd, doesn't match the ID stored in the serialized instance, 3f8809a4-e724-404c-8ede-8b158330d287. A host may not deserialize an instance using a different ID than when the instance was serialized. at System.Activities.Runtime.ActivityExecutor.OnDeserialized(Activity workflow, WorkflowInstance workflowInstance)
at System.Activities.Hosting.WorkflowInstance.InitializeCore(IDictionary`2 workflowArgumentValues, IList`1 workflowExecutionProperties)
at System.Activities.Hosting.WorkflowInstance.Initialize(Object deserializedRuntimeState, DynamicUpdateMap updateMap)
at System.Activities.WorkflowApplication.LoadCore(DynamicUpdateMap updateMap, TimeoutHelper timeoutHelper, Boolean loadAny, IDictionary`2 values)
at System.Activities.WorkflowApplication.Load(Guid instanceId, TimeSpan timeout)
at Microsoft.Dynamics.AX.Framework.Workflow.Runtime.WorkflowInstanceManager.Execute(WorkflowMessage message, Guid instanceId, String instanceNumber, String originator, String submitter, Guid affinity)