Skip to main content



Execute Query Timeout

Any database query executed using the Execute SQL Query Action has a default timeout of 30 seconds.This timeout can be modified by adding the following to the client configuration file:

<appSettings> 
<add key\="inrule:runtime:dbCommand:dbCommandTimeout" value\="50">
</appSettings>

OR

 <configuration> 
<configSections>
<section name\="inrule.runtime" type\="InRule.Runtime.Configuration.RuntimeConfigSectionHandler, InRule.Runtime" /> ...
</configSections>
...
<inrule.runtime>
<dbCommand commandTimeout\="50" /> ...
</inrule.runtime>

This commandTimeout maps to the standard .Net IDbCommand.CommandTimeout property and its value is specified in seconds. In the above example, a wait time of 50 seconds is set, before terminating to execute a command and generate an error.