+3
Hi All,
I have put a "for each" step in one of the workflows to send an email, and it's stuck in an infinite loop sending hundreds of email. Can't stop it through workspace, it just spins with nothing done.
Any way I could stop this from the database or any other place?
P.S : I looked in the Procinst table and I can't see that workflow, but as soon as I start the server, emails starts kicking in.
Any help is appreciated.
Thanks!
+9
Zack
The only way that you are going to be able to kill the process is if you stop the HostServer Service. This will stop the infinite loop and allow you to then go into the database, go to the ProcInst table, and update the status of the process to (error). After that, you can restart the Service and the workflow will not continue.
Ian
+3
For anyone running into this issue, The infinite loop workflow status was "1" not "2"
Setting the status to 0 stopped the workflow.
The table is Server.ProcInst in the K2 database.
SQL update statement for future reference is : update server.ProcInst set Status=0 WHERE Status=1 ( or change 1 to 2 if in your case the status is2 )
Best of luck!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.