DPM 2007 Crash Event ID 999
Two weeks ago MY production DPM crashed and I had to fail over the Secondary DPM , I got an error in the Event viewer “An unexpected error caused a DPM service failure. Restart the DPM Service.”
However when I restart the DPM service I got the same error again and keep looping.
In my case I had some invalid replica that couldn't run anymore , so to clean up I ran this store Procedure in SQL Management studio in the DPM Sever
BEGIN TRAN
-- mark replica as invalid if there was some operation happening on that replica
UPDATE tbl_PRM_LogicalREplica
SET Validity = 1 -- Invalid
WHERE OwnerTaskIdLock IS NOT NULL AND
Validity <> 5 AND -- ProtectionStopped
Validity <> 6 -- Inactive
-- Release all the locks held
UPDATE tbl_PRM_LogicalREplica
SET OwnerTaskIdLock = null,
Status=8
UPDATE tbl_RM_ShadowCopy
SET ArchivetaskId = NULL,
RecoveryJobId = NULL
UPDATE tbl_ARM_Datasource
SET Status = 0,
OwnerLockId = NULL
DELETE tbl_RM_DatasourceServerlock
DELETE tbl_RM_ShadowCopyLocks
-- Set All running tasks and jobs to failed
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'
-- unreserve resources held
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
Islam Gomaa
Islam @ IslamGomaa.com