web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / i-am-ax-pankaj / Error Infolog for job IT - ...

Error Infolog for job IT - Workflow message processing (5675196596)\Infolog for task Workflow message processing task (5682484957) Failed to find workflow.

I AM AX PANKAJ Profile Picture I AM AX PANKAJ 419

Error Infolog for job IT - Workflow message processing (5675196596)\Infolog for task Workflow message processing task (5682484957) Failed to find workflow.
Error Infolog for job IT - Workflow message processing (5675196596)\Infolog for task Workflow message processing task (5682484957)\SysWorkflow-fault\SysWorkflow-internalFault Failed to find workflow.
Error Infolog for job IT - Workflow message processing (5675196596)\Infolog for task Workflow message processing task (5682484957)\SysWorkflow-fault\SysWorkflow-internalFault Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ErrorException' was thrown.
at Dynamics.Ax.Application.SysWorkflow.internalFault(WorkflowContext _workflowContext, String _user, String _faultMessage) in SysWorkflow.internalFault.xpp:line 29
at Dynamics.Ax.Application.SysWorkflow.fault(WorkflowContext _workflowContext, String _user, String _faultMessage) in SysWorkflow.fault.xpp:line 32
at Dynamics.Ax.Application.SysWorkflowQueue.dispatch(Guid _affinity) in SysWorkflowQueue.dispatch.xpp:line 185
at Dynamics.Ax.Application.SysWorkflowQueueTask.Run() in SysWorkflowQueueTask.run.xpp:line 13
at Dynamics.Ax.Application.BatchRun.runJobStaticCode(Int64 batchId) in BatchRun.runJobStaticCode.xpp:line 54
at Dynamics.Ax.Application.BatchRun.runJobStatic(Int64 batchId) in BatchRun.runJobStatic.xpp:line 13
at BatchRun::runJobStatic(Object[] )
at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)
at BatchIL.taskThreadEntry(Object threadArg)

Solution:- 

1.  Identify the record(s) that are causing the batch to fail.

Select a.RECID from SYSWORKFLOWMESSAGETABLE a Where a.ROOTCORRELATIONID not in(Select b.ROOTCORRELATIONID from SYSWORKFLOWTABLE b)and a.MESSAGELIFECYCLESTATE = 1

2.  Dequeue the SYSWORKFLOWMESSAGETABLE records that do not have a corresponding SYSWORKFLOWMESSAGETABLE record.

Update SYSWORKFLOWMESSAGETABLE Set MESSAGELIFECYCLESTATE = 2 where RECID =<RECID returned from statement above>

The procedures above will dequeue the message causing the error and allow the batch to complete.

 

Note:  As always, ensure you do a proper backup of your existing SYSWORKFLOWMESSAGETABLE prior to attempting this fix.

Comments

*This post is locked for comments