W/2003, VS/2003, SQL2000 and ThreadAbortException

[David Waz...]

Moved an app from W/2000 Asp V1.0 to
W/2003, VS/2003, ASPV 1.1

Page runs a long job, uploading 2 large fixed length files
(300,000 rows) into SQL database. A process is run
against the data, and altered flat-files produced.

The job aborts at EXACTLY 105 seconds (1 min, 45 seconds)
regardless of WHERE in the process we are - could be DB
read, DB write, string manipulation - whatever.

I've checked all Sql Server, Machine.Config, Web.Config
and IIS settings - no joy... Researched everything I
could find in Google/Microsoft.

Workstation: dual 2.66 ghz xeon w/ 2 gig memory, local
IIS, local SQL server.

HELP!

Thread was being
aborted.System.Threading.ThreadAbortException: Thread was
being aborted.
at System.Data.Common.DbDataAdapter.Update(DataRow[]
dataRows, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataTable
dataTable)
at Maple.PickPro.com.modDb.ExecSqlInsert(DataTable
sqlTable, String SelectCmd) in c:\hosted
sites\Maple\modDb.vb:line 73
at Maple.PickPro.com.BmcSortProcessSql.ParseDetailFil e
() in c:\hosted sites\Maple\BmcSortProcessSql.vb:line 245
at Maple.PickPro.com.bmcSort.ProcessFiles() in
c:\hosted sites\Maple\bmcSort.aspx.vb:line 219
at Maple.PickPro.com.bmcSort.btnProcess_Click(Object
sender, EventArgs e) in c:\hosted
sites\Maple\bmcSort.aspx.vb:line 1047/3/2003 2:52:45 PM -
7/3/2003 2:54:31 PM 105

[Yan-Hong Huang[MSFT]]

Hello David,

I have searched through our internal database and consulted some enginneers
on this issue. However, we didn't have clear solution yet without any
further information. In order to resolve this kind of issue, we may need to
create a repro sample on it and then troubleshoo the sample to isolate the
problem.

So resolving this problem is going to take 1:1 support, which is beyond the
scope of newsgroup support, I suggest that you use one of the support
incidents included with your MSDN subscription and create a standard
support incident to address the problem. If this is indeed a product
issue, there the incident will not be used up by the call.

If you have any more concerns, please post here. Thanks very much for your
understanding.

Best regards,
yhhuang
VS.NET, Visual C++
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
Got .Net? [url]http://www.gotdotnet.com[/url]
--------------------
!Content-Class: urn:content-classes:message
!From: "David Waz..." <dlw@pickpro.com>
!Sender: "David Waz..." <dlw@pickpro.com>
!Subject: W/2003, VS/2003, SQL2000 and ThreadAbortException
!Date: Thu, 3 Jul 2003 12:55:42 -0700
!Lines: 39
!Message-ID: <038301c3419d$1592f7d0$a301280a@phx.gbl>
!MIME-Version: 1.0
!Content-Type: text/plain;
! charset="iso-8859-1"
!Content-Transfer-Encoding: 7bit
!X-Newsreader: Microsoft CDO for Windows 2000
!X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
!Thread-Index: AcNBnRWQN+ElHO5BRlyRNrogAgZ13Q==
!Newsgroups: microsoft.public.dotnet.framework.aspnet
!Path: cpmsftngxa09.phx.gbl
!Xref: cpmsftngxa09.phx.gbl microsoft.public.dotnet.framework.aspnet:32175
!NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
!X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
!
!Moved an app from W/2000 Asp V1.0 to
!W/2003, VS/2003, ASPV 1.1
!
!Page runs a long job, uploading 2 large fixed length files
!(300,000 rows) into SQL database. A process is run
!against the data, and altered flat-files produced.
!
!The job aborts at EXACTLY 105 seconds (1 min, 45 seconds)
!regardless of WHERE in the process we are - could be DB
!read, DB write, string manipulation - whatever.
!
!I've checked all Sql Server, Machine.Config, Web.Config
!and IIS settings - no joy... Researched everything I
!could find in Google/Microsoft.
!
!Workstation: dual 2.66 ghz xeon w/ 2 gig memory, local
!IIS, local SQL server.
!
!HELP!
!
!Thread was being
!aborted.System.Threading.ThreadAbortException: Thread was
!being aborted.
! at System.Data.Common.DbDataAdapter.Update(DataRow[]
!dataRows, DataTableMapping tableMapping)
! at System.Data.Common.DbDataAdapter.Update(DataTable
!dataTable)
! at Maple.PickPro.com.modDb.ExecSqlInsert(DataTable
!sqlTable, String SelectCmd) in c:\hosted
!sites\Maple\modDb.vb:line 73
! at Maple.PickPro.com.BmcSortProcessSql.ParseDetailFil e
!() in c:\hosted sites\Maple\BmcSortProcessSql.vb:line 245
! at Maple.PickPro.com.bmcSort.ProcessFiles() in
!c:\hosted sites\Maple\bmcSort.aspx.vb:line 219
! at Maple.PickPro.com.bmcSort.btnProcess_Click(Object
!sender, EventArgs e) in c:\hosted
!sites\Maple\bmcSort.aspx.vb:line 1047/3/2003 2:52:45 PM -
!7/3/2003 2:54:31 PM 105
!
!

