New Posts New Posts RSS Feed: How to increase timeout?
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

How to increase timeout?
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
lokheed View Drop Down
Newbie
Newbie


Joined: 07-Jun-2008
Posts: 4 		Post Options Post Options   Quote lokheed Quote  Post ReplyReply Direct Link To This Post Topic: How to increase timeout?
    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?
Back to Top
lokheed View Drop Down
Newbie
Newbie


Joined: 07-Jun-2008
Posts: 4 		Post Options Post Options   Quote lokheed Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down