DPM 2012 R2 console crashes after install RU5 Solved RRS feed

  • General discussion

  • Just to Share 

    The GUI might freeze in one of the following cases :


    1. You have never protected the DPM server’s System State, with the DPM server itself
    2. You have protected some System State from other Production Servers
    3. You upgrade to UR5
    4. You trigger an inquiry on the DPM Server itself


    1. You have a primary DPM server protecting the System State of a Production Server
    2. You have attached the primary DPM server to a secondary DPM server for Disaster Recovery
    3. You upgrade the secondary DPM server to UR5
    4. You trigger an inquiry on the primary DPM server in the secondary DPM server UI


    1. The UI crashes, and gets hung if you start it again
    2. Cmdlets are also unresponsive


    1. Stop all DPM services (MSDPM, Access Manager, DPM Writer, DPMRA, VssNullProvider)
    2. Open the SQL Server Management Studio (Either from Start Screen, or Run: ssms.exe)
    3. Connect to the SQL Instance holding the DPM DB
    4. Backup Your DPM Backup
    5. Right click the DPM DB and click on “New Query”
    6. Paste the following SQL script:

    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

           WHERE (CONVERT(VARCHAR(4096),PO.ComponentName) = 'System State' OR CONVERT(VARCHAR(4096),PO.ComponentName) = 'Bare Metal Recovery')

           AND PO.ProtectedInPlan = 0

           AND PO.ProtectedObjectId NOT IN (SELECT ProtectedObjectId FROM dbo.tbl_IM_ProtectedObjectAlerts)

           AND LOWER(CONVERT(XML,PO.LogicalPath).value(



           )) != LOWER(SRVR.ServerName)


    1. Press F5 to execute
    2. Start all DPM services
    3. The UI and cmdlets should work normally as before

    Islam Gomaa Microsoft MVP | System Center Data Protection Manager email: Islam @ Islam Gomaa.com Blog:  http://blog.islamGomaa.com

    Friday, February 13, 2015 3:09 PM

All replies

  • Hi,

    I'm planning to update our DPM 2012 R2 RU4 to RU5.. and I'm having one physical server with BRM and SystemState backup ON.
    Should I excpect also this problem as You described? Is this problem common? Or dou You have any ideas how to avoid this situation? Any inside information from MS ?

    rgds Sven

    Saturday, February 14, 2015 1:40 PM
  • I would Upgrade from UR4 to UR5 , if you click on the DPM server inquiry , you will get this issue , and you have to run the SQL Query

    Islam Gomaa Microsoft MVP | System Center Data Protection Manager email: Islam @ Islam Gomaa.com Blog: http://blog.islamGomaa.com

    Saturday, February 14, 2015 3:22 PM
  • We have released a hotfix with a permanent fix for the DPM 2012 R2 UR5 Console Hang post release issue.

    The details are available at the below link:

    Console crashes when you run an inquiry on a DPM server after you install Update Rollup 5 for System Center 2012 R2 Data Protection Manager

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Friday, March 6, 2015 12:47 AM