COM+ times out after 30 seconds.

[Kiran Math]

I have a web service, that calls a COM + ( Queued).
The COM+ runs a stored procedure in Sql Server. Now this strored procedure
is to run for 6 hrs or so.

I have made a dumy StoredProcedure with WAITFOR DELAY statment in it.
If i increase the WAITFOR DELAY to 30 seconds the com+ times out and dies on
its own.

What should I do that the com+ does not time out/
Thank you

 

[Arthur Nesterovsky]

Hi,

I have a web service, that calls a COM + ( Queued).
The COM+ runs a stored procedure in Sql Server. Now this strored procedure
is to run for 6 hrs or so.

I have made a dumy StoredProcedure with WAITFOR DELAY statment in it.
If i increase the WAITFOR DELAY to 30 seconds the com+ times out and dies on
its own.

Try to set "Server Process Shutdown" property to "Leave running when idle".
You can do this from "Component Services" MMC snap-in in "Administrative
Tools".
You have to register and then select your COM+ application and open its
properties.
Then select "Advanced" tab. You will see there the mentioned above property.
______________________________
With best wishes, Arthur Nesterovsky
Please visit my home page:
http://www.nesterovsky-bros.com

 

[Dan Rogers]

Hi Arthur,

Right now there is no easy way to do an "background SQL query". Setting up
app timeout isn't likely to solve the issue you're seeing, as the COM
subsystem is detecting a hung response and trying to clean up. When we
implemented our UDDI implementation, we ran into the need to do this kind
of batch operation, and found that the solution that worked best was to
have the component make a call to Sql Agent to kick off a job, and then if
you need status, check back on the job periodically. In your case, I
believe I saw that you wanted the user notified at the end - so your stored
procedure should end by notifying the original requester by email (somthing
passed via web service parameter and then to com+ parameter and then....

In the next version of SQL Server (code named Yukon), there is a feature
called Async Query that will greatly simplify this.

I hope this helps

Dan Rogers
Microsoft Corporation
--------------------