Hello everybody,

since last Thursday, on our DPM 2012 R2 (including the latest rollup just released) running on Windows Server 2012 R2 (also fully patched via WSUS), we cannot use neither the DPM console nor the DPM PowerShell on the server. When we try to connect, the local SQL Server 2012 instance runs on several CPUs, SQL Profiler shows us many calls to stored procedures executing, but the connection never succeeds. The DPM console hangs in its splash screen, and PowerShell hangs in connecting to DPM (for example, on Get-ProtectionGroup).

We have a maintenance plan added to SQL Server for rebuilding all indexes and updating all statistics. This plan executes fine, but the problem is still the same.

What could I check or do p

Hi Guys,

DPM GUI might crashes after R5 in the following cases

Case1:

• You have never protected the DPM servers System State, with the DPM server itself
• You have protected some System State from other Production Servers
• You upgrade to UR5
• You trigger an inquiry on the DPM Server itself

Case2:

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

Then:

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

Workaround:

1. Stop all DPM services (MSDPM, Access Manager, DPM Writer, DPMRA, VssNullProvider)
2. Backup your DPM DB
3. Open the SQL Server Management Studio (Either from Start Screen, or Run: ssms.exe)
4. Connect to the SQL Instance holding the DPM DB
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( (/child::ArrayOfInquiryPathEntryType/child::InquiryPathEntryType[attribute::Type="Server"]/attribute::Value)[1], VARCHAR(4096) )) != LOWER(SRVR.ServerName) )

7. Press F5 to execute
8. Start all DPM services
9. The UI and cmdlets should work normally as before

I have also blogged about it on my blog : http://blog.islamgomaa.com/

Cheers

Hello Islam,

Thank you for your super-fast response! I had already found your blog but had no courage in following it, because none of the two scenarios you mentioned match ours. We do protect our DPM's system state weekly, and we do not have cascaded DPMs. Our GUI did not crash, it just did never finish to load until we killed mmc.exe.

That being said, I now tried your suggestions, and they seem to work fine. The DPM console is working again.

Just to be safe: We do not have to perform any further action? This DELETE statement does not harm anything? We do not have to re-run some jobs, for example?

THANK YOU very much.

HI Stefan,

the delete statement, delete only the duplicate entry.

you don't need to do any further action

Thank you very much all working now thanks to you !

You 're welcome

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