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

    Summary
    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.

    Solution
    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.
    You can resolve this timeout issue 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

     
    • Was this article helpful?