[David Waz...]

Yup, I figured...

and it's still kickin' my butt...

We were using the Universe database from IBM when the problem started after
a combination of moving to W/2003 VS/2003 on the development machine and
..Net V1.1 on development and server at the same time the end-user files went
from 5 or 6 mb files to 100+mb files.

So, we THINK the issue started with the new environment, but perhaps the
smaller files of the past never forced us past the magic 105 seconds...

Still aborting threads like nobody's business...
david


"Yan-Hong Huang[MSFT]" <yhhuang@online.microsoft.com> wrote in message
news:M85qvnSRDHA.2140@cpmsftngxa09.phx.gbl...

> Hello David,
>
> I have searched through our internal database and consulted some

enginneers

> on this issue. However, we didn't have clear solution yet without any
> further information. In order to resolve this kind of issue, we may need

to

> create a repro sample on it and then troubleshoo the sample to isolate the
> problem.
>
> So resolving this problem is going to take 1:1 support, which is beyond

the

> scope of newsgroup support, I suggest that you use one of the support
> incidents included with your MSDN subscription and create a standard
> support incident to address the problem. If this is indeed a product
> issue, there the incident will not be used up by the call.
>
> If you have any more concerns, please post here. Thanks very much for your
> understanding.
>
> Best regards,
> yhhuang
> VS.NET, Visual C++
> Microsoft
>
> This posting is provided "AS IS" with no warranties, and confers no

rights.

> Got .Net? [url]http://www.gotdotnet.com[/url]
> --------------------
> !Content-Class: urn:content-classes:message
> !From: "David Waz..." <dlw@pickpro.com>
> !Sender: "David Waz..." <dlw@pickpro.com>
> !Subject: W/2003, VS/2003, SQL2000 and ThreadAbortException
> !Date: Thu, 3 Jul 2003 12:55:42 -0700
> !Lines: 39
> !Message-ID: <038301c3419d$1592f7d0$a301280a@phx.gbl>
> !MIME-Version: 1.0
> !Content-Type: text/plain;
> ! charset="iso-8859-1"
> !Content-Transfer-Encoding: 7bit
> !X-Newsreader: Microsoft CDO for Windows 2000
> !X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
> !Thread-Index: AcNBnRWQN+ElHO5BRlyRNrogAgZ13Q==
> !Newsgroups: microsoft.public.dotnet.framework.aspnet
> !Path: cpmsftngxa09.phx.gbl
> !Xref: cpmsftngxa09.phx.gbl microsoft.public.dotnet.framework.aspnet:32175
> !NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
> !X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
> !
> !Moved an app from W/2000 Asp V1.0 to
> !W/2003, VS/2003, ASPV 1.1
> !
> !Page runs a long job, uploading 2 large fixed length files
> !(300,000 rows) into SQL database. A process is run
> !against the data, and altered flat-files produced.
> !
> !The job aborts at EXACTLY 105 seconds (1 min, 45 seconds)
> !regardless of WHERE in the process we are - could be DB
> !read, DB write, string manipulation - whatever.
> !
> !I've checked all Sql Server, Machine.Config, Web.Config
> !and IIS settings - no joy... Researched everything I
> !could find in Google/Microsoft.
> !
> !Workstation: dual 2.66 ghz xeon w/ 2 gig memory, local
> !IIS, local SQL server.
> !
> !HELP!
> !
> !Thread was being
> !aborted.System.Threading.ThreadAbortException: Thread was
> !being aborted.
> ! at System.Data.Common.DbDataAdapter.Update(DataRow[]
> !dataRows, DataTableMapping tableMapping)
> ! at System.Data.Common.DbDataAdapter.Update(DataTable
> !dataTable)
> ! at Maple.PickPro.com.modDb.ExecSqlInsert(DataTable
> !sqlTable, String SelectCmd) in c:\hosted
> !sites\Maple\modDb.vb:line 73
> ! at Maple.PickPro.com.BmcSortProcessSql.ParseDetailFil e
> !() in c:\hosted sites\Maple\BmcSortProcessSql.vb:line 245
> ! at Maple.PickPro.com.bmcSort.ProcessFiles() in
> !c:\hosted sites\Maple\bmcSort.aspx.vb:line 219
> ! at Maple.PickPro.com.bmcSort.btnProcess_Click(Object
> !sender, EventArgs e) in c:\hosted
> !sites\Maple\bmcSort.aspx.vb:line 1047/3/2003 2:52:45 PM -
> !7/3/2003 2:54:31 PM 105
> !
> !
>

