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.
Retrieving data ...