You are viewing limited content. For full access, please sign in.

Question

Workflow Custom Query gives up after 30 seconds

Workflow

Updated November 9, 2015

asked on October 30, 2015

My Workflows appear to be giving up after 30 seconds of run time on my SQL Queries.

I have specified a custom timeout of 600 seconds yet check out the running time before determining the activity failed.

0 0

Replies

replied on November 9, 2015

Hi Chad,

It is pretty hard to troubleshoot without more information.

What is your SQL server's remote query timeout? To find this, right click on your SQL server (the root folder in SQL Management Studio), click properties, click connections, and check under 'remote query timeout'.

What is your custom query and does it return any values when you click 'test'? A screen shot would be helpful so we can see the tokens you use and the syntax of your query.

You could also check any error logs in the 'Event Viewer', as well as the 'Messages' tab in the completed workflow's report.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked October 30, 2015
Updated November 9, 2015
189 views