Deactivated workflow still running, also running multiple times

(0) Share

Report

Posted on by Community Member

We upgraded a CRM system from 4 to 2011 ru18 - however we have subsequently noticed the database grow...

Investigating the issue I can see in system jobs a workflow is running over and over again on the same record - in fact 100's of times a minute. Looking at the workflow it operates on the total amount field changing on a quote and updates the project opportunity entity potential value field.

So far I have:

* Transferred the workflow to myself, then deactivated it. The workflow is still running.

* Changed the workflow to be an on-demand workflow, activated it. The workflow is still running.

* All the workflows seem to be running against the same record, so I tried deleting the record. The workflow is still running.

* Gone through the system jobs and tried cancelling them but theres 100's of records and it doesn't do anything.

Any ideas as I'm at a loss as to how to stop these records.

Matt

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Flydancer 1,332 on at

Like (0)

Report

Hi Matt, deactivating the workflow does not cancel already instantiated instances.

If you deactivate the workflow and cancel all instances manually afterwards, you should be fine.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I've tried deactivating it and then cancelling all of the instances but it looks like they are just re-spawning. They also re-spawn in the original owners name even though I've moved it across to my name in order to deactivate the workflow, thus I never get to the stage of them all cancelled.

Matt

Was this reply helpful? Yes No
Suggested answer

Flydancer 1,332 on at

Like (0)

Report

Try stopping the CrmAsyncService on your server before deleting the system jobs.

The CrmAsyncService handles workflows and other stuff, see www.powerobjects.com/.../crm-asynchronous-service-performance-code-mania for more info

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Try to restart IIS app pool,CRM async service , application server and DB server.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Had to do the following:

* Deactivate the Asynch services

* Disable the workflow that was causing the issue

* Run the SQL asynch clean up script (took a long time as over 26 million records)

* Shrink and re-index the database

All seems to be working as it should be.

Thanks for everyones help.

Matt

Was this reply helpful? Yes No