Forum Discussion

bjornliow's avatar
bjornliow
New Contributor III
4 days ago

Execution Timeout Expired

Error Message:

Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Operation cancelled by user.
The statement has been terminated. (SQL Error Number -2146232060, -2, 0, 3621). The wait operation timed out

This happened after running Load and Transform for one of my import workflows. Any idea what's causing this? It stops at the PostFileArchives stage:




Import
Workflow

1 Reply

  • carbon's avatar
    carbon
    New Contributor
    3 hours ago

    Are you using a smart integration connector? Have you tried increasing the default timeout limit for your data connector?  I believe the default is 90 seconds. It’s possible that the import pull request is so large that it exceeds this limit and automatically cancels it as a fail safe. 

    Lmk what you think.