.svg)
QUESTION:
Is there a way to increase the timeout for a DataAccess Activity in KTA?
A customer is having an issue where their SQL query takes longer than 30 seconds to execute and the activity times out. If they run it in SQL, it does take longer than 30 seconds but does not timeout there in SMSS.
They increased the target duration for the node to no effect. They also added the "Connection Timeout" parameter to the connection string.
ANSWER:
There is no way to increase the 30-second timeout of a DB Query (DAS) call in KTA. Please note 30 seconds is a very large time in SQL. If you have a requirement for the large result set and thus SQL > 30 seconds you could create a custom dll which calls the SQL and your custom dll overwrite the 30-second timeout (in custom code).
The 30-second timeout is by design, as this will prevent knock-on performance issues within KTA itself.
As the query is taking over 30 seconds to execute, they will need to create a custom dll which calls the SQL and in their custom dll overwrite the 30-second timeout (in custom code)
Note:
This has not changed even in the latest 7.9 version of KTA and this is by design.
Please contact support@genustechnologies if you would like assistance in creating the custom DLL.