none
Restoring pre-migration DPM Database - Reporting Tab issue RRS feed

  • Question

  • Before migration, upgraded DPM 2010 to 2012 thru to 2012 R2. Took backup of database.

    Built new Windows 2012 R2, SQL 2012 SP1 & DPM 2012 R2. While database is blank, DPM seems to work fine.

    Restored pre-migration backup of DPM database over this new blank database. Most of DPM seems fine so far. Tape autoloader and attached disks are recognised and previous backups are all available. Protection Groups seem fine.

    Accessing the reporting tab causes MMC to quit with error.

    Description:

      AppName: mmc AppVer: 4.2.1205.0 ModName: mmc.exe

    ModVer: 6.3.9600.16384 StackHash: 9EAE70C3

    Problem signature:

      Problem Event Name: DPMException

      Application Name: mmc

      Application Version: 4.2.1205.0

      Module Name: mmc.exe

      Module Version: 6.3.9600.16384

      Exception Name: System.NullReferenceException

      Exception Point: Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.RefreshListView

      Other: 9EAE70C3

      OS Version: 6.3.9600.2.0.0.272.7

      Locale ID: 6153

    Event Log:

    An unexpected error caused a failure for process 'mmc'.  Restart the DPM process 'mmc'.

    Problem Details:
    <FatalServiceError><__System><ID>19</ID><Seq>0</Seq><TimeCreated>31/03/2014 10:37:37</TimeCreated><Source>DpmThreadPool.cs</Source><Line>163</Line><HasError>True</HasError></__System><ExceptionType>NullReferenceException</ExceptionType><ExceptionMessage>Object reference not set to an instance of an object.</ExceptionMessage><ExceptionDetails>System.NullReferenceException: Object reference not set to an instance of an object.
       at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.RefreshListView()
       at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.DisplayAppropriateListView()
       at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.CheckAccountStatusAndUpdateUI()
       at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.UpdateReportingUI()
       at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.UpdateReportingPage()</ExceptionDetails></FatalServiceError>

    Accessing reporting using Internet Explorer and the URL for Reporting in SQL seems Okay.

    Seeing as the database restore is the single factor that causes functionality to break I have been trying to ascertain what I might correct incside the pre-migration database.

    While the new machine has the same computer name, the accounts for services and SQL were changed in line with what was suggested/recommended by the setup comments I came across (domain accounts instead of local etc.) So there would be a discrepancy between the pre-migration security accounts and the new servers security accounts.

    Should I try and correct this specific issue and can anyone help with that (seeing as rest seems to be working okay)?

    OR

    Can you point me to the recommended steps that I should follow (post-restore) to get this setup working for reporting?

    Monday, March 31, 2014 10:47 AM

