Hi there, I got a requirement to look into Workflow for AX 2012. The issue is when the user approves Workitem the status is not changing in the Workflow history. Navigate to General Ledger > General Journals and there one of my colleagues had developed a workflow. It goes to the production environment and there it worked fine for a few months. Recently our client raised a concern stating that for most of the records the WF process is working fine but for few records like 2 out of 10 journals the WF process is not happening as expected. When user submit the journal to WF then the Workflow workitem goes to the approver. Even after approving the workitem status is not changing in the Workflow History and approver status also still showing as pending. I wonder this is not all for only for few and the rest were working as expected. My analysis points were :
1. After a certain time like a few hours or 1 day the status is changing to completed automatically
2. Backend coding looks fine for me and that too its Production Environment so it's hard for me to try anything
3. I need to know whether it is related to any Workflow batches running background
4. This is not for all the Journals only for selected journals like 2 out of 10
5. Our client complained the same problem for PO workflow and SO workflow also
I am not sure whether we need to write any logic for WorkflowWorkItemTable to change the status according to the Workflow process or something like that?
Please find the below screenshots for reference. Please provide me the solution for this. Thanks in advance.
Thanks & Regards,
Prem
Hi Prem,
There is a workflow messaging processing batch job taking care of processing the status after approval. Can you check the recurrence or if this batch job is probably processing too much records with probably also a performance issue? The job should run every minute. If it is in executing state, then check the start time. If 10 minutes or more have been passed, then you might have a performance issue. In that case, you need to review the workflow configurations and possibly some automatic actions which could cause performance issues.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156