Re: WebService method timing out after exactly 3:00 hours

This problem has been occurring on our production server. Last night
before I left work I created a similar scenario on our QA server which
uses a day-old copy of our production data. It ran for almost 6 hours
before dying with a SQL Command Timeout error on a stored procedure that
does a bulk insert SELECT INTO. I'm not surprised since the QA SQL
Server is not as powerful as the production SQL Server and  I can change
the CommandTimeout for that.

I'm going to ask our server admins to figure out what is different
between the two servers, configuration-wise.

Bob


> -----Original Message-----
> From: Discussion of building .NET applications targeted for 
> the Web [mailto:[email protected]] On Behalf Of 
> Ainsley, Robert, ISD
> Sent: Thursday, May 17, 2007 7:44 AM
> To: [email protected]
> Subject: Re: [DOTNET-WEB] WebService method timing out after 
> exactly 3:00 hours
> 
> I'm replying to both Adwait and Shawn because Shawn's reply 
> did not reach me.
>  
> 
> > -----Original Message-----
> > From: Discussion of building .NET applications targeted for the Web 
> > [mailto:[email protected]] On Behalf Of Adwait Ullal
> > Sent: Wednesday, May 16, 2007 4:26 PM
> > To: [email protected]
> > Subject: Re: [DOTNET-WEB] WebService method timing out 
> after exactly 
> > 3:00 hours
> > 
> > Perhaps asnyc mode or BizTalk would be of help?
> > 
> 
> It times out after 3 hours when I run it in async mode. When 
> the user triggers an update from the web app the method is 
> invoked async. When the console app processes the scenarios, 
> it's done in sync mode so the console app can log any 
> failures and avoid overloading SQL Server with multiple 
> scenarios running at once.
> 
> Bob
> 
> > - Adwait
> > 
> > --
> > Adwait Ullal
> > 
> > e: mailto:[email protected]
> > w: http://www.adwait.com
> > l: http://www.linkedin.com/in/adwait
> > j: http://finance.groups.yahoo.com/group/AdwaitsDotNetJobs
> > 
> > On 5/16/07, Shawn Wildermuth (MVP)
> > <[email protected]> wrote:
> > >
> > > Ummmm....to ask the obvious question, why do you have a 
> webservice 
> > > that runs over 3 hours?
> 
> Because the users like the tool so much that they are using 
> it to do things they never dreamed of doing before, resulting 
> in a sudden quadrupling overnight of the amount of data that 
> must be processed. It's actually a result of upper management 
> needing to evaluate a new business model as a result of a merger.
> 
> The method in question is invoked from a web app on demand 
> during the day by the users and automatically at night by a 
> console app, after the database has been refreshed with new 
> data. It implements 'What if?'
> functionality so the users will define various scenarios and 
> the method is invoked for each scenario. After the database 
> has been refreshed each night with new data, the console 
> application is run to update the results for each scenario 
> prior to the users arrival in the morning. It takes so much 
> time because it involves slicing and dicing a lot of data on 
> a SQL Server that has 12GB RAM and 4 dual core processors.
> 
> Given these new data volumes, a better solution would involve 
> MessageQueue and a Windows Service that creates worker 
> processes to process the items in the queue, but the original 
> business requirements didn't justify such a solution.
> 
> The bottom line is that I need to find out what is causing 
> the 3 hour limit and get around it until we can come up with 
> a long term solution to this increased volume.
> 
> Bob
> > >
> > > Thanks,
> > >
> > > Shawn Wildermuth
> > > http://adoguy.com
> > > http://wildermuthconsulting.com
> > > Microsoft MVP (C#), MCSD.NET, Author and Speaker
> > >
> > >


*****************************************************************************
If you are not the intended recipient of this e-mail, please notify 
the sender immediately. The contents of this e-mail do not amend 
any existing disclosures or agreements unless expressly stated.
*****************************************************************************

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com