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.