SSRS Data Sources do not display in the folder view

Paul A. Wlson 1 Reputation point
2020-11-20T16:57:45.387+00:00

Data Sources do not display in the browser.

Migrated SSRS from SQL Server 2012 Standard to SQL Server 2019 Enterprise using backup and restore of ReportServices and ReportServicesTemp Databases.

Completed setup in Report Services Configuration Manger and restarted. I can launch the Web Portal URL in IE11 or Chrome and see the Home folder with all subfolders. Folders with reports show the reports in tile or detail view. I can also launch the Web Service URL and see the Data Sources listed and I can click on each and view the XML. I can run existing reports from the Web Portal. But when I click on the Data Sources folder in the Web Portal, I get this error message: Could not load folder contents. Something went wrong. Please try again later.

I would appreciate any advice on how to solve this.

Thank you.

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,810 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2020-11-23T02:14:25.227+00:00

    Hi @Paul A. Wlson ，
    Could you provide more Reporting Services Error Log?
    You could find it through the following path:
    C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles.
    Regards,
    Joy

    0 comments
  2. Paul A. Wlson 1 Reputation point
    2020-11-23T17:35:13.557+00:00

    Thank you @Joyzhao-MSFT

    Here are the last lines from the log for a test report I just created and repeated the error.

    library!ReportServer_0-1!480!11/23/2020-11:29:21:: i INFO: Call to GetSystemPropertiesAction(). User: AENETAD\WilsonP.
    library!ReportServer_0-1!480!11/23/2020-11:29:25:: i INFO: Call to GetItemTypeAction(/Data Sources/CCBreport). User: AENETAD\WilsonP.
    library!ReportServer_0-1!1508!11/23/2020-11:29:25:: i INFO: Call to GetDataSourceContentsAction(/Data Sources/CCBreport). User: AENETAD\WilsonP.
    library!ReportServer_0-1!480!11/23/2020-11:29:25:: i INFO: Call to TestConnectForItemDataSourceAction(/Data Sources/CCBreport). User: AENETAD\WilsonP.
    library!ReportServer_0-1!2a98!11/23/2020-11:29:57:: i INFO: Call to ListChildrenAction(/, False). User: AENETAD\WilsonP.
    library!ReportServer_0-1!212c!11/23/2020-11:30:04:: i INFO: Call to ListChildrenAction(/Testing, False). User: AENETAD\WilsonP.
    library!ReportServer_0-1!5d4!11/23/2020-11:30:05:: i INFO: Call to ListChildrenAction(/Testing/WilsonP, False). User: AENETAD\WilsonP.
    library!ReportServer_0-1!5d4!11/23/2020-11:30:28:: i INFO: Call to ListChildrenAction(/Testing/WilsonP, False). User: AENETAD\WilsonP.
    library!ReportServer_0-1!5d4!11/23/2020-11:30:28:: i INFO: Call to GetItemTypeAction(/Testing/WilsonP/Oracle_data_test1). User: AENETAD\WilsonP.
    library!ReportServer_0-1!5d4!11/23/2020-11:30:28:: i INFO: Call to GetPropertiesAction(/Testing/WilsonP/Oracle_data_test1, PathBased). User: AENETAD\WilsonP.
    library!ReportServer_0-1!5d4!11/23/2020-11:30:28:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/Testing/WilsonP/Oracle_data_test1' cannot be found.;
    library!ReportServer_0-1!5d4!11/23/2020-11:30:28:: i INFO: Call to ListChildrenAction(/Testing/WilsonP, False). User: AENETAD\WilsonP.
    library!ReportServer_0-1!5d4!11/23/2020-11:30:28:: i INFO: Call to GetItemTypeAction(/Testing/WilsonP/Oracle_data_test1). User: AENETAD\WilsonP.
    library!ReportServer_0-1!5d4!11/23/2020-11:30:28:: i INFO: Call to GetPropertiesAction(/Testing/WilsonP/Oracle_data_test1, PathBased). User: AENETAD\WilsonP.
    library!ReportServer_0-1!5d4!11/23/2020-11:30:28:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/Testing/WilsonP/Oracle_data_test1' cannot be found.;
    library!ReportServer_0-1!5d4!11/23/2020-11:30:28:: i INFO: Call to CreateReportAction(Oracle_data_test1, /Testing/WilsonP, True). User: AENETAD\WilsonP.
    library!ReportServer_0-1!5d4!11/23/2020-11:30:28:: i INFO: Call to SetItemDataSourcesAction(/Testing/WilsonP/Oracle_data_test1). User: AENETAD\WilsonP.
    library!ReportServer_0-1!480!11/23/2020-11:30:35:: i INFO: Call to GetItemTypeAction(/Data Sources/CCBreport). User: AENETAD\WilsonP.
    library!ReportServer_0-1!314!11/23/2020-11:30:35:: i INFO: Call to GetDataSourceContentsAction(/Data Sources/CCBreport). User: AENETAD\WilsonP.
    library!ReportServer_0-1!212c!11/23/2020-11:30:51:: i INFO: Call to CreateReportAction(Oracle_data_test1, /Testing/WilsonP, True). User: AENETAD\WilsonP.
    library!ReportServer_0-1!5d4!11/23/2020-11:30:52:: i INFO: Call to SetItemDataSourcesAction(/Testing/WilsonP/Oracle_data_test1). User: AENETAD\WilsonP.

    0 comments
  3. Joyzhao-MSFT 15,566 Reputation points
    2020-11-24T06:47:23.517+00:00

    Hi @Paul A. Wlson ，
    Thank you for your feedback.
    It can be seen from the error log that "Testing/WilsonP/Oracle_data_test1" can not be found. This should be a problem with the mapping of the datasource. Can the report that uses this data source be opened?
    you could try to remake this datasource "Testing/WilsonP/Oracle_data_test1". To manually redefine it would be much easier than debugging the upgrading process.
    If you have any question, please feel free to let me know.
    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. Paul A. Wlson 1 Reputation point
    2020-11-24T18:45:41.677+00:00

    Thank you again @Joyzhao-MSFT ,

    I got it fixed by installing Oracle 12c ODAC 32bit. I already had 64 bit installed but Reporting Services requires 32 bit.

    https://learn.microsoft.com/en-us/sql/reporting-services/report-data/data-sources-supported-by-reporting-services-ssrs?view=sql-server-ver15
    On the report authoring client
    "SQL Server SQL Server Data Tools - Business Intelligence is a 32-bit application. SQL Server Data Tools - Business Intelligence is not supported on an Itanium-based platform. On an x64 platform, to edit and preview reports in Report Designer, you must have 32-bit data providers installed in the (x86) platform directory.
    On the report server
    When you deploy a report to a 64-bit report server, the report server must have natively compiled 64-bit data providers installed."

    64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64 ODAC121024_x64.zip https://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
    32-bit ODAC 12c Release 4 and Oracle Developer Tools for Visual Studio (12.1.0.2.4) ODTwithODAC121024.zip https://www.oracle.com/database/technologies/dotnet-utilsoft-downloads.html

    Installed the 32-bit ODAC into the same Oracle Base as the 64-bit. Both are installed in the same drive as Reporting Services. (C:)