Tasks Not Clearing in PDM Admin Task List

I've ran into this several times now where tasks will not cancel, or are stuck at "suspending". To clear this out, log into the sql server, and run a query according to this information:

The tasks displayed in the Task list are found in the database table "TaskInstances” where "TaskStatus" is one of the following values: 1 [Waiting for host]
2 [Starting up]
3 [In process]
4 [Retrying]
5 [Suspended]
6 [Cancelling]
7 [OK]
8 [Cancelled]
9 [Failed]
10 [Suspending]
11 [Resuming]
If there are tasks that are stuck in the "Cancelling" state for example, run the following query to correct it (i.e. update all tasks with status 6 [Cancelling] to status 8 [Cancelled]):
UPDATE TaskInstances
SET TaskStatus = 8
WHERE TaskStatus = 6
Close and reopen the task list to see the update.  Update the query wih appropriate values seen in list above



~Corey Hinman, CEPA