Symptoms

• Job displays “Attempting to cancel for an extended period of time”

Troubleshooting

The jobs that i experienced this issue with refused to budge, even after a full system restart. However, Time Elapsed continues counting up on some of them

Resolution

1. Ensure that there are no other jobs currently running
2. Open SQL Management Studio and connect to your DPM SQL instance
3. Right click on the instance and click “New Query”
4. Copy and paste the following query into the Window——————————————————————————-
   USE DPMDBBEGIN TRANUPDATE tbl_PRM_LogicalREplica

   SET Validity = 1

   WHERE OwnerTaskIdLock IS NOT NULL AND

   Validity <> 5 AND

   Validity <> 6

   UPDATE tbl_PRM_LogicalREplica

   SET OwnerTaskIdLock = null,

   Status=8

   if (select COUNT(name) from tbl_AM_Agent where Name like ‘DPM RA v2%’) > 0

   begin

   exec sp_executesql N’UPDATE tbl_RM_ShadowCopy

   SET ArchivetaskId = NULL,

   RecoveryJobId = NULL’

   end

   UPDATE tbl_ARM_Datasource

   SET Status = 0,

   OwnerLockId = NULL

   DELETE tbl_RM_DatasourceServerlock

   DELETE tbl_RM_ShadowCopyLocks

   UPDATE tbl_TE_TaskTrail

   SET ExecutionState = 3,

   LastStateName = ‘Failure’,

   StoppedDateTime = GetUtcDate()

   WHERE ExecutionState NOT IN (2,3)

   UPDATE tbl_JM_JobTrail

   SET JobState= ‘Failed’,

   EndDateTime = GetUtcDate()

   WHERE jobstate= ‘Execute’ OR jobstate= ‘Retire’

   UPDATE tbl_MM_Global_Media

   SET ReservationLevel = 0,

   ReservationOwnerMMId = null

   UPDATE tbl_MM_Global_Drive

   SET ReservationLevel = 0,

   ReservationOwnerMMId = null

   UPDATE tbl_MM_Global_IEPortResource

   SET ReservationLevel = 0,

   ReservationOwnerMMId = null

   COMMIT TRAN
   ——————————————————————————-

5. Execute Query
6. Open DPM console
7. Find all volumes that were affected (they will most likely say “Recovery Point Creation Failed”)
8. Right click on volume and select “Create Recovery Point”
9. Select “Create a recovery point by using express full backup”