locked
How to flush out suspended workflows from the instancestore RRS feed

  • Question

  • We have identified the need to flush out several different workflows that have been suspended/persisted for a long time (i.e. hung instances). This is so that our test environment can be flushed clean before acceptance tests are re-run.

    The dirty solution is to use a sql script to remove records from the InstancesTable and other related tables in the database.

    What's the proper solution?

    These are WCF workflows.

     

    Thursday, February 17, 2011 5:38 PM

Answers

  • Hi,

    If you are using AppFabric it is possibe o do this with a PowerShell script.

    Get-ASAppServiceInstance | Remove-ASAppServiceInstance -Force

    Regards,

    Alan

     


    http://www.CloudCasts.net - Community Webcasts Powered by Azure
    • Marked as answer by jimasp Friday, February 18, 2011 1:40 PM
    Thursday, February 17, 2011 6:05 PM
  • Hi! I found this article and that's what i've used...

    http://www.funkymule.com/post/2010/04/28/how-to-resume-suspended-workflows-in-net-40.aspx

    With the WorkflowControlClient you can also Terminate, Suspend, Cancel and Unsuspend persisted workflows!!

    Cheers!


    Pablo Rotondo http://www.datapayasadas.com.ar
    • Proposed as answer by pabloide86 Thursday, February 17, 2011 8:17 PM
    • Marked as answer by jimasp Friday, February 18, 2011 1:32 PM
    Thursday, February 17, 2011 8:17 PM

All replies

  • Hi,

    If you are using AppFabric it is possibe o do this with a PowerShell script.

    Get-ASAppServiceInstance | Remove-ASAppServiceInstance -Force

    Regards,

    Alan

     


    http://www.CloudCasts.net - Community Webcasts Powered by Azure
    • Marked as answer by jimasp Friday, February 18, 2011 1:40 PM
    Thursday, February 17, 2011 6:05 PM
  • Thanks.

    Unfortunately, all our dev boxes (including our test rig) are XP, and will not be upgraded any time soon.

     

    Thursday, February 17, 2011 6:15 PM
  • Hi! I found this article and that's what i've used...

    http://www.funkymule.com/post/2010/04/28/how-to-resume-suspended-workflows-in-net-40.aspx

    With the WorkflowControlClient you can also Terminate, Suspend, Cancel and Unsuspend persisted workflows!!

    Cheers!


    Pablo Rotondo http://www.datapayasadas.com.ar
    • Proposed as answer by pabloide86 Thursday, February 17, 2011 8:17 PM
    • Marked as answer by jimasp Friday, February 18, 2011 1:32 PM
    Thursday, February 17, 2011 8:17 PM
  • Thanks Pablo,

    That worked great!

    Friday, February 18, 2011 1:31 PM