torsdag 5 mars 2015

Error 197 after applying UR5 for DPM 2012 R2

This is an issue with UR5, where Create\Modify\Delete on a PG with Clustered File Server datasources may fail with Error 197, or cause a console crash.

Please use this workaround and see if it resolves the issue:

  1. Close the UI and all DPM services
  2. Important: Take a full database backup of the DPMDB to a safe location
  3. Run the SQL script on the DPM DB that is posted below
  4. 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