How can you clear tasks that will not clear on their own? I have told them to cancel and even rebooted the EPDM server.
This is the answer from Knowledge Base: S-043760
If for some reason the cancel operation in the task list is ‘hanging for a certain task, when trying to cancel it this can be ‘forced to complete by querying the database as follows:
1. Open the SQL server management studio2. Select 'New Query' (make sure the correct database is selected)3. Run the following query (see attached screenshots, '‘task_status at 6.jpg’ and '‘task_status updated to 8.jpg’)
UPDATE TaskInstancesSET TaskStatus = 8WHERE TaskStatus = 6
The query updates the status of the task from 'Cancelling' to 'Deleted' which is enough to remove the 'pending' task from the task list.
Thanks for this information...
This works. Thank-you.
EDIT: forgot to right click on the vault and select New Query from there
Hope it is ok i ask here
I have Suspending hanging, trying to change to Suspended, but the message i get is
Msg 208, Level 16, State 1, Line 1
Invalid object name 'TaskInstances'.
my query is.
What am i missing
SET TaskStatus = 5
WHERE TaskStatus = 10
Retrieving data ...