[Yan-Hong Huang[MSFT]]

Hello David,

As you mentioned, the problem resides in a big project. In order to isolate the problem, we may need to check config files(I
knew you have checked before), analyze cramp dump files. So it is better that there is one support engineer to work with
you specifically. That is why I suggest you submit a service request for it.

Thanks very much for your understanding. Please let me know if you have any more concerns.

Best regards,
yhhuang
VS.NET, Visual C++
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
Got .Net? [url]http://www.gotdotnet.com[/url]
--------------------
!From: "David Waz..." <dlw@pickpro.com>
!Newsgroups: microsoft.public.dotnet.framework.aspnet
!References: <038301c3419d$1592f7d0$a301280a@phx.gbl> <M85qvnSRDHA.2140@cpmsftngxa09.phx.gbl>
!Subject: Re: W/2003, VS/2003, SQL2000 and ThreadAbortException
!Lines: 110
!X-Newsreader: Microsoft Outlook Express 6.00.3790.0
!X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
!Message-ID: <G2DOa.16$Pb4.9@newssvr24.news.prodigy.com>
!NNTP-Posting-Host: 65.23.4.76
!X-Complaints-To: [email]abuse@prodigy.net[/email]
!X-Trace: newssvr24.news.prodigy.com 1057684774 ST000 65.23.4.76 (Tue, 08 Jul 2003 13:19:34 EDT)
!NNTP-Posting-Date: Tue, 08 Jul 2003 13:19:34 EDT
!Organization: SBC [url]http://yahoo.sbc.com[/url]
!X-UserInfo1: TSU[@I_A\S@[R]LY]JM\_TLA^R_FBL@MAHU^_BAMEH]TCDYG^WHKAH_[JTXDX_KI\VB]JBVMS^YT_G
[CZVWAOS\DHFWEH]@KGXYHB\_CMDSFABP^J[AHHRKARLE_JDBLJ\XA[JRMEI]MGJSPB\Y]^KG\@S^@VQKI_Q
[G@@_ACSARASDEFLBJ]S\GFNTUAVBL
!Date: Tue, 08 Jul 2003 17:19:34 GMT
!Path: cpmsftngxa09.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed 00.sul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!
news.maxwell.syr.edu!wn14feed!worldnet.att.net!207 .115.63.142!prodigy.com!newsmst01.news.prodigy.com !prodigy.com!
postmaster.news.prodigy.com!newssvr24.news.prodigy .com.POSTED!df277b9c!not-for-mail
!Xref: cpmsftngxa09.phx.gbl microsoft.public.dotnet.framework.aspnet:33071
!X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
!
!Yup, I figured...
!
!and it's still kickin' my butt...
!
!We were using the Universe database from IBM when the problem started after
!a combination of moving to W/2003 VS/2003 on the development machine and
!.Net V1.1 on development and server at the same time the end-user files went
!from 5 or 6 mb files to 100+mb files.
!
!So, we THINK the issue started with the new environment, but perhaps the
!smaller files of the past never forced us past the magic 105 seconds...
!
!Still aborting threads like nobody's business...
!david
!
!
!"Yan-Hong Huang[MSFT]" <yhhuang@online.microsoft.com> wrote in message
!news:M85qvnSRDHA.2140@cpmsftngxa09.phx.gbl...
!> Hello David,
!>
!> I have searched through our internal database and consulted some
!enginneers
!> on this issue. However, we didn't have clear solution yet without any
!> further information. In order to resolve this kind of issue, we may need
!to
!> create a repro sample on it and then troubleshoo the sample to isolate the
!> problem.
!>
!> So resolving this problem is going to take 1:1 support, which is beyond
!the
!> scope of newsgroup support, I suggest that you use one of the support
!> incidents included with your MSDN subscription and create a standard
!> support incident to address the problem. If this is indeed a product
!> issue, there the incident will not be used up by the call.
!>
!> If you have any more concerns, please post here. Thanks very much for your
!> understanding.
!>
!> Best regards,
!> yhhuang
!> VS.NET, Visual C++
!> Microsoft
!>
!> This posting is provided "AS IS" with no warranties, and confers no
!rights.
!> Got .Net? [url]http://www.gotdotnet.com[/url]
!> --------------------
!> !Content-Class: urn:content-classes:message
!> !From: "David Waz..." <dlw@pickpro.com>
!> !Sender: "David Waz..." <dlw@pickpro.com>
!> !Subject: W/2003, VS/2003, SQL2000 and ThreadAbortException
!> !Date: Thu, 3 Jul 2003 12:55:42 -0700
!> !Lines: 39
!> !Message-ID: <038301c3419d$1592f7d0$a301280a@phx.gbl>
!> !MIME-Version: 1.0
!> !Content-Type: text/plain;
!> ! charset="iso-8859-1"
!> !Content-Transfer-Encoding: 7bit
!> !X-Newsreader: Microsoft CDO for Windows 2000
!> !X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
!> !Thread-Index: AcNBnRWQN+ElHO5BRlyRNrogAgZ13Q==
!> !Newsgroups: microsoft.public.dotnet.framework.aspnet
!> !Path: cpmsftngxa09.phx.gbl
!> !Xref: cpmsftngxa09.phx.gbl microsoft.public.dotnet.framework.aspnet:32175
!> !NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
!> !X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
!> !
!> !Moved an app from W/2000 Asp V1.0 to
!> !W/2003, VS/2003, ASPV 1.1
!> !
!> !Page runs a long job, uploading 2 large fixed length files
!> !(300,000 rows) into SQL database. A process is run
!> !against the data, and altered flat-files produced.
!> !
!> !The job aborts at EXACTLY 105 seconds (1 min, 45 seconds)
!> !regardless of WHERE in the process we are - could be DB
!> !read, DB write, string manipulation - whatever.
!> !
!> !I've checked all Sql Server, Machine.Config, Web.Config
!> !and IIS settings - no joy... Researched everything I
!> !could find in Google/Microsoft.
!> !
!> !Workstation: dual 2.66 ghz xeon w/ 2 gig memory, local
!> !IIS, local SQL server.
!> !
!> !HELP!
!> !
!> !Thread was being
!> !aborted.System.Threading.ThreadAbortException: Thread was
!> !being aborted.
!> ! at System.Data.Common.DbDataAdapter.Update(DataRow[]
!> !dataRows, DataTableMapping tableMapping)
!> ! at System.Data.Common.DbDataAdapter.Update(DataTable
!> !dataTable)
!> ! at Maple.PickPro.com.modDb.ExecSqlInsert(DataTable
!> !sqlTable, String SelectCmd) in c:\hosted
!> !sites\Maple\modDb.vb:line 73
!> ! at Maple.PickPro.com.BmcSortProcessSql.ParseDetailFil e
!> !() in c:\hosted sites\Maple\BmcSortProcessSql.vb:line 245
!> ! at Maple.PickPro.com.bmcSort.ProcessFiles() in
!> !c:\hosted sites\Maple\bmcSort.aspx.vb:line 219
!> ! at Maple.PickPro.com.bmcSort.btnProcess_Click(Object
!> !sender, EventArgs e) in c:\hosted
!> !sites\Maple\bmcSort.aspx.vb:line 1047/3/2003 2:52:45 PM -
!> !7/3/2003 2:54:31 PM 105
!> !
!> !
!>
!
!
!

