SQL Timeout

  • 1 April 2016
  • 1 reply
  • 5 views

Badge +3

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


1 reply

Badge +11

Hi Mike,

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

Regards

Philipp

Reply