Hi all,
I am facing a issue for a while.
One of my Workflow step takes a while to execute.
1. My Workflow has two levels sub workflows. Main workflow calls 1st Level of sub Workflow and then 1st level of subworkflow calls second level of sub workflow. Second level of Sub workflow has a step which fails for first attempt with error message "Work Item xxxxxxxx Locked By User XXXXX (enqueue error)". After Retry attempt by standard setting in 20 minutes the workitem gets processed.
2. My issue is why is it getting locked for the workitem by workflow initiater. in this task we are updating a custom table. but the step is executed in background by wf-batch and error log shows the username who initiated the workflow. And as per log the Workitem is locked for enqueue error which indicates that standard workflow tables are locked for that user.
This error does not occur in Development system but occurs in Quality.
We deleted the second level sub workflow and re created the whole workflow and tested again but still the same error.
We did a retry attempt for specific to this subworkflow at workitem level in misc tab for 1 min but this doesnot work.
So requesting any ideas about eliminating this error.
Thanks.