[David Waz...]

We have an active call open with M.S.
I'll post the answer, if it every is answered! :-0

I'm supprised there aren't more posts about this - must be me!


"Yan-Hong Huang[MSFT]" <yhhuang@online.microsoft.com> wrote in message
news:pBnOW84RDHA.1636@cpmsftngxa06.phx.gbl...

> Hello David,
>
> As you mentioned, the problem resides in a big project. In order to

isolate the problem, we may need to check config files(I

> knew you have checked before), analyze cramp dump files. So it is better

that there is one support engineer to work with

> you specifically. That is why I suggest you submit a service request for

it.

>
> Thanks very much for your understanding. Please let me know if you have

any more concerns.

>
> Best regards,
> yhhuang
> VS.NET, Visual C++
> Microsoft
>
> This posting is provided "AS IS" with no warranties, and confers no

rights.

> Got .Net? [url]http://www.gotdotnet.com[/url]
> --------------------
> !From: "David Waz..." <dlw@pickpro.com>
> !Newsgroups: microsoft.public.dotnet.framework.aspnet
> !References: <038301c3419d$1592f7d0$a301280a@phx.gbl>

<M85qvnSRDHA.2140@cpmsftngxa09.phx.gbl>

> !Subject: Re: W/2003, VS/2003, SQL2000 and ThreadAbortException
> !Lines: 110
> !X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> !X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> !Message-ID: <G2DOa.16$Pb4.9@newssvr24.news.prodigy.com>
> !NNTP-Posting-Host: 65.23.4.76
> !X-Complaints-To: [email]abuse@prodigy.net[/email]
> !X-Trace: newssvr24.news.prodigy.com 1057684774 ST000 65.23.4.76 (Tue, 08

Jul 2003 13:19:34 EDT)

