Monday, 20 Nov 2017 | tralala:)
 

Cannot start DPM after Update Rollup 5 for System Center 2012 R2 Data Protection Manager

My colleague was recently troubleshooting a DPM issue, I believe its word sharing the details.

Symtops:

  • When trying to close freezed DPM console you recieve something like: "you must close all dialog boxes before.." even thought all Windows are closed.
  • DPM console (or a script that tries do anything DPM related) consume all memory resources
  • Event ID: 1002 Application Hang and Event ID: 1001 Windows Error Reporting for AppHangB1 is logged

Example of such the event:

The program mmc.exe version 6.2.9200.16496 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Action Center control panel.
 Process ID: 76c
 Start Time: 01d04ce0689da0c6
 Termination Time: 16
 Application Path: C:\Windows\system32\mmc.exe
 Report Id: xxxx
 Faulting package full name: 
 Faulting package-relative application ID: 

After the classical troubleshooting, MS case was opened and come up with the following 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)
)
 
Apparently MS Bug.
 
 
Did you know?

That this button does nothing?

Follow Us
Topics

Hyper-V

IT Pro

Random

Get in touch

Would you like to share something interesting with me? Mail: info at rozmazat.cz