locked
SQL reports are blank - SCOM 2012 R2 RRS feed

  • Question

  • Hi,

    Imported SQL MP 6.6.4.0 , after that none of the SQL reports working.  All are blank. I can see the performance data in performance view in monitoring pane.  but when I try to run the report for the same its Blank.

    Target I selected is correct, selected the object properly but no use.

    Please help me in troubleshooting this.

    Thursday, April 21, 2016 8:42 PM

All replies

  • Hi,

    Were the reports working before 6.6.4.0?

    Do you have other reports being with current data?

    Cheers

    Thursday, April 21, 2016 9:09 PM
  • What type of SQL report has issue?
    what is your object in your report?
    Most like the problem come from worng object type
    e.g. SQL Database Space --> object type is SQL DB Engine
          User connection -->  object type is SQL DB Engine
    Roger
    Friday, April 22, 2016 7:39 AM
  • All SQL  Reports. Server has SQL 2012 installed.

    When I go to Microsoft SQL server 2012 (monitoring) report - SQL database space or SQL broker performance.

    Select the object ( SQL server which has SQL 2012 installed). Report is blank

    But I can see the data in performance view in monitoring pane under SQL view for Database space or any performance metrics.

    This is for SQL 2008 and SQL 2005 reports as well

    Friday, April 22, 2016 2:29 PM
  • Yes Simon, reports were working before 6.6.4.0. None of the SQL reports are working but other reports like windows server or Linux or sharepoint reports are working.
    Friday, April 22, 2016 2:30 PM
  • If you go to the event viewer in your SCOM Management Servers, check OperationsManager eventlog, confirm if there's 315** error events there.

    If yes paste them here.

    Cheers

    Saturday, April 23, 2016 10:58 AM
  • Hi Simon,

    I don't see any Event Id which starts with 315..

    Monday, April 25, 2016 8:23 PM