Tasks
      Back to home
      1. Help Center
      2. SOLIDWORKS PDM
      3. Tasks

      How Do I Clear a Stuck Task in PDM?

      Sometimes a convert task becomes “stuck” in the canceling state, but it can be fixed quickly if you have access to the correct resources and follow the instructions found in the SolidWorks Knowledge Base (QA00000109947).

      WARNING! Before you begin:

      This process requires making changes to the SQL database. ALWAYS make a fresh backup of the database before making changes, as making a mistake here can cause damage to the database that can only be resolved by restoring a backup.

      If you are unsure what you’re doing, please reach out to our support team.

      Items required:

      1. Access to the SQL server
      2. The SA Password
      3. Access to the Solidworks Knowledge base 
      4. The SQL script listed in the Knowledge base article QA00000109947

       

      What we are trying to accomplish:

      Each task is assigned a status value in SQL. These values are then displayed as shown below. We want to change the value of the task stuck in the Cancelling status (6) to Cancelled (8)

      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]

       

      The process:

      1. Back up the database.
      2. Load the attached SQL query into SQL Server Management Studio.
      3. Select the database that you want to update.
      4. Update the status IDs based on the values shown in the preceding bulleted list. For example, 
        if there are tasks stuck in the Cancelling state, the query updates all tasks with status 6
        [Cancelling] to status 8 [Cancelled]. This query updates all current tasks with the specified state. Now select Execute.
      5. Close and then reopen the task list to see the update.