Workflow appearing twice in SQL RRS feed

  • Question

  • I recently checked up on workflow performance after an extended parental leave and found that one of the workflows appeared twice in the DB.

    The functioning workflow had a watermark being just one or two transactions behind, but the other was behind by what I guess is the time I implemented the workflow (which means several months by now). Both workflows have the same exact ruleid. Funny thing is the RuleLastModified is only off by around 100 milliseconds.

    The stuck workflow has no Relationship type ID nor a Related type ID.

    Not sure where to go from here in order to remove this errornous subscription state (except deleting the errornous row).


    Wednesday, December 17, 2014 12:09 PM