DPM 2012 Reporting Issue (ID : 220)

After upgrading from SCDPM 2012 SP1 to SCDPM 2012 R2, I hit the issue when I tried to configure the Reporting to be send out periodically in the Report Module of SCDPM 2012 R2.

The steps taken was the following :

• Launch the Reporting Services Manager (in my example is SQL 2008 R2, since it’s upgraded gradually from SCDPM 2012 SP1 to SCDPM 2012 R2)
• Ensure to the correct database that I’m pointing to  (e.g. MSDPM2012)
• Navigate to E-Mail Settings.
• Key in the valid Sender Address and SMTP Server.
• Click Apply

• Launch the SCDPM 2012 R2 – Reporting
• Configure the schedule reporting with emails, tested with no issues.keywords : SCDPM 2012, DPM cannot enable e-mail subscription for reports unless SMTP details are configured in the remote SQL Server Reporting Service Installation. SMTP details need to be configured manually when an existing SQL Server is chosen to be used for DPM during DPM setup.  Please enter the SMTP server name, SMTP port number and SMTP From address manually in the SQL Server Reporting Services configuration File.

Configuration file path : c:\Program Files\Microsoft DPM\SQL\MSRS10.MSDPM2010\Reporting Services\ReportServer\RSReportServer.config

The SMTP Server  details on the SMTP Servers tab in the Options dialog enables only DPM alert notifications. For more details, see DPM Help (ID : 220)

SCDPM Report error, Systems Center Data Protection Manager Report Error, cannot configure email distribution in DPM report

Systems Center Data Protection Manager 2012 R2 Keeps Crashing – ID:917

Have managed to upgrade from SCDPM 2012 SP1 to SCDPM 2012 R2.  The DPM agents and the Protection Groups are still intact.

However, when I tried to edit or remove the Protection Group, the SCDPM 2012 R2 Administrator console keeps crashing and restart the DPM Administrator Console

After finding out, the issue is NOT the Data Protection Manager, but it’s the SQL that is storing the DPM Database.  The SCDPM 2012 R2 has also been patched with UR6, however it still crash whenever I tried to edit or remove the Data Protection.

Therefore these are the steps taken.

• Take a backup of the DPM Database
• Right-click on the SQL Management Studio and select “Run as administrator”

• Once the SQL Management launched, right-click on the DPMDB and select “New Query”
• Copy and paste the following SQL Script

update tbl_IM_ProtectedGroup SET IMCatalogXML = replace(cast(IMCatalogXML as nvarchar(max)), '<AllowedBackupType>FullBackup', '<AllowedBackupType>Regular') from tbl_IM_ProtectedGroup where IMCatalogXML like '%<AllowedBackupType>FullBackup%'

• Click Execute and it should show the results.  The example is as above picture. 
• Launch the SCDPM 2012 R2 Administrator Console, and it’s successful can edit or remove the Protection Group.

keywords : SCDPM 2012 R2, upgrade of SCDPM 2010 to SCDPM 2012 R2, Error : 917, Systems Center Data Protection keeps crashing after upgrade in place, in-place, inplace, Restarting Administrator Console.