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 studio
2. 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’)
SET TaskStatus = 8
WHERE 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.