> !NNTP-Posting-Date: Tue, 08 Jul 2003 13:19:34 EDT
> !Organization: SBC [url]http://yahoo.sbc.com[/url]
> !X-UserInfo1:

TSU[@I_A\S@[R]LY]JM\_TLA^R_FBL@MAHU^_BAMEH]TCDYG^WHKAH_[JTXDX_KI\VB]JBVMS^YT
_G

>

[CZVWAOS\DHFWEH]@KGXYHB\_CMDSFABP^J[AHHRKARLE_JDBLJ\XA[JRMEI]MGJSPB\Y]^KG\@S
^@VQKI_Q

> [G@@_ACSARASDEFLBJ]S\GFNTUAVBL
> !Date: Tue, 08 Jul 2003 17:19:34 GMT
> !Path:

cpmsftngxa09.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed 00.sul.t-online.de!t-onlin
e.de!news-spur1.maxwell.syr.edu!

>

news.maxwell.syr.edu!wn14feed!worldnet.att.net!207 .115.63.142!prodigy.com!ne
wsmst01.news.prodigy.com!prodigy.com!

>

postmaster.news.prodigy.com!newssvr24.news.prodigy .com.POSTED!df277b9c!not-f
or-mail

> !Xref: cpmsftngxa09.phx.gbl microsoft.public.dotnet.framework.aspnet:33071
> !X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
> !
> !Yup, I figured...
> !
> !and it's still kickin' my butt...
> !
> !We were using the Universe database from IBM when the problem started

after

> !a combination of moving to W/2003 VS/2003 on the development machine and
> !.Net V1.1 on development and server at the same time the end-user files

went

> !from 5 or 6 mb files to 100+mb files.
> !
> !So, we THINK the issue started with the new environment, but perhaps the
> !smaller files of the past never forced us past the magic 105 seconds...
> !
> !Still aborting threads like nobody's business...
> !david
> !
> !
> !"Yan-Hong Huang[MSFT]" <yhhuang@online.microsoft.com> wrote in message
> !news:M85qvnSRDHA.2140@cpmsftngxa09.phx.gbl...
> !> Hello David,
> !>
> !> I have searched through our internal database and consulted some
> !enginneers
> !> on this issue. However, we didn't have clear solution yet without any
> !> further information. In order to resolve this kind of issue, we may

need

> !to
> !> create a repro sample on it and then troubleshoo the sample to isolate

the

> !> problem.
> !>
> !> So resolving this problem is going to take 1:1 support, which is beyond
> !the
> !> scope of newsgroup support, I suggest that you use one of the support
> !> incidents included with your MSDN subscription and create a standard
> !> support incident to address the problem. If this is indeed a product
> !> issue, there the incident will not be used up by the call.
> !>
> !> If you have any more concerns, please post here. Thanks very much for

your

> !> understanding.
> !>
> !> Best regards,
> !> yhhuang
> !> VS.NET, Visual C++
> !> Microsoft
> !>
> !> This posting is provided "AS IS" with no warranties, and confers no
> !rights.
> !> Got .Net? [url]http://www.gotdotnet.com[/url]
> !> --------------------
> !> !Content-Class: urn:content-classes:message
> !> !From: "David Waz..." <dlw@pickpro.com>
> !> !Sender: "David Waz..." <dlw@pickpro.com>
> !> !Subject: W/2003, VS/2003, SQL2000 and ThreadAbortException
> !> !Date: Thu, 3 Jul 2003 12:55:42 -0700
> !> !Lines: 39
> !> !Message-ID: <038301c3419d$1592f7d0$a301280a@phx.gbl>
> !> !MIME-Version: 1.0
> !> !Content-Type: text/plain;
> !> ! charset="iso-8859-1"
> !> !Content-Transfer-Encoding: 7bit
> !> !X-Newsreader: Microsoft CDO for Windows 2000
> !> !X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
> !> !Thread-Index: AcNBnRWQN+ElHO5BRlyRNrogAgZ13Q==
> !> !Newsgroups: microsoft.public.dotnet.framework.aspnet
> !> !Path: cpmsftngxa09.phx.gbl
> !> !Xref: cpmsftngxa09.phx.gbl

