Occasionally, tasks being run in SOLIDWORKS PDM can get stuck and fail to progress. In this tutorial, we walk through how to cancel these stuck tasks from the Task List. To do so, we'll need access to the SOLIDWORKS PDM Administration tool and the SQL database server.
In the screenshot below we can see that the Task Convert is currently in the Task List. Let’s go through the process of canceling this task as if it were stuck.
First, we need to understand that each Status in the Task List has a Numeric Value linked to it ranging from 1 to 11.
Below is a list of all the possible statuses in the Task List and their Numeric 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
In the screenshot below, the task Convert has the status Waiting for host. We know from our list that Waiting for host has a Numeric Value of 1.
Knowing this information, we now need to open the SQL Server Management Studio.
Once opened, we need to expand DATABASES. Right-click on the vault and select NEW QUERY.
We can now type this command in the SQL Query page.
SET TaskStatus = 8
WHERE TaskStatus = 1
Once we do this, Execute the query. In the Messages box, we can see how many rows were affected.
If we return to the Task List, we can see that the Task has been canceled.
We can also modify the commands we put into the SQL query to change the status of the task. Simply change the values in the command to the numeric value of the statuses we want to change and change to.
About Kaden Sumsion
Kaden is a SOLIDWORKS Technical Support Engineer at GoEngineer.
Get our wide array of technical resources delivered right to your inbox.
Unsubscribe at any time.