All workflows show 'Stopped (error):'

(0) Share

Report

Posted on by b_radlyjames

3,087

Something happened and AX lost connection with the SQL database. Our AOS instances seemed to handle it ok as most things returned to normal very quickly.

However, our workflow appears to not have recovered.

Any workflow action that is taken, generates the 'Stopped (error):' message with no details beyond that. Submit, recall, approve, reject... All end up with the same issue.

There are no further messages in any of the even logs. (Server or client machines).

The only other detail I can find is in the log of the 'Workflow line item notifications' batch job:

Cannot edit a record in Workflow notification staging (WorkflowNotificationStaging). Reference: 0, 0.
Error accessing database connection.

*This post is locked for comments

All responses (2)

Answers (1)

Verified answer

b_radlyjames 3,087 on at

Like (0)

Report

RE: All workflows show 'Stopped (error):'

A full CIL and DB sync solves this issue. Thanks!
Suggested answer

nmaenpaa 101,156 on at

Like (0)

Report

RE: All workflows show 'Stopped (error):'

If wf batch jobs are in status Error, set them back to Waiting and see if that solves your problem.