How to increase timeout?
Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=1066
Printed Date: 29-Apr-2025 at 7:05am
Topic: How to increase timeout?
Posted By: lokheed
Subject: How to increase timeout?
Date 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?
|
Replies:
Posted By: lokheed
Date 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.
|
|