microsoft.public.dotnet.framework.aspnet:32175

> !> !NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
> !> !X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
> !> !
> !> !Moved an app from W/2000 Asp V1.0 to
> !> !W/2003, VS/2003, ASPV 1.1
> !> !
> !> !Page runs a long job, uploading 2 large fixed length files
> !> !(300,000 rows) into SQL database. A process is run
> !> !against the data, and altered flat-files produced.
> !> !
> !> !The job aborts at EXACTLY 105 seconds (1 min, 45 seconds)
> !> !regardless of WHERE in the process we are - could be DB
> !> !read, DB write, string manipulation - whatever.
> !> !
> !> !I've checked all Sql Server, Machine.Config, Web.Config
> !> !and IIS settings - no joy... Researched everything I
> !> !could find in Google/Microsoft.
> !> !
> !> !Workstation: dual 2.66 ghz xeon w/ 2 gig memory, local
> !> !IIS, local SQL server.
> !> !
> !> !HELP!
> !> !
> !> !Thread was being
> !> !aborted.System.Threading.ThreadAbortException: Thread was
> !> !being aborted.
> !> ! at System.Data.Common.DbDataAdapter.Update(DataRow[]
> !> !dataRows, DataTableMapping tableMapping)
> !> ! at System.Data.Common.DbDataAdapter.Update(DataTable
> !> !dataTable)
> !> ! at Maple.PickPro.com.modDb.ExecSqlInsert(DataTable
> !> !sqlTable, String SelectCmd) in c:\hosted
> !> !sites\Maple\modDb.vb:line 73
> !> ! at Maple.PickPro.com.BmcSortProcessSql.ParseDetailFil e
> !> !() in c:\hosted sites\Maple\BmcSortProcessSql.vb:line 245
> !> ! at Maple.PickPro.com.bmcSort.ProcessFiles() in
> !> !c:\hosted sites\Maple\bmcSort.aspx.vb:line 219
> !> ! at Maple.PickPro.com.bmcSort.btnProcess_Click(Object
> !> !sender, EventArgs e) in c:\hosted
> !> !sites\Maple\bmcSort.aspx.vb:line 1047/3/2003 2:52:45 PM -
> !> !7/3/2003 2:54:31 PM 105
> !> !
> !> !
> !>
> !
> !
> !
>
>

[Yan-Hong Huang[MSFT]]

Hello David,

First of all, thanks very much for your understanding. :)

The question is complex. I think that is why you can't find more posts on it. In fact, I did a quick research on it to see if I could
find a simliar report and so to provide you some useful information. But no luck. So I suggest you to work with MS support
engineer.

