Yet Another Report Timeout Solved

Every now and then, I run into mysterious report timeouts. This time the client had a farm of two report servers integrated with MOSS with long running reports that would time out after two minutes or so. Normally, you shouldn’t have such report monsters but life is not perfect, right? The client did a due diligence and had checked/changed every possible timeout setting, including:

1. Report Processing Timeout in the Reporting Services Server Defaults settings in SharePoint Central Administration.
2. The httpRuntime settings on all SharePoint farm servers’ web.config files:

   <httpRuntime maxRequestLength=”51200″ executionTimeout=”9000″ />
   

3. The “databaseQueryTimeout” value in the RSReportServer.config file from 120 to 900 (15 minutes).

   <Add Key=”DatabaseQueryTimeout” Value=”900″/>
   

4. The connection timeout in IIS for the web site on each MOSS server from 120 to 240 seconds.

Alas, no help. Reports would still time out. After much investigation, we discovered a server timeout setting on the load balancer which was set for 2 minutes. After increased it to 15 minutes, the problem went away. So many timeout settings, so little time…

Want more timeout tips? Check out this blog which I wrote four years ago.