Skip to main content
Search Again

We think these articles could help you:

    See More

    ALERT: This site will be decommissioned at the end of December 2018. All existing and new Nintex knowledge content will be available within the new Knowledge Base area of the Nintex Community site. 

    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