Skip to main content
Search Again

We think these articles could help you:

    See More
    Nintex Knowledge Base

    Workflow with Execute SQL Action Fails to Run with Timeout Error

    Status: Validated

    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
    • Was this article helpful?