472,993 Members | 1,852 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,993 software developers and data experts.

ASP.Net & COM+ transaction trouble on occasion


Hi everyone,

I'm running into a problem with my ASP.Net application. I've just created a
new aspx page which uses some new components of mine that inherit from
ServicedComponent and are designed to run under COM+.

This page works fine, unless I get fancy and hit my browser's refresh button
quickly, as a test. Then, what I see happen is the transactions pile up and
my ASP.Net "current requests" do the same. This happens even with two
requests in the ASP list. My browser just sits there.

After I hit 10 requests (I use WindowsXP, my own box as the test webserver
here) IIS says to come back later, it's full up.

Trouble is, later never arrives. Eventually I see my COM+ transactions
abort/timeout, but ASP.Net never kills the requests. I'm stuck at 10
requests until I do an IIS reset.

I've made plenty of ServicedComponents before, and this is the first time
I've seen this problem when refreshing the page quickly. My other pages
don't have this trouble. Nothing jumps out at me as to why this would be a
problem now, on this particular page. The SQL query run by my component is
a _little_ more difficult than a typical one, but that's just in the number
of rows returned. And again, if I don't go nuts on the refresh button it
works fine.

Has anyone seen this, or do you have any ideas what's going on? It's a
mystery to me. I'm using the 1.1 runtime, btw. XP Service Pack 2.

Some details, in case it helps: My business component has the
"AutoComplete" attribute set on its methods and its transaction settings are
set to Transaction.RequiresNew. It calls a data layer component that also
has AutoComplete set on its methods. Its transaction setting is
Transaction.Required. There are no exceptions being thrown, as far as I can
tell-- my exception handlers aren't logging anything.

Thanks for any and all advice!
Nov 19 '05 #1
1 1951
I suggest you check two things:

1) open COM+ MMC and check the MSTDC statistics, how many transactions have
been committe, aborted or in trouble.
2) open SQL Server MMC and check whether there are dead-locks, also the
physical open connections to database.

"Jim Bancroft" <as******@nowhere.com> wrote in message
news:u8*************@tk2msftngp13.phx.gbl...

Hi everyone,

I'm running into a problem with my ASP.Net application. I've just created a new aspx page which uses some new components of mine that inherit from
ServicedComponent and are designed to run under COM+.

This page works fine, unless I get fancy and hit my browser's refresh button quickly, as a test. Then, what I see happen is the transactions pile up and my ASP.Net "current requests" do the same. This happens even with two
requests in the ASP list. My browser just sits there.

After I hit 10 requests (I use WindowsXP, my own box as the test webserver
here) IIS says to come back later, it's full up.

Trouble is, later never arrives. Eventually I see my COM+ transactions
abort/timeout, but ASP.Net never kills the requests. I'm stuck at 10
requests until I do an IIS reset.

I've made plenty of ServicedComponents before, and this is the first time
I've seen this problem when refreshing the page quickly. My other pages
don't have this trouble. Nothing jumps out at me as to why this would be a problem now, on this particular page. The SQL query run by my component is a _little_ more difficult than a typical one, but that's just in the number of rows returned. And again, if I don't go nuts on the refresh button it
works fine.

Has anyone seen this, or do you have any ideas what's going on? It's a
mystery to me. I'm using the 1.1 runtime, btw. XP Service Pack 2.

Some details, in case it helps: My business component has the
"AutoComplete" attribute set on its methods and its transaction settings are set to Transaction.RequiresNew. It calls a data layer component that also
has AutoComplete set on its methods. Its transaction setting is
Transaction.Required. There are no exceptions being thrown, as far as I can tell-- my exception handlers aren't logging anything.

Thanks for any and all advice!


Nov 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Ray | last post by:
Hi I need to access an access db via php. My hosting provider is using php version 4.3.10 on a windows 2003 platform. I think that php was installed with the Plesk for windows package/control...
10
by: sean | last post by:
Is there a good module for sending out email? For a website that I am working on, I am writing a program that finds out which presenters have not yet confirmed their scheduled date and sends them...
4
by: Dan Avni | last post by:
I have a site that has been working for a few years now. the web site is using a DB Access DLL written in VB. the DB's connection string is passed to the DLL using the COM+ enable object...
7
by: Richard Gutery | last post by:
I have written a COM component who's purpose is to allow a user to change his Windows (NT/AD) password via a web page. Now the component works fine when I run it in VB 6, but not via the web page....
3
by: Tim Baur | last post by:
Hi guys. I'm new to ASP, but not Visual Basic. I recently find myself with a project that will involve a SQL Server / COM back end with an ASP front end. The system handles help desk type...
8
by: Z D | last post by:
Hello, I'm having a strange problem that is probably due to my lack of understanding of how threading & COM Interop works in a WinForms.NET application. Here's the situation: I have a 3rd...
8
by: Lloyd Dupont | last post by:
I just discovered a COM interface which provide some functionality I need. I know nothing of COM and read the documentation and will apply a slow trial and error process. In the documentation I...
11
by: Mike Towers | last post by:
Hi, The company I work for has a web site (IIS5) build using ASP and COM+ components which are written in VB6 and provide the business and database logic for the site. We would very much like...
2
by: Arif Khan | last post by:
I am currently working on .net 1.1 and want to use COM+ Transaction. Do I have to put assembly using COM+ transaction (specific class inheriting from ServicedComponent) in GAC? as per my...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
3
SueHopson
by: SueHopson | last post by:
Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.