Skip to main content
Kofax

Increasing Timeouts used by the KTA Reporting Service - DatabaseCmdTimeoutSec

3024027

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 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

 

Applies to:  

Product Version
KTA 7.5+

 

 

  • Was this article helpful?