Skip to main content

Increasing Timeouts used by the KTA Reporting Service - DatabaseCmdTimeoutSec

Article # 3024027 - Page views: 533


Reporting processing queries fail with a timeout error after ten minutes by default.



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 and KTA 7.6. 

Note: On versions -, 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 



Applies to  

Product Version Build Environment Hardware
KTA 7.5+      


Article # 3024027