Best regards,
yhhuang
VS.NET, Visual C++
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
Got .Net? [url]http://www.gotdotnet.com[/url]
--------------------
!From: "David Waz..." <dlw@pickpro.com>
!Newsgroups: microsoft.public.dotnet.framework.aspnet
!References: <038301c3419d$1592f7d0$a301280a@phx.gbl> <M85qvnSRDHA.2140@cpmsftngxa09.phx.gbl> <G2DOa.16
$Pb4.9@newssvr24.news.prodigy.com> <pBnOW84RDHA.1636@cpmsftngxa06.phx.gbl>
!Subject: Re: W/2003, VS/2003, SQL2000 and ThreadAbortException
!Lines: 185
!X-Priority: 3
!X-MSMail-Priority: Normal
!X-Newsreader: Microsoft Outlook Express 6.00.3790.0
!X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
!Message-ID: <JlCPa.155$PT.91682971@newssvr11.news.prodigy.co m>
!NNTP-Posting-Host: 65.23.4.76
!X-Complaints-To: [email]abuse@prodigy.net[/email]
!X-Trace: newssvr11.news.prodigy.com 1057944041 ST000 65.23.4.76 (Fri, 11 Jul 2003 13:20:41 EDT)
!NNTP-Posting-Date: Fri, 11 Jul 2003 13:20:41 EDT
!Organization: SBC [url]http://yahoo.sbc.com[/url]
!X-UserInfo1: OHX]S^KGLBUYBQDXABCBNWX@RJ_XPDLMN@GZ_GYO^JWTEPIB_NVUAH _[BL
[\IRKIANGGJBFNJF_DOLSCENSY^U@FRFUEXR@KFXYDBPWBCDQJA @X_DCBHXR[C@
\EOKCJLED_SZ@RMWYXYWE_P@\\GOIW^@SYFFSWHFIXMADO@^[ADPRPETLBJ]RDGENSKQQZN
!Date: Fri, 11 Jul 2003 17:20:42 GMT
!Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed 00.sul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!
news.maxwell.syr.edu!newsfeed-east.nntpserver.com!nntpserver.com!diablo.voicenet .com!prodigy.com!
newsmst01.news.prodigy.com!prodigy.com!postmaster. news.prodigy.com!newssvr11.news.prodigy.com.POSTED !not-for-
mail
!Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:158596
!X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
!
!We have an active call open with M.S.
!I'll post the answer, if it every is answered! :-0
!
!I'm supprised there aren't more posts about this - must be me!
!
!
!"Yan-Hong Huang[MSFT]" <yhhuang@online.microsoft.com> wrote in message
!news:pBnOW84RDHA.1636@cpmsftngxa06.phx.gbl...
!> Hello David,
!>
!> As you mentioned, the problem resides in a big project. In order to
!isolate the problem, we may need to check config files(I
!> knew you have checked before), analyze cramp dump files. So it is better
!that there is one support engineer to work with
!> you specifically. That is why I suggest you submit a service request for
!it.
!>
!> Thanks very much for your understanding. Please let me know if you have
!any more concerns.
!>
!> Best regards,
!> yhhuang
!> VS.NET, Visual C++
!> Microsoft
!>
!> This posting is provided "AS IS" with no warranties, and confers no
!rights.
!> Got .Net? [url]http://www.gotdotnet.com[/url]
!> --------------------
!> !From: "David Waz..." <dlw@pickpro.com>
!> !Newsgroups: microsoft.public.dotnet.framework.aspnet
!> !References: <038301c3419d$1592f7d0$a301280a@phx.gbl>
!<M85qvnSRDHA.2140@cpmsftngxa09.phx.gbl>
!> !Subject: Re: W/2003, VS/2003, SQL2000 and ThreadAbortException
!> !Lines: 110
!> !X-Newsreader: Microsoft Outlook Express 6.00.3790.0
!> !X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
!> !Message-ID: <G2DOa.16$Pb4.9@newssvr24.news.prodigy.com>
!> !NNTP-Posting-Host: 65.23.4.76
!> !X-Complaints-To: [email]abuse@prodigy.net[/email]
!> !X-Trace: newssvr24.news.prodigy.com 1057684774 ST000 65.23.4.76 (Tue, 08
!Jul 2003 13:19:34 EDT)
!> !NNTP-Posting-Date: Tue, 08 Jul 2003 13:19:34 EDT
!> !Organization: SBC [url]http://yahoo.sbc.com[/url]
!> !X-UserInfo1:
!TSU[@I_A\S@[R]LY]JM\_TLA^R_FBL@MAHU^_BAMEH]TCDYG^WHKAH_[JTXDX_KI\VB]JBVMS^YT
!_G
!>
![CZVWAOS\DHFWEH]@KGXYHB\_CMDSFABP^J[AHHRKARLE_JDBLJ\XA[JRMEI]MGJSPB\Y]^KG\@S
!^@VQKI_Q
!> [G@@_ACSARASDEFLBJ]S\GFNTUAVBL
!> !Date: Tue, 08 Jul 2003 17:19:34 GMT
!> !Path:
!cpmsftngxa09.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfee d00.sul.t-online.de!t-onlin
!e.de!news-spur1.maxwell.syr.edu!
!>
!news.maxwell.syr.edu!wn14feed!worldnet.att.net!20 7.115.63.142!prodigy.com!ne
!wsmst01.news.prodigy.com!prodigy.com!
!>
!postmaster.news.prodigy.com!newssvr24.news.prodig y.com.POSTED!df277b9c!not-f
!or-mail
!> !Xref: cpmsftngxa09.phx.gbl microsoft.public.dotnet.framework.aspnet:33071
!> !X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
!> !
!> !Yup, I figured...
!> !
!> !and it's still kickin' my butt...
!> !
!> !We were using the Universe database from IBM when the problem started
!after
!> !a combination of moving to W/2003 VS/2003 on the development machine and
!> !.Net V1.1 on development and server at the same time the end-user files
!went
!> !from 5 or 6 mb files to 100+mb files.
!> !
!> !So, we THINK the issue started with the new environment, but perhaps the
!> !smaller files of the past never forced us past the magic 105 seconds...
!> !
!> !Still aborting threads like nobody's business...
!> !david
!> !
!> !
!> !"Yan-Hong Huang[MSFT]" <yhhuang@online.microsoft.com> wrote in message
!> !news:M85qvnSRDHA.2140@cpmsftngxa09.phx.gbl...
!> !> Hello David,
!> !>
!> !> I have searched through our internal database and consulted some
!> !enginneers
!> !> on this issue. However, we didn't have clear solution yet without any
!> !> further information. In order to resolve this kind of issue, we may
!need
!> !to
!> !> create a repro sample on it and then troubleshoo the sample to isolate
!the
!> !> problem.
!> !>
!> !> So resolving this problem is going to take 1:1 support, which is beyond
!> !the
!> !> scope of newsgroup support, I suggest that you use one of the support
!> !> incidents included with your MSDN subscription and create a standard
!> !> support incident to address the problem. If this is indeed a product
!> !> issue, there the incident will not be used up by the call.
!> !>
!> !> If you have any more concerns, please post here. Thanks very much for
!your
!> !> understanding.
!> !>
!> !> Best regards,
!> !> yhhuang
!> !> VS.NET, Visual C++
!> !> Microsoft
!> !>
!> !> This posting is provided "AS IS" with no warranties, and confers no
!> !rights.
!> !> Got .Net? [url]http://www.gotdotnet.com[/url]
!> !> --------------------
!> !> !Content-Class: urn:content-classes:message
!> !> !From: "David Waz..." <dlw@pickpro.com>
!> !> !Sender: "David Waz..." <dlw@pickpro.com>
!> !> !Subject: W/2003, VS/2003, SQL2000 and ThreadAbortException
!> !> !Date: Thu, 3 Jul 2003 12:55:42 -0700
!> !> !Lines: 39
!> !> !Message-ID: <038301c3419d$1592f7d0$a301280a@phx.gbl>
!> !> !MIME-Version: 1.0
!> !> !Content-Type: text/plain;
!> !> ! charset="iso-8859-1"
!> !> !Content-Transfer-Encoding: 7bit
!> !> !X-Newsreader: Microsoft CDO for Windows 2000
!> !> !X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
!> !> !Thread-Index: AcNBnRWQN+ElHO5BRlyRNrogAgZ13Q==
!> !> !Newsgroups: microsoft.public.dotnet.framework.aspnet
!> !> !Path: cpmsftngxa09.phx.gbl
!> !> !Xref: cpmsftngxa09.phx.gbl
!microsoft.public.dotnet.framework.aspnet:32175
!> !> !NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
!> !> !X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
!> !> !
!> !> !Moved an app from W/2000 Asp V1.0 to
!> !> !W/2003, VS/2003, ASPV 1.1
!> !> !
!> !> !Page runs a long job, uploading 2 large fixed length files
!> !> !(300,000 rows) into SQL database. A process is run
!> !> !against the data, and altered flat-files produced.
!> !> !
!> !> !The job aborts at EXACTLY 105 seconds (1 min, 45 seconds)
!> !> !regardless of WHERE in the process we are - could be DB
!> !> !read, DB write, string manipulation - whatever.
!> !> !
!> !> !I've checked all Sql Server, Machine.Config, Web.Config
!> !> !and IIS settings - no joy... Researched everything I
!> !> !could find in Google/Microsoft.
!> !> !
!> !> !Workstation: dual 2.66 ghz xeon w/ 2 gig memory, local
!> !> !IIS, local SQL server.
!> !> !
!> !> !HELP!
!> !> !
!> !> !Thread was being
!> !> !aborted.System.Threading.ThreadAbortException: Thread was
!> !> !being aborted.
!> !> ! at System.Data.Common.DbDataAdapter.Update(DataRow[]
!> !> !dataRows, DataTableMapping tableMapping)
!> !> ! at System.Data.Common.DbDataAdapter.Update(DataTable
!> !> !dataTable)
!> !> ! at Maple.PickPro.com.modDb.ExecSqlInsert(DataTable
!> !> !sqlTable, String SelectCmd) in c:\hosted
!> !> !sites\Maple\modDb.vb:line 73
!> !> ! at Maple.PickPro.com.BmcSortProcessSql.ParseDetailFil e
!> !> !() in c:\hosted sites\Maple\BmcSortProcessSql.vb:line 245
!> !> ! at Maple.PickPro.com.bmcSort.ProcessFiles() in
!> !> !c:\hosted sites\Maple\bmcSort.aspx.vb:line 219
!> !> ! at Maple.PickPro.com.bmcSort.btnProcess_Click(Object
!> !> !sender, EventArgs e) in c:\hosted
!> !> !sites\Maple\bmcSort.aspx.vb:line 1047/3/2003 2:52:45 PM -
!> !> !7/3/2003 2:54:31 PM 105
!> !> !
!> !> !
!> !>
!> !
!> !
!> !
!>
!>
!
!
!