Share via

ReportViewer stuck at Loading

Peter Parsonage 96 Reputation points
2021-03-17T21:05:00.347+00:00

I have an ASP.NET application using ReportViewer 15.0 that loads server reports (not local ones). From my development machine, the report runs correctly. The viewer correctly loads the report and allows it to be executed. During development, the report is being sourced from the production server.

When I deploy the app to the production web server, the report loads and shows the various parameters for the report. However, when I click View Report the Loading... dialog appears and the report eventually times out without ever producing a result.

The call for data never reaches the database.

The web application uses pass-through authentication and I have execution rights on the report server. I have also used nuget.exe to install the report viewer packageon the web server.

Development machine is Windows 10
Server is Windows Server 2012

All appropriate registrations have been added to the web.config file.

[code]
http://<servername>/ScriptResource.axd?d=NJmAwtEo3Ipnlaxl6CMhvn7PtnjfsGuGMS8kqT0QlYkLm5mPB6OXars7YMIX7zyS3yGuzV3lSr7rAEzrD3M3WOSkKPwKT4kevR4Msf_IM9pfddjgZNq95hnPJPdhuNvGgBueNvKJ3HO8-W7CQT6VoivCiaANGKE8uPCMISVl3EQ1&t=ffffffffb4e3605f
[/code]

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,972 questions
0 comments
Accepted answer
  1. Peter Parsonage 96 Reputation points
    2021-03-19T06:01:57.583+00:00

    I have the answer.

    We couldn't upgrade from Server 2012 to 2019 directly so upgraded first to 2016. That allowed the report viewer to work. We then completed the upgrade to 2019 and the report viewer continues to work.

    Report viewer 15+ does not work on Windows Server 2012 (which is very old).

    Thanks for the help.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 39,666 Reputation points
    2021-03-18T06:36:50.927+00:00

    Hi @Peter Parsonage ,

    It's a little hard for us to narrow down the issue.

    Have you tried to check the excutionlog3 for some details?

    Also you may try to use the newest version of report viewer150.1427.0 to see if it will work.

    Regards，
    Zoe

    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.

    What can I do if my transaction log is full?--- Hot issues November

    How to convert Profiler trace into a SQL Server table -- Hot issues November

    0 comments
  2. Peter Parsonage 96 Reputation points
    2021-03-18T16:52:45.707+00:00

    I'm using the latest version 150.1440
    There's nothing in the event logs or application log

    My next step is to upgrade the server from Server 2012 to Server 2019

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.