CRM Report Timeout

Recently we had a long running CRM report that would timeout occasionally with the error below. 

Error: Request timed out.

 Error Message: Request timed out.

 Error Details: Request timed out.

 Source File: Not available

 Line Number: Not available

 Request URL: [URL]

Stack Trace Info: [HttpException: Request timed out.]

 

#1) SQL Server Report Manager, set Do not timeout… (did not work)

Report Timeout Setting

#2) Extending timeouts in the RSREPORTSERVER.CONFIG file…(did not work)

<Add Key=”SQLCommandTimeoutSeconds” Value=”60″ />
<Add Key=”DatabaseQueryTimeout” Value=”120″ />

#3) Extend the CRM web.config executionTimeout property <httpRuntime executionTimeout=”300″ maxRequestLength=”8192″ />…(this works!)

Advertisement