This was happening weekly, but has recently started happening more often. I have to reboot the mgmt server and DB typically to fix it, stopping the services and deleting contents of the Health Services folder do not fix this problem.
Any suggestions? I do not have SQL Admin permissions, so I am limited on what I can do to troubleshoot these :(, but I was hoping someone might be able to tell me what other workflow may be breaking this one.
I have a lot of workflows that show needs attention - but the workflow shows succeeded, and I cannot remove them.... ignore doesnt clear, retry doesnt clear, nothing clears them.
I have a couple that I have to retry - mainly the autoclose workflows, sometimes notifications but they are rare.
Also, can anyone point me to a powershell script I can run to let me know when this might be happening? I typicvally have an Analyst call saying their tickets are stuck in New status, and this is normally 1-2 hours after it stops... I'd love to have a monitor check it and give me a heads up if something is new for more than 10 minutes, if this can be done.
Thanks for any help!