topic ODBC Business Object Timeouts in Product Forum

ODBC Business Object Timeouts

AlexHowarth — Thu, 23 Oct 2014 14:41:00 GMT

I'm using the ODBC business object to execute an SQL query, however I am experiencing a high number of timeouts. Some of the queries will take a while to execute. I've looked but cannot see a way to increase the timeouts (I think they're currently set to about 30 seconds). Does anybody know if/how it can be done? Thanks

Hi Alex,

ChrisSneddon — Fri, 24 Oct 2014 13:25:00 GMT

Hi Alex, Microsoft offer two solutions to extending the default ODBC timeout. One of them uses a timeout parameter that can be set when you open the connection to the database. Go to http://support.microsoft.com/kb/153756 for examples.

Thanks Chris

AlexHowarth — Tue, 28 Oct 2014 14:02:00 GMT

Thanks Chris I've created a new page in the BO to set the timeout parameter and have had to add some global code to the BO as a result. As VB is not my strongest area, would it be possible to have one of you guys cast an eye over it for me?

Hi Alex,

ChrisSneddon — Thu, 30 Oct 2014 11:36:00 GMT

Hi Alex, Email me your BO and I'll give it a quick sanity check. chris.sneddon@blueprism.com

Thanks for your help Chris,

AlexHowarth — Wed, 05 Nov 2014 15:43:00 GMT

Thanks for your help Chris, managed to get it working in the end!

RE: Thanks for your help Chris,

SohanaKamat — Thu, 27 Feb 2020 14:22:00 GMT

Hi Alex,Chris.

I am trying to use the blue prism object provided by blueprism team to integrate with Hadoop.
I am getting an error in the same are "ERROR [HYT00] [Cloudera][Hardy] (72) Query execution timeout expired."
I can use simple queries like "select * from tb1 limit 100", but the moment I use a WHERE clause it just throws the above error.
I timed the same Query with WHERE clause on Hue platform and it does not take more than 60 seconds
I tried commandtimeout the issue still seems to persist.
I tried with increment of values upto 30 minutes at the end of which the query was still processing
@Chris Sneddon / @AlexHowarth can you help me out with the same.

------------------------------
Sohana Kamat
RPA Consultant
L&T Infotech
Asia/Kolkata
------------------------------