Maintenance Mode History Report Management pack

This MP includes a report that allows tracking of who is using maintenance mode to disable monitoring and reports the maintenance start, end, comment, user id and reason code.

10 thoughts on “Maintenance Mode History Report Management pack

  1. TestBD

    Thank you for providing this interesting MP. It would be very nice, if the report would be working. If I start the report for a system, everytime I get the error message:

    “An error has occurred during report processing.

    Query execution failed for data set ‘OperationsManagerDW’.

    For more information about this error navigate to the report server on the local server machine, or enable remote errors.”

    I have an infrastructure with a RMS, 2 secondary MS, a SQL server for the OpsMgr DB, a second SQL server for DWH and a reporting server. All servers are Windows 2003 R2 x64 servers with SP2 and System Center Operations Manager R2 with CU1 installed. Why do I get this error ? Can someone help me ?

  2. Dany Laferriere

    Same problem here…

    “An error has occurred during report processing.

    Query execution failed for data set ‘OperationsManagerDW’.

    For more information about this error navigate to the report server on the local server machine, or enable remote errors.”

  3. Luke Tonkin

    Same problem, any ideas on when or how to resovle this.

    An error has occured during report processing

    Query execution failed for data set ‘OperationsManagerDW’

    The execute permission was deniedon the object ‘SearchMaintMode’, Database , schema ‘dbo’.

  4. Efrén

    Same problem "Query execution failed for data set ‘OperationsManagerDW’.."

    The OperationsManager and the OperationsManagerDW dataabases are in different servers

    Any Idea?

  5. Erling B.K.

    My SCOM Report can do the same error 🙂 – any chance that we can get a hint of what to do ?

    An error has occurred during report processing Query execution failed for dataset ‘OperationsManagerDW’ For more information abut this error navigate to the report server ….

  6. Ingmar Verheij

    If you execute the report via a webpage, for instance on the reporting server, you whould get the following error:

    An error has occurred during report processing. (rsProcessingAborted)
    Query execution failed for dataset ‘OperationsManagerDW’. (rsErrorExecutingCommand)
    The EXECUTE permission was denied on the object ‘SearchMaintMode’, database ‘OperationsManagerDW’, schema ‘dbo’.

    So the resolution to the problem is fairly easy, give the Datawarehouse Read Account EXECUTE permissions on the object’ SearchMaintMode’. This can be done following these steps:
    1) Open Microsoft SQL Server Managemend Studio;
    2) Connect to the SQL server hosting the OperationsManagerDW database;
    3) Browse to Databases\OperationsManagerDW\Programmability\Stored Procedures’;
    4) Open the properties of the SP ‘dbo.SearchMaintMode’;
    5) Select the page ‘Permission’ (on the left);
    6) Click Search
    7) Search your DRA account (for instance SVC_SCOM_DRA);
    8) Grant the permission ‘Execute’ (third row, first checkbox);
    9) Okay, you’re done!

    Ingmar Verheij – http://www.ingmarverheij.com

  7. Ramesh Mohan

    How the objectlist list is populated in this report? Can some one please let me know the value I should enter in the ‘Object List’ field. I tried entering the ManagedEntityRowId with no avail!

  8. Ramesh Mohan

    How the objectlist list is populated in this report? Can some one please let me know the value I should enter in the ‘Object List’ field. I tried entering the ManagedEntityRowId with no avail!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.