How to troubleshoot SSRS home page shows empty reports?

CharlieLor 551 Reputation points
2021-01-05T18:52:01.887+00:00

I browsed to http://serverName/Reports_Home/browse/ and it shows "This folder is empty" although in the in the F:\SMS_SRSRP\Reports folder it has a bunch of reports. Any suggestion is much appreciated.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,800 questions
0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-01-06T01:52:24.66+00:00

    Hi @CharlieLor ，
    First you have to make sure that you have uploaded or deployed the report to the report manager. Secondly, you need to make sure that you have sufficient permissions to view reports or folders (only "I" or the administrator has permission to view the "My Reports" folder).
    By default, the Internet Explorer Enhanced Security Configuration is enabled on the server. This causes the ReportManager site to be entirely blank. If I look at the Page Source in IE Developer Console, all HTML is shown.

    Went to Server Manager -> Local Server -> IE Enhanced Security Configuration and turned it off. Report Pages are now displayed as expected.

    If none of the above conditions exist, you may want to look at the SSRS service logs to see if you have any errors. The files are located at:
    C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles
    Most of the time errors are located in those files. And what to do depends on what the error is.

    If you could provide more information, it will help solve your issue. You may describe in detail your browser, configuration role information, and some recent operations, whether you could successfully view all reports before. Please provide more detailed information as much as possible, and I will look forward to your feedback.

    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. CharlieLor 551 Reputation points
    2021-01-06T15:29:45.273+00:00

    Is re-installing SCCM Reporting Service Point and regenerate all the reports on the sql server part of the "uploaded or deployed"? Second, the account that I used to log into the SQL Server that runs the Reporting Services is part of the Local Administrators group. The account I used to log into the SQL Server Reporting Services web page is also part of the Local Administrators group. Third, IE Enhanced Security Configuration is already turned off.

    There is not much in the LogFiles folder RSPortal.log file. Here's an example. 

    2021-01-06 09:06:26.0957|INFO|12|Received request GET /browse/| RequestID = s_b6b9699a-f9d9-4453-90eb-51621ac94da5 
