Query Time Out

taylor

We are using the Raw SQL step to make a call to the database that keeps timing out. How can I increase the length of the time out?

Kathryn_Decisions

On the "Raw SQL" step itself, under the "Advanced" tab, there is a "Specify Timeout" toggle that exposes the "Query Timeout" option.

This refers to how many seconds a query can take before it times out.

Not having this checked doesn't mean that no timeout is applied, but rather the default value read from the Settings.xml's <DefaultDatabaseQueryTimeout> is used. 

In order to make a change to the Settings.xml so we can apply a higher default timeout, we would need a downtime window.