Please use this workaround and see if it resolves the issue:
- Close the UI and all DPM services
- Important: Take a full database backup of the DPMDB to a safe location
- Run the SQL script on the DPM DB that is posted below
- Start all DPM services, and open the UI
This issue may recur whenever the underlying volume of the File Server migrates across nodes of the cluster and an inquiry is triggered on the File Server cluster role. You can run the script again as required.
DELETE FROM dbo.tbl_IM_ProtectedObject
WHERE ProtectedObjectId IN
(
SELECT PO.ProtectedObjectId
FROM dbo.tbl_IM_ProtectedObject AS PO
JOIN dbo.tbl_AM_Server as SRVR
ON PO.ServerId = SRVR.ServerId
JOIN dbo.tbl_IM_DataSource AS DS
ON PO.DataSourceId = DS.DataSourceId
WHERE DS.AppId = '00000000-0000-0000-0000-000000000000'
AND PO.ProtectedInPlan = 0
AND PO.ProtectedObjectId NOT IN (SELECT ProtectedObjectId FROM dbo.tbl_IM_ProtectedObjectAlerts)
AND CONVERT(XML,PO.LogicalPath).exist(
'/child::ArrayOfInquiryPathEntryType/child::InquiryPathEntryType[attribute::Type="NonRootTargetShare"]'
) = 1
AND PO.ProtectedObjectId != PO.DataSourceId
AND SRVR.ServerId = DS.ServerId
AND SRVR.IsRG = 1
)
Inga kommentarer:
Skicka en kommentar