Increasing Timeouts used by the KTA Reporting Service - DatabaseCmdTimeoutSec
Article # 3024027 - Page views: 533
Issue
Reporting processing queries fail with a timeout error after ten minutes by default.
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 on the system running the reporting service. This setting is supported as of KTA 7.5.0.25 and KTA 7.6.
Note: On versions 7.5.0.16 -7.5.0.24, 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
Level of Complexity
Moderate
Applies to
| Product | Version | Build | Environment | Hardware |
|---|---|---|---|---|
| KTA | 7.5+ |