0

How can I clear/reset the workflow count for a list. This list items have already been deleted, but the "Workflows in progress" numbers are still the same. I would like to reset these numbers to zero. Plus I'm worried that these are in fact still pending and using up server resources.

enter image description here

What confused me is that the "Workflow Health" status seems to be correct. enter image description here

Any Ideas?

Improve this question

2 Answers 2

Reset to default
0

You can cancel the in progress workflow by PowerShell. Please refer to old discussion here for sample code and reference.

Improve this answer
4
  • Hi, thanks for the response, but that's not what i was looking for. This works only for list items that are still in the list. My list is basically empty. All items have been deleted and the recycle bin (both stages) has been emptied out.
    – Jaitsujin
    Nov 12, 2020 at 1:16
  • i need to be able to delete/clear orphaned workflow references for list items that have been deleted. running the cleanup job didn't work either.
    – Jaitsujin
    Nov 12, 2020 at 1:18
  • Are the deleted items still in recycle bin?
    – Mark L
    Nov 12, 2020 at 1:45
  • No, all items had already been purged.
    – Jaitsujin
    Nov 12, 2020 at 2:00
0

I finally figured it with some help from the post below. https://www.sharepointeurope.com/wfinstancemanagementdb-in-workflow-manager/

The dbo.Instances table within the WFInstanceManagementDB database is key here.

enter image description here

After deleting all orphaned/suspended workflows here, the progress list was cleared.

enter image description here

Finally piece of mind!

Although this mind not be the best recommended way, it definitely worked for me. So just in case some one has the same issue, make sure you use with causion!

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.