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