topic RE: Timeout reading data from sql database in Product Forum

Timeout reading data from sql database

KristianHolm1 — Wed, 23 Sep 2020 08:07:00 GMT

Hi Blueprism team I have an errormessage when trying to read data from sql database with 130.000 records to a collection

object: Get Collection

Errormessage
Execution timeout has expired. The timeout period expired before the operation was performed or the server did not respond.

Working fine with data from sql database with 90.000 records.

Is there a limit reading records from sql database.?

greetings Kristian

------------------------------
Kristian Holm
RPA programmer
PenSam (Pension Company)
Copenhagen Denmark
------------------------------

RE: Timeout reading data from sql database

NicholasZejdlik — Wed, 23 Sep 2020 13:17:00 GMT

Execution timeout expired means that the query took too long to complete. Reading 90,000 records may have run under that time whereas 130,000 records pushed it to the timeout limit. The Data - SQL Server is using a SqlCommand object to run the query, which has a default timeout of 30 seconds. I don't believe the Data - SQL Server object has a way to change the timeout (I could be wrong, I have an old version of it).

What I would suggest is making a copy of the Data - SQL Server object and include a custom timeout option.

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------

RE: Timeout reading data from sql database

gmarquez — Wed, 23 Sep 2020 15:58:00 GMT

Hi Kristian,

Nicholas has provided a good answer about why you are getting your timeout error. There is no hard limit on the amount of data we can query because it all depends on the amount of data included in the query such as row/column counts and amount of data in each.

We do have a way to increase the timeout and it is documented here: https://portal.blueprism.com/customer-support/support-center#/path/Operational-Support/Performance/Database-Management/1360595772/Why-do-I-get-Execution-Timeout-Expired-The-timeout-period-elapsed-prior-to-completion-of-the-operation-or-the-server-is-not-responding-when-connecting-with-OLEDB.htm

I would advise to not make this an unlimited amount of time because then you could have an issue where the query is hung and your process will keep running until someone intervenes.

------------------------------
Gabe Marquez
Technical Support Engineer
Blue Prism
------------------------------