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.