Version Differences for Workflows Stuck on the AHP Server

Revision as of 30 October 2012 15:38 (→Delete all locks present (requires server restart)) ← Previous diff

Revision as of 30 October 2012 15:38 (→Delete all locks present (requires server restart)) Next diff →

Line 14:
	DELETE FROM LOCK_HOLDER;		DELETE FROM LOCK_HOLDER;
-	UPDATE JOB_TRACE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Waiting on Agents','Restarting','Aborting');	+	UPDATE JOB_TRACE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting');
-	UPDATE WORKFLOW_CASE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Waiting on Agents','Restarting','Aborting');	+	UPDATE WORKFLOW_CASE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting');
-	UPDATE JOB_STEP_TRACE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Waiting on Agents','Restarting','Aborting');	+	UPDATE JOB_STEP_TRACE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting');
-	UPDATE JOB_STEP_CMD_TRACE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Waiting on Agents','Restarting','Aborting');	+	UPDATE JOB_STEP_CMD_TRACE SET STATUS = 'Failed' WHERE STATUS IN ('Running','Restarting','Aborting');
	</pre>		</pre>