Wsrtjtyk

We have been building reports for SSRS 2016. Reports that execute in under 2 minutes work fine. However, we have some remotes that need well over 10 minutes.

However, when executing the report it times out after about 2 minutes and returns this error:

Sys.WebForms.PageRequestManagerServerErrorException: An unknown error 

occurred while processing the request on the server. The status code returned 

from the server was: 502

I tried setting the execution timeout in web.config

<httpRuntime executionTimeout="2147472000" maxRequestLength="2147483647" />

I also tried setting the ScriptManager's timeout

 ScriptManager scriptMan = ScriptManager.GetCurrent(this);

 scriptMan.AsyncPostBackTimeout = 10800;

Unfortunately, none of that solved the issue. Any help would be appreciaated.
Thanks guys.

There are several different timeouts in play when you run a report including the viewer control, the report server, and your source database. Keep in mind that waiting over 10 minutes each time you want to run a report is not an ideal experience.

Instead, I would suggest looking into caching the report on a schedule. You can set this up in the report processing options on your report server. You can choose to have the cache refresh once a day for example. This way, when a user decides to run the report, it will load much faster.

Reports do not have the same timeout limitations when refreshing a cache. And since the cached report renders more quickly, you don't have to adjust any timeout settings. This also provides a better user experience.