AX2012R2 Workflow message processing job is executing infinitely (stuck)

(0) Share

Report

Posted on by Sebastian Aurand

1,650

Hello together,

I got a problem with the batch job of the Workflow system. One step (Class = SysWorkflowQueueTask) stays permanantly in status "executing", therefore no workflow process is processed.

In the log I couldn't get any information if there is a problem.

Did any face similar problems.

Any help would be appreciated.

Thanks in advance

Sebastian

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

Dick Wenning 8,705 Moderator on at

Like (0)

Report

RE: AX2012R2 Workflow message processing job is executing infinitely (stuck)

I have seen those,

do you use multiple AOS?

there is strange code in workflow framework

the task are taken by 100 ordered by RecID. incase of multiple AOS (50 recid, AOS pool) strange things happen.

Was this reply helpful? Yes No
Dick Wenning 8,705 Moderator on at

Like (0)

Report

RE: AX2012R2 Workflow message processing job is executing infinitely (stuck)

by the way look on the AOS in the windows eventlog of workflow

- are we still using disable users....

Was this reply helpful? Yes No
Sebastian Aurand 1,650 on at

Like (0)

Report

RE: AX2012R2 Workflow message processing job is executing infinitely (stuck)

Thanks for your response. We are running in an single AOS environment and I couldn't find any entry in the eventlog regarding Workflow.

I did some further evaluation and figured out, that there is a blocking INSERT-statement in the SQL-DB. I will post the statement later if it raises again.

The hard way to fix it is done via killing the blocking statement on the DB.

best regards

Sebastian

Was this reply helpful? Yes No
Dick Wenning 8,705 Moderator on at

Like (0)

Report

RE: AX2012R2 Workflow message processing job is executing infinitely (stuck)

I have analyzed the code a that time and changed one index,

be aware this table has pasemistic locking

was the lock also on this table?

Was this reply helpful? Yes No
Sebastian Aurand 1,650 on at

Like (0)

Report

RE: AX2012R2 Workflow message processing job is executing infinitely (stuck)

Now I got the INSERT statement. The follwoing statement is blocking a second statement (WORKFLOWTRACKINGARGUMENTTABLE):

(@P1 uniqueidentifier,@P2 int,@P3 nvarchar(41),@P4 nvarchar(257),@P5 datetime2,@P6 int,@P7 bigint,@P8 int,@P9 bigint,@P10 bigint)

INSERT INTO WORKFLOWTRACKINGARGUMENTTABLE (TRACKINGID,SEQUENCE,DATATYPE,VALUE,TRACKINGDATE,TRACKINGDATETZID,WORKFLOWTRACKINGCOMMENTTABLE,RECVERSION,PARTITION,RECID) VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10)

The blocked statement is the following:

(@P1 datetime2,@P2 datetime2,@P3 int,@P4 datetime2,@P5 nvarchar(9),@P6 bigint,@P7 int)

UPDATE TAXUNCOMMITTED SET TRANSDATE=@P1,CALCULATIONDATE=@P2,RECVERSION=@P3,MODIFIEDDATETIME=@P4,MODIFIEDBY=@P5 WHERE ((RECID=@P6) AND (RECVERSION=@P7))

I guess the index change in SysWorkflowMessageTable won't fix the problem, because it's not involved in the blocking scenario.

Any other idea?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: AX2012R2 Workflow message processing job is executing infinitely (stuck)

Has anyone resolved this issue.

Having the same problem and can't figure out how to get around it without a reinstall...

Was this reply helpful? Yes No
macl 35 on at

Like (0)

Report

RE: AX2012R2 Workflow message processing job is executing infinitely (stuck)

We have the same problem.

Solution of this case is highly desirable...

Was this reply helpful? Yes No
Azeemuddin Chisty 80 on at

Like (0)

Report

RE: AX2012R2 Workflow message processing job is executing infinitely (stuck)

Has anyone got the solution for this cause?

Was this reply helpful? Yes No
Haris Hussain on at

Like (0)

Report

RE: AX2012R2 Workflow message processing job is executing infinitely (stuck)

Getting the same issue on AX 2012 R3 CU11 Version. Please assist.

Was this reply helpful? Yes No
j.montesdeoca 5 on at

Like (0)

Report

RE: AX2012R2 Workflow message processing job is executing infinitely (stuck)

Hi everyone,

I'm having this exact escenario, any help on this will be trully appreciated.

Thanks in advance!

Was this reply helpful? Yes No