none
SCOM reports empty RRS feed

  • Question

  • Hello, I have installed a new copy of SCOM including SCOM Reporting Services.  I have a separate SCOM Management server and SQL Server.

    However when I look in SCOM reporting there is only Application Monitoring reports.

    One thing that worries me is that we were having problems with installing SCOM reporting and I was waiting on the SQL team to fix SQL reporting services on this server.  In the meantime I installed all our MPs which was completed before Reporting Services were installed.

    Is my problem because the MPs were installed before SCOM reporting services or is there another problem with SCOM reporting services somewhere?  Will I need to delete and re-install all my MPs or is there another fix I can try?

    Many thanks

    Stuart

    Thursday, April 25, 2019 11:02 AM

Answers

  • Well that was a very long day but I think we have finally cracked the problem.

    I followed the instructions in this link http:// model-technology.com/blog/scom-how-to-change-the-data-warehouse-write-account-credentials/

     (Sorry, it won't let me add links until my account is verified and I have no idea how to do that!!)

    OR DO A SEARCH FOR "SCOM: How to Change the Data Warehouse Write Account Credentials"

    and all the errors in the event viewer have now disappeared and reports are starting to appear under reporting so all looking good at the moment.

    Hopefully this link will help someone else with a similar problem

    Thanks again everyone

    Stuart

    • Marked as answer by CooksonStuart Friday, April 26, 2019 3:26 PM
    Friday, April 26, 2019 3:26 PM

All replies

  • Hello Stuart,

    You can install the management packs in beforehand, you need to make sure that the accounts have proper permissions to the SCOM Data Warehouse & SCOM Reporting databases.

    You can find the required permissions here:

    Data Warehouse Write account
    https://docs.microsoft.com/en-us/system-center/scom/plan-security-accounts?view=sc-om-2019#data-warehouse-write-account

    Data Reader account
    https://docs.microsoft.com/en-us/system-center/scom/plan-security-accounts?view=sc-om-2019#data-reader-account

    What issues did you have exactly when trying to install the SCOM Reporting? There's a detailed step-by-step description on how to install it here:

    How to install the Operations Manager Reporting server
    https://docs.microsoft.com/en-us/system-center/scom/deploy-install-reporting-server?view=sc-om-2019#installing-operations-manager-reporting

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    Thursday, April 25, 2019 11:53 AM
  • Many thanks Leon, the install of SCOM Reporting went through fine without any errors so assume all is ok with the install. 
    I checked the rights against the current SCOM SQL server OperationsManagerDW and ReportingServer DBs and there were some differences which have now been corrected but still reports don't show.  I will go through those links again to double check the rights just to be sure.

    Thanks again

    Stuart

    Thursday, April 25, 2019 2:48 PM
  • Hello Leon, all accounts have been configured correctly as per the links you posted.  Reporting services are working when I try to access the URL's from the SQL server.

    All I have listed in Reporting on the SCOM console is Application Monitoring and then Authored Reports, Favourite Reports and Scheduled Reports.  Even Generic reports aren't listed.

    Any ideas?

    Thanks again for taking the time to reply

    Stuart

    Thursday, April 25, 2019 3:06 PM
  • You might also want to check the firewall, I've seen cases where the firewall blocks the connection and the reports are not showing. You can view the required ports here:

    Configuring a Firewall for Operations Manager
    https://docs.microsoft.com/en-us/system-center/scom/plan-security-config-firewall?view=sc-om-2019


    Blog: https://thesystemcenterblog.com LinkedIn:

    Thursday, April 25, 2019 3:09 PM
  • Hi,

    Do we see the the similar picture below?



    It seems that we've checked the SSRS (SQL Server Reporting Services), can we access the Web Service URL and Web Portal URL?

    reportserver



    reports



    If we've confirmed both URLs can be opened without issue. We may consider re-installing the Reporting Server via below command in evaluated command prompt.

    setup.exe /silent /uninstall /components: OMReporting
    setup.exe /silent /install /components: OMReporting /ManagementServer: <ms server> /SRSInstance: <sql_server\insttance_name> /DataReaderUser: <domain\account> /DataReaderPassword: <password> /SendODRReports: 1 /UseMicrosoftUpdate: 0 /AcceptEndUserLicenseAgreement:1

    In addition, we may check the log to see if there is any errors or share the logs for further investigation. The logs are located at:
    %localappdata%\scom\logs

    If the installation is with no errors, after a while, we may see the ODR reports appear:



    Hope the above information helps.

    Regards,

    Alex Zhu
    -----------------------------------------------
    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
    Friday, April 26, 2019 6:42 AM
  • Thanks Leon, the firewall has been turned off on both the management server and SQL server.

    Stuart

    Friday, April 26, 2019 8:14 AM
  • Thanks Alex, yes, your first screen shot is exactly what we are getting.  I had already uninstalled SCOM Reporting Server on a test server that is having the same problem and this seems to have broken SQL reporting services.  I'm waiting on my SQL man to fix this and I'll re-install again.  If we still have the same problem after that I'll try running your command and post back the results.

    Thanks again

    Stuart

    Friday, April 26, 2019 9:17 AM
  • You can also check the Operations Manager event log for any more clues:

    Event Viewer > Applications and Services Logs > Operations Manager


    If you open up the Reporting pane, check the event log afterwards if there are any errors/warnings.


    Blog: https://thesystemcenterblog.com LinkedIn:

    Friday, April 26, 2019 9:20 AM
  • The Operations Manager event log has a lot of errors re connecting to SQL.  31551, 31561, 2115, 8000. 
    We need to work through these and then we might find that everything else starts working as well.

    Thanks for all the replies but I think these events are the likely cause, or at least are not helping matters!

    Stuart

    Friday, April 26, 2019 2:46 PM
  • Well that was a very long day but I think we have finally cracked the problem.

    I followed the instructions in this link http:// model-technology.com/blog/scom-how-to-change-the-data-warehouse-write-account-credentials/

     (Sorry, it won't let me add links until my account is verified and I have no idea how to do that!!)

    OR DO A SEARCH FOR "SCOM: How to Change the Data Warehouse Write Account Credentials"

    and all the errors in the event viewer have now disappeared and reports are starting to appear under reporting so all looking good at the moment.

    Hopefully this link will help someone else with a similar problem

    Thanks again everyone

    Stuart

    • Marked as answer by CooksonStuart Friday, April 26, 2019 3:26 PM
    Friday, April 26, 2019 3:26 PM