SCOM 2019 - Reports Missing - Using SQL Server 2016 SSRS

Dujon Walsham 6 Reputation points
2020-08-27T10:26:50.7+00:00

Have reinstalled the reporting services role and using SQL Server 2016 SSRS.
Get the Application Monitoring and Windows Server Reports folders but then nothing else after that.

I know there is a fix for this on SQL Server 2017 SSRS but that option is not available in 2016. The 31567 errors i only got them when i uninstalled reporting services when i reinstall it they dont come back up again so not sure if there is something where i cannot use SQL Server 2016 SSRS at all

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,413 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,682 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Leon Laude 85,651 Reputation points
    2020-08-27T11:04:18.997+00:00

    Hi @Anonymous ,

    Has it always been like this, or have you had any changes recently?

    Any other errors/warning events in the Operations Manager event log?

    You could go through the links mentioned in the similar old forum post over here:
    https://social.technet.microsoft.com/Forums/en-US/a8535f7f-83f0-4c77-858e-ea80a1d9e163/scom-reports-issue-unable-to-open-the-reports-in-scom-console-not-loading-at-all-blank-screen?forum=operationsmanagerreporting

    PS: Since this also involves SCOM, you could add the msc-operations-manager-reporting tag to your question.

    ----------

    (If the reply was helpful please don't forget to upvote or accept as answer, thank you)

    Best regards,
    Leon

    0 comments
  2. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2020-08-28T02:30:44.603+00:00

    Hi DujonWalsham-7982,

    Please refer to the following threads which might help:
    SCOM 19 Reports Missing
    Reports are missing in SCOM – Event ID 31567

    Best Regards,
    Amelia

    0 comments
  3. Dujon Walsham 6 Reputation points
    2020-08-31T14:56:47.87+00:00

    Hi All
    Thanks for those answers. I did look at those exact same ones,
    I did end up taking it up to SQL Server 2017 SSRS and applied the fix but still didnt work.
    I was actually getting errors in regards to Data Warehouse event logs such as 31565 which was about an unknown component which failed to deploy but the database name and component name were null

    I did again manage to resolve the issue. I had did an upgrade on SCOM to 2019 but what happened was the permissions from the service accounts had disappeared during it, so even though it completed certain parts got corrupted hence the constant 31565 errors. Unfortunately reinstalling the report server didnt work either although it did deploy the Windows Server Operating system reports but no further. Even went as far as removing the management packs the role tries to import on first install but that also didnt work.

    Eventually i went back to my 1807 DB backup and performed the upgrade again and that worked :)

    0 comments