Canvas Initiate

SQL Timeout

We have a workflow that called a stored procedure using the Execute SQL action. It is failing after what looks like exactly 5 minutes after starting.

I ran the interface directly from the database server and it completed.  It took approximately 10 minutes to complete.

This leads me to wonder if the workflow might have a setting somewhere that times the process out after 5 minutes elapse. Is there a setting that would allow me to run a SQL query for longer than 5 minutes?

Thanks for any help in advance.

Mike Trouard

0 Kudos
1 Reply
Automation Master
Automation Master

Re: SQL Timeout

Hi Mike,

if your workflow is picked up by the Timer Service, maybe this post could help you: Optimizing timeout settings: SharePoint timer service



0 Kudos