All replies

  • You're not alone. I have the exact same issue (report tab results in MMC crash) after upgrading from DPM 2012sp1 to DPM 2012R2.

    I installed fresh windows 2012r2, then installed DPM 2012sp1, restored database, then upgraded to DPM 2012r2. Now I can't access the report TAB even though http://dpmserver/reports works just fine for viewing DPM reports.

    My error codes are identical to what you posted.

    Additionally, here is the crash log where I thought it was relevant to our situation:

    NORMAL ConnectToReportServerUrl: Try connecting with url [http://dpmserver/ReportServer]
     0D68 0938 05/07 21:18:58.102 42 Reporter.cs(2177)   NORMAL GetReportServerUrl: return [http://dpmserver/ReportServer]
     0D68 0938 05/07 21:18:58.133 42 Reporter.cs(255)   NORMAL  connected to the ReportServer :http://dpmserver/ReportServer/ReportService2005.asmx
    0D68 0938 05/07 21:18:59.915 42 Reporter.cs(396)   NORMAL There is no report in the rootFolderPath :
    0D68 0E30 05/07 21:18:59.930 09 AppAssert.cs(130)   WARNING ASSERT: (FileName:Reporting.cs; LineNumber:612)
    0D68 0E30 05/07 21:18:59.930 09 AppAssert.cs(130)   WARNING There is no DPM report deployed on the report server
     0D68 0E30 05/07 21:18:59.930 34 PageController.cs(1970)   WARNING Attempting to handle fatal error: System.NullReferenceException: Object reference not set to an instance of an object.
     0D68 0E30 05/07 21:18:59.930 34 PageController.cs(1970)   WARNING    at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.RefreshListView()
     0D68 0E30 05/07 21:18:59.930 34 PageController.cs(1970)   WARNING    at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.DisplayAppropriateListView()
     0D68 0E30 05/07 21:18:59.930 34 PageController.cs(1970)   WARNING    at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.CheckAccountStatusAndUpdateUI()
     0D68 0E30 05/07 21:18:59.930 34 PageController.cs(1970)   WARNING    at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.UpdateReportingUI()
     0D68 0E30 05/07 21:18:59.930 34 PageController.cs(1970)   WARNING    at Microsoft.Internal.EnterpriseStorage.Dls.UI.ReportingPage.Reporting.UpdateReportingPage()
     0D68 0E30 05/07 21:18:59.946 34 PageController.cs(2012)   NORMAL Will  invoke Watson
     0D68 0E30 05/07 21:18:59.946 34 PageController.cs(2102)   WARNING UI Thread Exception: System.NullReferenceException
     0D68 0E30 05/07 21:18:59.946 34 PageController.cs(2109)   WARNING --------------------
    • Edited by peacepenguin Thursday, May 8, 2014 4:24 PM remove internal names
    Thursday, May 8, 2014 4:23 PM
  • Fixed! Just to re-cap the problem. On the upgraded DPM 2012 R2 w/ Update Rollup 1 server, everything was fine except an MMC crash when opening the "Reporting" tab in DPM. Reports themselves would run when accessing the report server directly at url: http://dpmserver/reports

    The issue boiled down to missing data in the DPM SQL database at this table:

    Database: DPMDB_DPMSERVER  Table: dbo.tbl_DPS_Reports

    The table structure was present, but no data was in any field. So I installed the exact version of DPM 2012 R2 w/ update rollup 1 in a test VM. A clean install of DPM had values in the same table. I copied the data from the test VM to the production DPM 2012 R2 server. Reporting tab now opens without crashing the MMC.

    There's no environment specific data in this table, so I think this is a safe fix to use if you find yourself in this situation. And notice the "lastmodifiedtime" is sep 4, 2013, about the time DPM 2012 R2 released. So even after update rollup 1, this table remains the same.

    (Take a backup of the DPM database before attempting unauthorized changes to the database in case you mess something up)

    -Ben

    • Proposed as answer by peacepenguin Thursday, May 8, 2014 8:57 PM
    Thursday, May 8, 2014 8:54 PM
  • Hi,

    i have the same problem. Is it possible for you to send me screenshot of your entries?

    Kind regards

    Bernd

    Wednesday, November 25, 2015 1:59 PM
  • Hi peacepenguin,

    Can you elaborate how you copied the data from the SQL test VM to SQL Production.

    Any Step by step guide or screenshots will do.

    I am not an SQL guy hope for your help.

    Thanks,

    Malcolm

    Wednesday, June 8, 2016 6:43 AM
  • Here's some additional instructions for the above fix that I found...

    On the DPM server, open SQL Server Management Studio (right click -> run as admin).

    Browse to the database and table I listed in the original post (Database: DPMDB_DPMSERVER  Table: dbo.tbl_DPS_Reports)

    Right-click the table name and choose "edit top 200 rows"

    Fill in the data as shown.. BUT, do all this at your own risk!!! this absolutley is not a supported fix!! I intentionally did not include the description field as I really want you to do this yourself if you're comfortable fixing this deep of an issue in an unsupported way.

    To get the "full" descriptions, go through the process to find the correct data on your own: Install a CLEAN and FRESH working version of DPM in a test VM, then do these same steps yourself to ensure you copy the "current" version of this table. (its been awhile and many update rollups since the original post).

    It is completely unknown to me if anything else in the failed upgrade did not get "filled back in" the way this table did. So I would highly recommend starting from scratch if you want your DPM machine to remain in a supportable state.


    • Edited by peacepenguin Monday, June 13, 2016 10:54 PM clarification
    Monday, June 13, 2016 10:49 PM
  • Thanks PeacePenguin!   This fixed my issue of when opening the Reporting tab the console crashed.

    Also, if reports are coming back empty, remember to check the connection string at the Reporting Manager dataset.

    Finally, here are the values of the dbo.tbl_DPS_Reports table, in case someone needs them (copy paste this into notepad first)

    GO
    INSERT [dbo].[tbl_DPS_Reports] ([FileName], [DisplayName], [Description], [LastModifiedTime], [IsInvalid]) VALUES (N'DiskUtilization', N'Disk Utilization', N'Summarizes disk capacity, disk allocation, and disk usage in the DPM storage pool.', CAST(N'2013-09-04T07:20:21.143' AS DateTime), 0)
    GO
    INSERT [dbo].[tbl_DPS_Reports] ([FileName], [DisplayName], [Description], [LastModifiedTime], [IsInvalid]) VALUES (N'MediaDetails', N'Tape Management', N'Provides details for managing tape rotation. This report lists all libraries that are below the free media threshold. The data is collected per library and aggregated for all libraries.', CAST(N'2013-09-04T07:20:19.830' AS DateTime), 0)
    GO
    INSERT [dbo].[tbl_DPS_Reports] ([FileName], [DisplayName], [Description], [LastModifiedTime], [IsInvalid]) VALUES (N'Recovery', N'Recovery', N'Provides details about recovery items and statistics of recovery jobs for tracking performance.', CAST(N'2013-09-04T07:20:20.247' AS DateTime), 0)
    GO
    INSERT [dbo].[tbl_DPS_Reports] ([FileName], [DisplayName], [Description], [LastModifiedTime], [IsInvalid]) VALUES (N'RecoveryPointStatus', N'Recovery Point Status', N'Provides the recovery point status of all selected data sources. If at least one good recovery point is present in the specified recovery point window, the status is shown as green. If no recovery point is present in that time window, then that time window is left blank.', CAST(N'2013-09-04T07:20:21.980' AS DateTime), 0)
    GO
    INSERT [dbo].[tbl_DPS_Reports] ([FileName], [DisplayName], [Description], [LastModifiedTime], [IsInvalid]) VALUES (N'Status', N'Status', N'Provides status of all recovery points for a specified time period, lists recovery jobs, and shows the total number of successes and failures for recovery points and disk-based and tape-based recovery point creations. This report shows trends in the frequency of errors that occur and lists the number of alerts.', CAST(N'2013-09-04T07:20:21.550' AS DateTime), 0)
    GO
    INSERT [dbo].[tbl_DPS_Reports] ([FileName], [DisplayName], [Description], [LastModifiedTime], [IsInvalid]) VALUES (N'TapeUtilization', N'Tape Utilization', N'Provides trends in tape utilization to assist in capacity planning and making decisions about allocating additional tapes.', CAST(N'2013-09-04T07:20:20.690' AS DateTime), 0)
    GO
    


    FileName    DisplayName    Description    LastModifiedTime    IsInvalid
    DiskUtilization    Disk Utilization    Summarizes disk capacity, disk allocation, and disk usage in the DPM storage pool.    2013-09-04 07:20:21.143    0
    MediaDetails    Tape Management    Provides details for managing tape rotation. This report lists all libraries that are below the free media threshold. The data is collected per library and aggregated for all libraries.    2013-09-04 07:20:19.830    0
    Recovery    Recovery    Provides details about recovery items and statistics of recovery jobs for tracking performance.    2013-09-04 07:20:20.247    0
    RecoveryPointStatus    Recovery Point Status    Provides the recovery point status of all selected data sources. If at least one good recovery point is present in the specified recovery point window, the status is shown as green. If no recovery point is present in that time window, then that time window is left blank.    2013-09-04 07:20:21.980    0
    Status    Status    Provides status of all recovery points for a specified time period, lists recovery jobs, and shows the total number of successes and failures for recovery points and disk-based and tape-based recovery point creations. This report shows trends in the frequency of errors that occur and lists the number of alerts.    2013-09-04 07:20:21.550    0
    TapeUtilization    Tape Utilization    Provides trends in tape utilization to assist in capacity planning and making decisions about allocating additional tapes.    2013-09-04 07:20:20.690    0


    • Edited by juanMa2V Thursday, February 22, 2018 10:27 PM Added the insert scripts for dps reports
    • Proposed as answer by zzmoT Wednesday, December 19, 2018 6:23 PM
    Monday, February 19, 2018 5:27 PM