DPM 2012 SP1 – Attempting to cancel

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

DPM Attempting to cancel

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”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s