2021-01-06 09:06:26.6582|INFO|12|Received request GET /assets/css/lib-2de6f4d2-b31a-4cc1-8289-8b951fa7766f.css| RequestID = s_219fc1ae-b70d-465d-a38e-612d67258bda 
2021-01-06 09:06:26.7051|INFO|12|Received request GET /assets/css/app-2de6f4d2-b31a-4cc1-8289-8b951fa7766f.css| RequestID = s_7894e29a-d3a1-45a9-be00-f4b588849a8b 
2021-01-06 09:06:26.8613|INFO|12|Received request GET /assets/css/brand.css| RequestID = s_0277f3a3-604e-4eaa-85ea-36b108d8da20 
2021-01-06 09:06:26.9238|INFO|77|Received request GET /assets/js/app-2de6f4d2-b31a-4cc1-8289-8b951fa7766f.js| RequestID = s_2dec97b0-78cc-4c62-a1cd-113d105c8110 
2021-01-06 09:06:26.9238|INFO|12|Received request GET /assets/js/oauth.js| RequestID = s_d2c03d89-64a8-4852-93ee-ce080fe5b0c7 
2021-01-06 09:06:27.0488|INFO|77|Received request GET /assets/img/spinner.gif| RequestID = s_2b66e520-6829-491c-a785-fcea3e5b6452 
2021-01-06 09:06:27.1895|INFO|77|Received request GET /api/v2.0/ServiceState| RequestID = s_ee471587-5ac3-4f95-a201-9bcfaa9e0433 
2021-01-06 09:06:27.2051|INFO|15|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.0066166| RequestID = s_ee471587-5ac3-4f95-a201-9bcfaa9e0433 
2021-01-06 09:06:27.5019|INFO|77|Received request GET /assets/resources/en/strings.json| RequestID = s_1b3cc758-2941-430a-8468-8b383f4dc2df 
2021-01-06 09:06:27.5176|INFO|77|Received request GET /assets/img/fi/ssrs/favicon.ico| RequestID = s_e14b26f0-046e-44d3-ad50-498539b45754 
2021-01-06 09:06:27.5801|INFO|77|Received request GET /api/v2.0/SystemResources| RequestID = s_8e4a2542-32dc-4d17-8c8e-fe72fba9d776 
2021-01-06 09:06:27.5801|INFO|43|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.0068512| RequestID = s_8e4a2542-32dc-4d17-8c8e-fe72fba9d776 
2021-01-06 09:06:27.6738|INFO|77|Received request GET /assets/lib/js/angular-i18n/angular-locale_en-us.js| RequestID = s_b67207a7-dc97-479a-96e0-d245e5d7e798 
2021-01-06 09:06:27.7207|INFO|77|Received request GET /api/v2.0/SystemResources| RequestID = s_48b33948-80f2-48b0-b2f8-dc2ba9a80c05 
2021-01-06 09:06:27.7207|INFO|12|Received request GET /api/v2.0/telemetry| RequestID = s_c53e2709-c000-471c-9dfc-f52a9202436e 
2021-01-06 09:06:27.7363|INFO|10|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.0050611| RequestID = s_c53e2709-c000-471c-9dfc-f52a9202436e 
2021-01-06 09:06:27.7363|INFO|57|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.0080756| RequestID = s_48b33948-80f2-48b0-b2f8-dc2ba9a80c05 
2021-01-06 09:06:27.7676|INFO|77|Received request GET /api/v2.0/System/Properties| RequestID = s_64561aff-a781-49a0-85c7-aea373bd30fd 
2021-01-06 09:06:27.7676|INFO|43|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.0037997| RequestID = s_64561aff-a781-49a0-85c7-aea373bd30fd 
2021-01-06 09:06:27.7832|INFO|77|Received request GET /api/v2.0/powerbiintegration/model.isenabled| RequestID = s_fae9bbba-94f3-4e0d-b5e1-1aa3d536035a 
2021-01-06 09:06:27.7832|INFO|12|Received request GET /api/v2.0/System/Properties| RequestID = s_91a3915a-6e82-432e-949d-855a974911a0 
2021-01-06 09:06:27.7832|INFO|44|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.0014801| RequestID = s_fae9bbba-94f3-4e0d-b5e1-1aa3d536035a 
2021-01-06 09:06:27.7832|INFO|10|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.005494| RequestID = s_91a3915a-6e82-432e-949d-855a974911a0 
2021-01-06 09:06:27.8301|INFO|12|Received request GET /api/v2.0/notifications| RequestID = s_4d6eff2f-c149-4c29-9e9c-42cd6848e429 
2021-01-06 09:06:27.8301|INFO|77|Received request GET /api/v2.0/System/ReportServerRelativeUrl| RequestID = s_e29665db-2176-46c8-ba0e-67a91801d2bb 
2021-01-06 09:06:27.8301|INFO|41|Received request GET /api/v2.0/me| RequestID = s_65657d1a-7fc0-47c4-85cf-a3303b0ed4cd 
2021-01-06 09:06:27.8301|INFO|77|Fetched ProductVersion 15.0.7545.4810| RequestID = s_e29665db-2176-46c8-ba0e-67a91801d2bb 
2021-01-06 09:06:27.8301|INFO|43|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.0012833| RequestID = s_e29665db-2176-46c8-ba0e-67a91801d2bb 
2021-01-06 09:06:27.8301|INFO|42|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.0040783| RequestID = s_4d6eff2f-c149-4c29-9e9c-42cd6848e429 
2021-01-06 09:06:27.8613|INFO|43|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.0392561| RequestID = s_65657d1a-7fc0-47c4-85cf-a3303b0ed4cd 
2021-01-06 09:06:27.8769|INFO|12|Received request GET /api/v2.0/CatalogItems(Path='/')| RequestID = s_df18da30-b532-4654-b1cc-7517207b9df0 
2021-01-06 09:06:27.8769|INFO|9|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.0049896| RequestID = s_df18da30-b532-4654-b1cc-7517207b9df0 
2021-01-06 09:06:27.8769|INFO|12|Received request GET /api/v2.0/CatalogItems(Path='/')/AllowedActions| RequestID = s_d85693e2-f252-4097-be5c-b2770657d03f 
2021-01-06 09:06:27.8769|INFO|10|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.0044233| RequestID = s_d85693e2-f252-4097-be5c-b2770657d03f 
2021-01-06 09:06:27.9238|INFO|77|Received request GET /api/v2.0/System/Properties| RequestID = s_404b3f78-aad2-42e3-8dee-b6ae076a9cd3 
2021-01-06 09:06:27.9238|INFO|25|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.0025008| RequestID = s_404b3f78-aad2-42e3-8dee-b6ae076a9cd3 
2021-01-06 09:06:27.9238|INFO|77|Received request GET /api/v2.0/SafeGetSystemResourceContent(type='UniversalBrand',key='logo')| RequestID = s_35039d26-c07f-4f42-af9e-1bbbdd6c53df 
2021-01-06 09:06:27.9238|INFO|16|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.0017519| RequestID = s_35039d26-c07f-4f42-af9e-1bbbdd6c53df 
2021-01-06 09:06:27.9238|INFO|77|Received request GET /assets/img/ssrs_icon.svg| RequestID = s_204ef1a3-4367-4a57-ac41-457826743e79 
2021-01-06 09:06:27.9707|INFO|77|Received request GET /api/v2.0/System/WebPortalRelativeUrl| RequestID = s_9eb2031a-9dde-45b2-b417-17698492dbad 
2021-01-06 09:06:27.9707|INFO|77|Fetched ProductVersion 15.0.7545.4810| RequestID = s_9eb2031a-9dde-45b2-b417-17698492dbad 
2021-01-06 09:06:27.9707|INFO|12|Received request GET /assets/fonts/powerbiglyphs-regular.woff| RequestID = s_c3d01c76-e666-4475-9a6e-e349ef13d694 
2021-01-06 09:06:27.9707|INFO|41|Received request GET /api/v2.0/Folders(Path='/')/AllowedActions| RequestID = s_8d4b7dd8-1345-440b-9d1e-da3f69d9ed61 
2021-01-06 09:06:27.9707|INFO|57|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.0016146| RequestID = s_9eb2031a-9dde-45b2-b417-17698492dbad 
2021-01-06 09:06:27.9863|INFO|12|Received request GET /api/v2.0/catalogitems(8d108c04-2aa9-49b9-bc43-45cb578d3391)/Model.Folder/catalogitems/| RequestID = s_8384e27b-ca5e-40cc-a21d-050d062901d2 
2021-01-06 09:06:27.9863|INFO|15|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.0075172| RequestID = s_8d4b7dd8-1345-440b-9d1e-da3f69d9ed61 
2021-01-06 09:06:27.9863|INFO|10|Sending response. Response code TestDomain\SCCMAdministrator 200, Elapsed time 0:00:00.013684| RequestID = s_8384e27b-ca5e-40cc-a21d-050d062901d2

    In the RSManagement file, I saw the below lines. I'm not sure if it's related. 

    2021-01-06 09:16:33.8870|ERROR|8|Unhandled error in the Web API. Exception: System.Net.Http.HttpRequestException: Error while copying content to a stream. ---> System.IO.IOException ---> System.Net.HttpListenerException: The I/O operation has been aborted because of either a thread exit or an application request
   at System.Net.HttpResponseStream.EndWrite(IAsyncResult asyncResult)
   at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult)

    In the ReportingServicesService log file, I noticed this line. 

    library!DefaultDomain!1860!01/06/2021-09:00:38:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Invalid PBI Configuration, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;

    Yes, I was able to see all the folders and pages. If I reimport the ReportServer and ReportServerTempDB database and point the reporting server manager to these two database, I am able to see all the folders and pages. However, since this is a migration to a new database we do not want to keep anything in the old ReportServer...we rather just regenerate all of them new.

    My next question is, in the Report Configuration Manager/Web Portal URL, the Virtual Directory shows SMC_Reports but where exactly which physical folder is this virtual directory points to on the local server? How do I verify where it points to?

    I assumed in SQL Server 2019, ReportManager folder is now replaced by Portal folder, correct? At this point, I think I need a way to add the F:\SMS_SRSRP\Reports folder that contains all the reports to the SQL Server Reporting Services.

  3. Joyzhao-MSFT 15,566 Reputation points
    2021-01-08T06:02:34.907+00:00

    Hi @CharlieLor ,

    library!DefaultDomain!1860!01/06/2021-09:00:38:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Invalid PBI Configuration, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;

    Try the following :

    1. Open SQL Server Reporting Services Configuration Manager
    2. Click on Web Service URL menu and make sure that the URL's match the ones located in Web Portal URL menu.
    3. If they're different, open the rsreportserver.config file (C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer) and remove any entries not listed in Web Service URL.
    4. Open your web portal ie. http://localhost/Reports and see if it's resolved. If so, all done.
    5. If not, click the Encryption Keys menu, in the "Delete Encrypted Content" section, click "Delete".
    6. Open your web portal again and see if it's resolved.
    7. Locate and update your datasource credentials.

    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  4. CharlieLor 551 Reputation points
    2021-01-08T12:30:53.093+00:00

    The problem is not because http://localhost/Reports is not resolved. The issue is that http://localhost/Reports shows empty. Do I need to enable TLS1.2? Currently it's showing Disable TLS1.2 : Not Set

  5. Greg Childers 16 Reputation points
    2022-07-08T21:09:40.117+00:00

    was this ever resolved?

    0 comments