Avatar

Level 4

We have an issue where hypothesis' get stuck in the "execution in progress" indefinitely.  I've seen a few questions regarding this issue but so far no definitive answers.  

 

To mitigate the issue I would like to setup a technical workflow to automatically do the following.

  • Determine if a hypothesis has been in the "execution in progress" state form more than 8 hours.  
  • If a hypothesis has been running more than 8 hours
    • Stop the hypothesis execution
    • Restart the hypothesis execution

It looks like I can determine if a hypothesis has been running more than 8 hours by checking table nms:remaHypothesis and looking for jobs with an "execution in progress" status and a duration of more than 8 hour.  What I can't determine is how to stop the identified stuck hypothesis and restart it from a work flow.

 

Any suggestoins?