Workflow with Execute SQL Action Fails to Run with Timeout Error

Document created by butlerj Support on Dec 18, 2018
Version 1Show Document
  • View in full screen mode
ISSUE
Workflow that is started automatically (by other workflow/scheduled), with an Execute SQL action is failing to run, sometimes with explicit SQL timeout errors, and other times without.
ERROR CODE
RESOLUTION
  1. Copy your SQL query from the Execute SQL action.
  2. Open SQL Management Studio and run the query against the associated database.
  3. If the query is taking close to, or longer than 15 seconds, this could result in a SQL timeout.
This issue can be resolved by extending that connection timeout value inside the Execute SQL action. Append Connect Timeout=XX at the end of the connection string. For example:
DataSource=server;InitialCatalog=database;IntegratedSecurity=True;Connect Timeout=30

 
ADDITIONAL INFORMATION
The Execute SQL action executes via the .NET framework and there is a built in 15 second timeout value that can cause workflows to fail.
RELATED LINKS

Attachments

    Outcomes