Question

Workflow custom query time out

Workflow

Updated April 16, 2021

asked on April 29, 2015

I have a custom query where I am wanting to return multiple rows of information to insert into a PDF form. The problem I am having is that I am receiving an error, "The operation has timed out" while testing the query.

The table I am using is rather large, approximately 1.4 million records. I have tested the query on a much smaller table that resides in the same database as the original table, and it works properly.

I am connecting to a SQL server where the table is contained in a linked server Oracle database table. In the workflow activity, I have specified a custom timeout of 1200 seconds, on the SQL server the "Remote query timeout" is set to 0 which should = no timeout, and linked server properties Connection Timeout and Query Timeout have both been set to 1200. When I execute the same query in Management Studio, the results are returned in approximately 35 - 40 seconds. Yet, the query in Workflow is still returning the Time Our error at 30 seconds. Have I missed a setting somewhere?

0 0

Replies

replied on April 29, 2015 • Show version history

~~Workflow's query timeout is not currently customizable.~~

Edit: Each data activity has a property to set the timeout (in 9.1.1 or higher)

1 0

replied on November 24, 2015

The custom timeout setting doesn't seem to have an affect when you click the test link under the Custom Query. I set my custom timeout to 2 minutes because my query is to a linked AS400 server and very slow and with that I get results returned.

But the tokens generated by the columns returned by the Custom Query aren't available in the subsequent activities since the Test still times out after 30 seconds. So if I want to assign a returned value from the Custom Query to a field I have to assign it manually rather than being able to pick it.

In the end it did work.

1 0

replied on April 16, 2021

so the solution was to use the Custom Query activity rather than the Query activity?

0 0

replied on April 29, 2015

Hello Miruna, I am using Workflow 9.1.1.365 and have set the custom timeout?

0 0

replied on May 1, 2015

I'm not seeing it with Workflow 9.2. A query that fails with the default timeout works fine with a custom timeout.

0 0

You are not allowed to follow up in this post.

Question

Question

Workflow custom query time out

Replies

Sign in to reply to this post.