10 Minute Report Timeout (SSRS)

Products Auditor Discussions & Questions
,
1

I am running into an issue where running Auditor reports in SSRS timeout at exactly 10 minutes (600 seconds). I have changed every single timeout value I could find in SQL Server and SSRS. I opened the report in Report Builder and verified that all of the timeout values for the datasets is set to 0 (unlimited).

The same thing happens even if I run it right on the server running SSRS (and SQL server), so it is not a networking issue.

I even upsized the server, even though the resource utilization on the server was not maxed out and the same thing happened.

Here is a list of what I have done:

SQL Server Instance

Connections Tab

  • Remote Query Timeout = 1800

Report Server Instance

Execution Tab

  • Limit report execution to the following number of seconds = 1800

Advanced Tab

  • SessionTimeout = 1800
  • ExternalImagesTimeout = 1800
  • SystemReportTimeout = 1800
  • AccessControlMaxAge = 1800

SSRS Portal >> Site Settings >> General

  • Allow report to run for X seconds before timing out = 1800

SSRS web.config

  • httpRuntime executionTimeout=“9000” requestValidationMode=“2.0” /

rsrepoortserver.config

  • Add Key=“DatabaseQueryTimeout” Value=“1800” /
2

Marc,

It looks like you have most of the ones we have listed in this article taken care of
How to modify SSRS report timeouts

Here are also some tips.
Reports Generation Takes a While and Completes With Errors

There is an old trick that I’ve sometimes used that will has shown success is getting the reports to run faster. In SQL Server Management Studio, open your Netwrix Auditor instance and find the Netwrix_CommonDB. Right click on it and choose Properties. From there, go to “Options” and change the Compatibility level to SQL Server 2012. I’ve done this just recently with a customer and he did report it did decrease the time it took to run his File Server reports.

Michael Purdin
Netwrix Technical Support Manager

3

I ended up just capturing the dynamic TSQL that the report runs, modified it to eliminate the noise, and added a few indexes. I get results in about a minute. That will get me by for now.

1 Like
4

@mpurdin: What does the “Conf” prefix on tables mean?

5

Marc,

Those are the tables that contain the State-in-Time data.

2 Likes