April 19, 2018 at 7:45 am
I'm seeing a bizarre issue that is occurring daily when trying to run a report via the SSRS portal. Upon clicking the report, the entire screen grays out and pops up a Loading notification, which never advances. This is not the Loading message you get when running the report. The process never gets to the report screen (no report menu items, etc.). There are no errors in the log files, and the report execution is not attempted (nothing in the execution log in the ReportServer database for these reports). I've tried setting the recycle time to several days out then restarted the service, but the issue recurred the next day, even within less than the 12 hours of the default setting. The only thing that clears the issue is a restart of the Reporting Services service. This seems to work the rest of the day, but the following morning, ad hoc reports won't run. All scheduled reports are running successfully so this appears to be an issue with the portal. When this occurs, the same loading screen appears when trying to view subscriptions. All other functions on the portal seem to work.
Environment is as follows: 2 servers (1 RDBMS, 1 SSRS) SQL Server 2016 (13.0.4260 for SSRS) SQL Server 2016 (13.0.4466.4 for RDBMS) Windows Server 2012 R2
April 19, 2018 at 7:59 am
John-271860 - Thursday, April 19, 2018 7:45 AMI'm seeing a bizarre issue that is occurring daily when trying to run a report via the SSRS portal. Upon clicking the report, the entire screen grays out and pops up a Loading notification, which never advances. This is not the Loading message you get when running the report. The process never gets to the report screen (no report menu items, etc.). There are no errors in the log files, and the report execution is not attempted (nothing in the execution log in the ReportServer database for these reports). I've tried setting the recycle time to several days out then restarted the service, but the issue recurred the next day, even within less than the 12 hours of the default setting. The only thing that clears the issue is a restart of the Reporting Services service. This seems to work the rest of the day, but the following morning, ad hoc reports won't run. All scheduled reports are running successfully so this appears to be an issue with the portal. When this occurs, the same loading screen appears when trying to view subscriptions. All other functions on the portal seem to work.
Environment is as follows: 2 servers (1 RDBMS, 1 SSRS) SQL Server 2016 (13.0.4260 for SSRS) SQL Server 2016 (13.0.4466.4 for RDBMS) Windows Server 2012 R2
Please check on the Report Server DB and for any memory locking ?
April 19, 2018 at 9:13 am
The report server db is up and running and responsive. I can see subscription reports succeeding during the time when the issue with the ad-hoc report executions is not functioning. There is also more than sufficient memory available on the SSRS server. 16GB ram with around 45% available during these occurrences.
April 19, 2018 at 12:04 pm
John-271860 - Thursday, April 19, 2018 9:13 AMThe report server db is up and running and responsive. I can see subscription reports succeeding during the time when the issue with the ad-hoc report executions is not functioning. There is also more than sufficient memory available on the SSRS server. 16GB ram with around 45% available during these occurrences.
Try monitoring the ReportServer objects with Perfmon. There are counters for requests rejected, tasks queued as well as memory changes which would be worth checking as well as some of the other counters.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply