COM+ Transaction Timeout Threshold?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Largo SQL Tools - 05 Jan 2004 22:16 GMT

I'm running into a problem which may be related to a timeout occurring. I
have a app that is consuming a web service I wrote. The web service does a
large amount of database updates using COM+ transaction support. After
about 70 to 80 seconds I get an error stating the following: "Distributed
transaction completed. Either enlist this session in a new transaction or
the NULL transaction." I think this is coming from a timeout somewhere.
However, my database connection string has the Timeout property set to 5
minutes and I have my web service Timeout property set the same. My
question is this. Does COM+, by default, timeout after a certain period of
time? If so, how can I change this?

Thanks very much.

J.R.
Largo SQL Tools
The Finest Collection of SQL Tools Available
http://www.largosqltools.com

Reply to this Message

Florin Lazar [MSFT] - 06 Jan 2004 06:03 GMT

COM+ has a default transaction timeout of 60 seconds. You can use
Administrative Tools\Component Services to change it.
Right click on Console Root\Component Services\Computers\My Computer and
goto Options tab.

Regards,

Signature

Florin Lazar - Microsoft
http://weblogs.asp.net/florinlazar
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
This posting is provided "AS IS" with no warranties, and confers no rights.

> I'm running into a problem which may be related to a timeout occurring. I
> have a app that is consuming a web service I wrote. The web service does a
[quoted text clipped - 13 lines]
> The Finest Collection of SQL Tools Available
> http://www.largosqltools.com

Reply to this Message

Klaus H. Probst - 06 Jan 2004 07:46 GMT

Ideally you'd change this at the component level instead. Modifying the
behavior of the DTC timeout for the entire machine might be a problem if
other applications with different needs are running there as well.

Signature

____________________
Klaus H. Probst, MVP
http://www.vbbox.com/

> COM+ has a default transaction timeout of 60 seconds. You can use
> Administrative Tools\Component Services to change it.
[quoted text clipped - 21 lines]
> > The Finest Collection of SQL Tools Available
> > http://www.largosqltools.com

Reply to this Message

COM+ Transaction Timeout Threshold?

Free Magazines