Question / Problem:
Is there a way to increase timeouts used in in the reporting service?
Answer / Solution:
By default queries used by the reporting service have a 10 minute timeout. In some cases, especially if there is a large backlog of data to process, a query could take longer than this and lead to a timeout error. A different timeout value can be specified by setting the DatabaseCmdTimeoutSec setting as an environment variable. This setting is supported as of KTA 126.96.36.199 and KTA 7.6.
Note: On versions 188.8.131.52 -184.108.40.206, the setting has effect on some queries, but not all, so it might still help in certain situations.
Changing the timeout
On each reporting server:
- Set a System Environment Variable where name="DatabaseCmdTimeoutSec" and value is set to a number higher than the default of 600 seconds (ten minutes).
- Exact instructions on setting a system environment variable can be different depending on the version of Windows, so please search for documentation for the version you are using as needed. (examples)
- The setting will take effect when the reporting service is restarted