question

PeterParsonage-6439 avatar image
0 Votes"
PeterParsonage-6439 asked PeterParsonage-6439 answered

ReportViewer stuck at Loading

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PeterParsonage-6439 avatar image
0 Votes"
PeterParsonage-6439 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered

Hi @PeterParsonage-6439,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PeterParsonage-6439 avatar image
0 Votes"
PeterParsonage-6439 answered Zoehui-MSFT commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for your reply, I'll also do some test locally.

0 Votes 0 ·