cancel
Showing results for 
Search instead for 
Did you mean: 

Workflow with Execute SQL Action Fails to Run with Timeout Error

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
Version history
Revision #:
1 of 1
Last update:
‎12-18-2018 03:05 PM
Updated by: