http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : How to increase timeout? Wed, 10 Jun 2026 17:40:14 -700 Sat, 24 Jan 2009 04:37:08 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1066 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=1066&PID=3828#3828 Author: lokheed
Subject: 1066
Posted: 24-Jan-2009 at 4:37am

So as it turns out, I'm a moron. ;-)

I had been looking at the serverDetectTimeoutMilliseconds setting in the .ibconfig, and then somehow conflated that with the CommandTimout in terms of them both being in milliseconds.  As soon as a dropped the CommandTimeout value down to 180 seconds instead of 180000 it worked just fine.
]]> Sat, 24 Jan 2009 04:37:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1066&PID=3828#3828 http://www.ideablade.com/forum/forum_posts.asp?TID=1066&PID=3827#3827 Author: lokheed
Subject: 1066
Posted: 23-Jan-2009 at 3:31pm

I have a WCF BOS running under IIS, connecting to an MS SQL database.  I have a case were the client is calling the BOS with a StoredProcRdbQuery that can potentially take up to two minutes to run.  In the client code I set the query CommandTimout to 180000 milliseconds, but the query is still timing out.  When I look at the DebugLog.xml on the BOS I see the initial StoredProcRdbQuery::Fetch, and then one minute and one second later I see a second identical call.  Ultimately the BOS throws a timeout error back the client.

How can in increase the timeout for this call, so that the BOS will give the stored procedure something like 3 minutes to run before failing out?  What am I missing?
]]> Fri, 23 Jan 2009 15:31:49 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1066&PID=3827#3827