Friday, March 16, 2012

Deleting all workflows and processes from CRM3

So at work we are currently doing an upgrade of Dynamics CRM3 to CRM 2011 on premise.  Upon attempting the upgrade from 3 to 4 the workflows were taking a long time to convert...like 20+ hours.  Going to Microsoft we were able to gain a script to remove all closed workflow log data.  Unfortunately due to years of bad workflows in the system the majority of the workflows were not closed.  Knowing that all of the workflows would be better handled with the addition of plugins in our new environment we just wanted to delete all the workflows, logs, rules, processes...the whole lot.  Well after playing some with working out the correct process here we go.

delete WFParameter
delete WFActionLog
delete WFAction
delete WFCondition
delete WFRuleLog
delete WFProcessInstance
delete WFRule

these ran fine however we encountered a constraint when deleting WFProcess and WFStep. The fix was as easy as modifying one of the tables relationships (process_steps) and setting the enforce foreign key constraint to no. Running the deletes after that were easy.

delete WFProcess
delete WFstep

after deleting all of this workflow data we were able to convert a 23 hour upgrade to about 3:50 hours.

No comments:

Post a Comment