W/2003, VS/2003, SQL2000 and ThreadAbortExce ption

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.Threa dAbortException : Thread was
being aborted.
at System.Data.Com mon.DbDataAdapt er.Update(DataR ow[]
dataRows, DataTableMappin g tableMapping)
at System.Data.Com mon.DbDataAdapt er.Update(DataT able
dataTable)
at Maple.PickPro.c om.modDb.ExecSq lInsert(DataTab le
sqlTable, String SelectCmd) in c:\hosted
sites\Maple\mod Db.vb:line 73
at Maple.PickPro.c om.BmcSortProce ssSql.ParseDeta ilFile
() in c:\hosted sites\Maple\Bmc SortProcessSql. vb:line 245
at Maple.PickPro.c om.bmcSort.Proc essFiles() in
c:\hosted sites\Maple\bmc Sort.aspx.vb:li ne 219
at Maple.PickPro.c om.bmcSort.btnP rocess_Click(Ob ject
sender, EventArgs e) in c:\hosted
sites\Maple\bmc Sort.aspx.vb:li ne 1047/3/2003 2:52:45 PM -
7/3/2003 2:54:31 PM 105

Nov 17 '05 #1

Subscribe Reply

2143

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? http://www.gotdotnet.com
--------------------
!Content-Class: urn:content-classes:message
!From: "David Waz..." <dl*@pickpro.co m>
!Sender: "David Waz..." <dl*@pickpro.co m>
!Subject: W/2003, VS/2003, SQL2000 and ThreadAbortExce ption
!Date: Thu, 3 Jul 2003 12:55:42 -0700
!Lines: 39
!Message-ID: <03************ *************** *@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+ElHO5 BRlyRNrogAgZ13Q ==
!Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!Path: cpmsftngxa09.ph x.gbl
!Xref: cpmsftngxa09.ph x.gbl microsoft.publi c.dotnet.framew ork.aspnet:3217 5
!NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
!X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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.Thre adAbortExceptio n: Thread was
!being aborted.
! at System.Data.Com mon.DbDataAdapt er.Update(DataR ow[]
!dataRows, DataTableMappin g tableMapping)
! at System.Data.Com mon.DbDataAdapt er.Update(DataT able
!dataTable)
! at Maple.PickPro.c om.modDb.ExecSq lInsert(DataTab le
!sqlTable, String SelectCmd) in c:\hosted
!sites\Maple\mo dDb.vb:line 73
! at Maple.PickPro.c om.BmcSortProce ssSql.ParseDeta ilFile
!() in c:\hosted sites\Maple\Bmc SortProcessSql. vb:line 245
! at Maple.PickPro.c om.bmcSort.Proc essFiles() in
!c:\hosted sites\Maple\bmc Sort.aspx.vb:li ne 219
! at Maple.PickPro.c om.bmcSort.btnP rocess_Click(Ob ject
!sender, EventArgs e) in c:\hosted
!sites\Maple\bm cSort.aspx.vb:l ine 1047/3/2003 2:52:45 PM -
!7/3/2003 2:54:31 PM 105
!
!

Nov 17 '05 #2

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]" <yh*****@online .microsoft.com> wrote in message
news:M8******** ******@cpmsftng xa09.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? http://www.gotdotnet.com
--------------------
!Content-Class: urn:content-classes:message
!From: "David Waz..." <dl*@pickpro.co m>
!Sender: "David Waz..." <dl*@pickpro.co m>
!Subject: W/2003, VS/2003, SQL2000 and ThreadAbortExce ption
!Date: Thu, 3 Jul 2003 12:55:42 -0700
!Lines: 39
!Message-ID: <03************ *************** *@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+ElHO5 BRlyRNrogAgZ13Q ==
!Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!Path: cpmsftngxa09.ph x.gbl
!Xref: cpmsftngxa09.ph x.gbl microsoft.publi c.dotnet.framew ork.aspnet:3217 5
!NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
!X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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.Thre adAbortExceptio n: Thread was
!being aborted.
! at System.Data.Com mon.DbDataAdapt er.Update(DataR ow[]
!dataRows, DataTableMappin g tableMapping)
! at System.Data.Com mon.DbDataAdapt er.Update(DataT able
!dataTable)
! at Maple.PickPro.c om.modDb.ExecSq lInsert(DataTab le
!sqlTable, String SelectCmd) in c:\hosted
!sites\Maple\mo dDb.vb:line 73
! at Maple.PickPro.c om.BmcSortProce ssSql.ParseDeta ilFile
!() in c:\hosted sites\Maple\Bmc SortProcessSql. vb:line 245
! at Maple.PickPro.c om.bmcSort.Proc essFiles() in
!c:\hosted sites\Maple\bmc Sort.aspx.vb:li ne 219
! at Maple.PickPro.c om.bmcSort.btnP rocess_Click(Ob ject
!sender, EventArgs e) in c:\hosted
!sites\Maple\bm cSort.aspx.vb:l ine 1047/3/2003 2:52:45 PM -
!7/3/2003 2:54:31 PM 105
!
!

Nov 17 '05 #3

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? http://www.gotdotnet.com
--------------------
!From: "David Waz..." <dl*@pickpro.co m>
!Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!References: <03************ *************** *@phx.gbl> <M8************ **@cpmsftngxa09 .phx.gbl>
!Subject: Re: W/2003, VS/2003, SQL2000 and ThreadAbortExce ption
!Lines: 110
!X-Newsreader: Microsoft Outlook Express 6.00.3790.0
!X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
!Message-ID: <G2************ @newssvr24.news .prodigy.com>
!NNTP-Posting-Host: 65.23.4.76
!X-Complaints-To: ab***@prodigy.n et
!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 http://yahoo.sbc.com
!X-UserInfo1: TSU[@I_A\S@[R]LY]JM\_TLA^R_FBL@M AHU^_BAMEH]TCDYG^WHKAH_[JTXDX_KI\VB]JBVMS^YT_G
[CZVWAOS\DHFWEH]@KGXYHB\_CMDSFA BP^J[AHHRKARLE_JDBLJ \XA[JRMEI]MGJSPB\Y]^KG\@S^@VQKI_Q
[G@@_ACSARASDEFL BJ]S\GFNTUAVBL
!Date: Tue, 08 Jul 2003 17:19:34 GMT
!Path: cpmsftngxa09.ph x.gbl!TK2MSFTNG P08.phx.gbl!new sfeed00.sul.t-online.de!t-online.de!news-spur1.maxwell.s yr.edu!
news.maxwell.sy r.edu!wn14feed! worldnet.att.ne t!207.115.63.14 2!prodigy.com!n ewsmst01.news.p rodigy.com!prod igy.com!
postmaster.news .prodigy.com!ne wssvr24.news.pr odigy.com.POSTE D!df277b9c!not-for-mail
!Xref: cpmsftngxa09.ph x.gbl microsoft.publi c.dotnet.framew ork.aspnet:3307 1
!X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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]" <yh*****@online .microsoft.com> wrote in message
!news:M8******* *******@cpmsftn gxa09.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? http://www.gotdotnet.com
!> --------------------
!> !Content-Class: urn:content-classes:message
!> !From: "David Waz..." <dl*@pickpro.co m>
!> !Sender: "David Waz..." <dl*@pickpro.co m>
!> !Subject: W/2003, VS/2003, SQL2000 and ThreadAbortExce ption
!> !Date: Thu, 3 Jul 2003 12:55:42 -0700
!> !Lines: 39
!> !Message-ID: <03************ *************** *@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+ElHO5 BRlyRNrogAgZ13Q ==
!> !Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!> !Path: cpmsftngxa09.ph x.gbl
!> !Xref: cpmsftngxa09.ph x.gbl microsoft.publi c.dotnet.framew ork.aspnet:3217 5
!> !NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
!> !X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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.Thre adAbortExceptio n: Thread was
!> !being aborted.
!> ! at System.Data.Com mon.DbDataAdapt er.Update(DataR ow[]
!> !dataRows, DataTableMappin g tableMapping)
!> ! at System.Data.Com mon.DbDataAdapt er.Update(DataT able
!> !dataTable)
!> ! at Maple.PickPro.c om.modDb.ExecSq lInsert(DataTab le
!> !sqlTable, String SelectCmd) in c:\hosted
!> !sites\Maple\mo dDb.vb:line 73
!> ! at Maple.PickPro.c om.BmcSortProce ssSql.ParseDeta ilFile
!> !() in c:\hosted sites\Maple\Bmc SortProcessSql. vb:line 245
!> ! at Maple.PickPro.c om.bmcSort.Proc essFiles() in
!> !c:\hosted sites\Maple\bmc Sort.aspx.vb:li ne 219
!> ! at Maple.PickPro.c om.bmcSort.btnP rocess_Click(Ob ject
!> !sender, EventArgs e) in c:\hosted
!> !sites\Maple\bm cSort.aspx.vb:l ine 1047/3/2003 2:52:45 PM -
!> !7/3/2003 2:54:31 PM 105
!> !
!> !
!>
!
!
!

Nov 17 '05 #4

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]" <yh*****@online .microsoft.com> wrote in message
news:pB******** ******@cpmsftng xa06.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? http://www.gotdotnet.com
--------------------
!From: "David Waz..." <dl*@pickpro.co m>
!Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!References: <03************ *************** *@phx.gbl> <M8************ **@cpmsftngxa09 .phx.gbl> !Subject: Re: W/2003, VS/2003, SQL2000 and ThreadAbortExce ption
!Lines: 110
!X-Newsreader: Microsoft Outlook Express 6.00.3790.0
!X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
!Message-ID: <G2************ @newssvr24.news .prodigy.com>
!NNTP-Posting-Host: 65.23.4.76
!X-Complaints-To: ab***@prodigy.n et
!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 http://yahoo.sbc.com
!X-UserInfo1: TSU[@I_A\S@[R]LY]JM\_TLA^R_FBL@M AHU^_BAMEH]TCDYG^WHKAH_[JTXDX_KI\VB]JBVMS^YT
_G [CZVWAOS\DHFWEH]@KGXYHB\_CMDSFA BP^J[AHHRKARLE_JDBLJ \XA[JRMEI]MGJSPB\Y]^KG\@S
^@VQKI_Q [G@@_ACSARASDEFL BJ]S\GFNTUAVBL
!Date: Tue, 08 Jul 2003 17:19:34 GMT
!Path: cpmsftngxa09.ph x.gbl!TK2MSFTNG P08.phx.gbl!new sfeed00.sul.t-online.de!t-onlin
e.de!news-spur1.maxwell.s yr.edu! news.maxwell.sy r.edu!wn14feed! worldnet.att.ne t!207.115.63.14 2!prodigy.com!n e
wsmst01.news.pr odigy.com!prodi gy.com! postmaster.news .prodigy.com!ne wssvr24.news.pr odigy.com.POSTE D!df277b9c!not-f
or-mail !Xref: cpmsftngxa09.ph x.gbl microsoft.publi c.dotnet.framew ork.aspnet:3307 1
!X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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]" <yh*****@online .microsoft.com> wrote in message
!news:M8******* *******@cpmsftn gxa09.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? http://www.gotdotnet.com
!> --------------------
!> !Content-Class: urn:content-classes:message
!> !From: "David Waz..." <dl*@pickpro.co m>
!> !Sender: "David Waz..." <dl*@pickpro.co m>
!> !Subject: W/2003, VS/2003, SQL2000 and ThreadAbortExce ption
!> !Date: Thu, 3 Jul 2003 12:55:42 -0700
!> !Lines: 39
!> !Message-ID: <03************ *************** *@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+ElHO5 BRlyRNrogAgZ13Q ==
!> !Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!> !Path: cpmsftngxa09.ph x.gbl
!> !Xref: cpmsftngxa09.ph x.gbl microsoft.publi c.dotnet.framew ork.aspnet:3217 5 !> !NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
!> !X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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.Thre adAbortExceptio n: Thread was
!> !being aborted.
!> ! at System.Data.Com mon.DbDataAdapt er.Update(DataR ow[]
!> !dataRows, DataTableMappin g tableMapping)
!> ! at System.Data.Com mon.DbDataAdapt er.Update(DataT able
!> !dataTable)
!> ! at Maple.PickPro.c om.modDb.ExecSq lInsert(DataTab le
!> !sqlTable, String SelectCmd) in c:\hosted
!> !sites\Maple\mo dDb.vb:line 73
!> ! at Maple.PickPro.c om.BmcSortProce ssSql.ParseDeta ilFile
!> !() in c:\hosted sites\Maple\Bmc SortProcessSql. vb:line 245
!> ! at Maple.PickPro.c om.bmcSort.Proc essFiles() in
!> !c:\hosted sites\Maple\bmc Sort.aspx.vb:li ne 219
!> ! at Maple.PickPro.c om.bmcSort.btnP rocess_Click(Ob ject
!> !sender, EventArgs e) in c:\hosted
!> !sites\Maple\bm cSort.aspx.vb:l ine 1047/3/2003 2:52:45 PM -
!> !7/3/2003 2:54:31 PM 105
!> !
!> !
!>
!
!
!

Nov 17 '05 #5

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? http://www.gotdotnet.com
--------------------
!From: "David Waz..." <dl*@pickpro.co m>
!Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!References: <03************ *************** *@phx.gbl> <M8************ **@cpmsftngxa09 .phx.gbl> <G2DOa.16
$P****@newssvr2 4.news.prodigy. com> <pB************ **@cpmsftngxa06 .phx.gbl>
!Subject: Re: W/2003, VS/2003, SQL2000 and ThreadAbortExce ption
!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: <Jl************ *******@newssvr 11.news.prodigy .com>
!NNTP-Posting-Host: 65.23.4.76
!X-Complaints-To: ab***@prodigy.n et
!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 http://yahoo.sbc.com
!X-UserInfo1: OHX]S^KGLBUYBQDXABC BNWX@RJ_XPDLMN@ GZ_GYO^JWTEPIB_ NVUAH_[BL
[\IRKIANGGJBFNJF _DOLSCENSY^U@FR FUEXR@KFXYDBPWB CDQJA@X_DCBHXR[C@
\EOKCJLED_SZ@RM WYXYWE_P@\\GOIW ^@SYFFSWHFIXMAD O@^[ADPRPETLBJ]RDGENSKQQZN
!Date: Fri, 11 Jul 2003 17:20:42 GMT
!Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!new sfeed00.sul.t-online.de!t-online.de!news-spur1.maxwell.s yr.edu!
news.maxwell.sy r.edu!newsfeed-east.nntpserver .com!nntpserver .com!diablo.voi cenet.com!prodi gy.com!
newsmst01.news. prodigy.com!pro digy.com!postma ster.news.prodi gy.com!newssvr1 1.news.prodigy. com.POSTED!not-for-
mail
!Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.framew ork.aspnet:1585 96
!X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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]" <yh*****@online .microsoft.com> wrote in message
!news:pB******* *******@cpmsftn gxa06.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? http://www.gotdotnet.com
!> --------------------
!> !From: "David Waz..." <dl*@pickpro.co m>
!> !Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!> !References: <03************ *************** *@phx.gbl>
!<M8*********** ***@cpmsftngxa0 9.phx.gbl>
!> !Subject: Re: W/2003, VS/2003, SQL2000 and ThreadAbortExce ption
!> !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$P**** @newssvr24.news .prodigy.com>
!> !NNTP-Posting-Host: 65.23.4.76
!> !X-Complaints-To: ab***@prodigy.n et
!> !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 http://yahoo.sbc.com
!> !X-UserInfo1:
!TSU[@I_A\S@[R]LY]JM\_TLA^R_FBL@M AHU^_BAMEH]TCDYG^WHKAH_[JTXDX_KI\VB]JBVMS^YT
!_G
!>
![CZVWAOS\DHFWEH]@KGXYHB\_CMDSFA BP^J[AHHRKARLE_JDBLJ \XA[JRMEI]MGJSPB\Y]^KG\@S
!^@VQKI_Q
!> [G@@_ACSARASDEFL BJ]S\GFNTUAVBL
!> !Date: Tue, 08 Jul 2003 17:19:34 GMT
!> !Path:
!cpmsftngxa09.p hx.gbl!TK2MSFTN GP08.phx.gbl!ne wsfeed00.sul.t-online.de!t-onlin
!e.de!news-spur1.maxwell.s yr.edu!
!>
!news.maxwell.s yr.edu!wn14feed !worldnet.att.n et!207.115.63.1 42!prodigy.com! ne
!wsmst01.news.p rodigy.com!prod igy.com!
!>
!postmaster.new s.prodigy.com!n ewssvr24.news.p rodigy.com.POST ED!df277b9c!not-f
!or-mail
!> !Xref: cpmsftngxa09.ph x.gbl microsoft.publi c.dotnet.framew ork.aspnet:3307 1
!> !X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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]" <yh*****@online .microsoft.com> wrote in message
!> !news:M8******* *******@cpmsftn gxa09.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? http://www.gotdotnet.com
!> !> --------------------
!> !> !Content-Class: urn:content-classes:message
!> !> !From: "David Waz..." <dl*@pickpro.co m>
!> !> !Sender: "David Waz..." <dl*@pickpro.co m>
!> !> !Subject: W/2003, VS/2003, SQL2000 and ThreadAbortExce ption
!> !> !Date: Thu, 3 Jul 2003 12:55:42 -0700
!> !> !Lines: 39
!> !> !Message-ID: <03************ *************** *@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+ElHO5 BRlyRNrogAgZ13Q ==
!> !> !Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!> !> !Path: cpmsftngxa09.ph x.gbl
!> !> !Xref: cpmsftngxa09.ph x.gbl
!microsoft.publ ic.dotnet.frame work.aspnet:321 75
!> !> !NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
!> !> !X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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.Thre adAbortExceptio n: Thread was
!> !> !being aborted.
!> !> ! at System.Data.Com mon.DbDataAdapt er.Update(DataR ow[]
!> !> !dataRows, DataTableMappin g tableMapping)
!> !> ! at System.Data.Com mon.DbDataAdapt er.Update(DataT able
!> !> !dataTable)
!> !> ! at Maple.PickPro.c om.modDb.ExecSq lInsert(DataTab le
!> !> !sqlTable, String SelectCmd) in c:\hosted
!> !> !sites\Maple\mo dDb.vb:line 73
!> !> ! at Maple.PickPro.c om.BmcSortProce ssSql.ParseDeta ilFile
!> !> !() in c:\hosted sites\Maple\Bmc SortProcessSql. vb:line 245
!> !> ! at Maple.PickPro.c om.bmcSort.Proc essFiles() in
!> !> !c:\hosted sites\Maple\bmc Sort.aspx.vb:li ne 219
!> !> ! at Maple.PickPro.c om.bmcSort.btnP rocess_Click(Ob ject
!> !> !sender, EventArgs e) in c:\hosted
!> !> !sites\Maple\bm cSort.aspx.vb:l ine 1047/3/2003 2:52:45 PM -
!> !> !7/3/2003 2:54:31 PM 105
!> !> !
!> !> !
!> !>
!> !
!> !
!> !
!>
!>
!
!
!

Nov 17 '05 #6

Yan-Hong Huang[MSFT]

Nov 17 '05 #7

Similar topics

3344

SQL7 to SQL2000 Migration

by: LizP | last post by:

Hi, guys - looking for a bit of help/advice on moving a database from SQL 7 to SQL 2000. We've a third party application which currently uses a SQL7 database. This database has a number of views which are owned by user INFORMATION_SCHEMA and are set as system tables. This user doesn't actually have a login on the SQL server. We've tried the following to recreate the database on SQL2000, but whatever we try, the views owned by...

Microsoft SQL Server

1191

connection problem - windows 2003 +sql2000

by: bk | last post by:

I get "SQL Server is unavailable or does not exist" error while developing asp.net application in vs2003's IDE development mode. The sql2000 is installed on a windows 2003 server. I am able to connect to server using Query Analyzer and Enterprise Manager. My connection string is: string sConStr= "Server = 192.168.0.28;User ID=myuser;Initial Catalog=pubs;Password=mypassword"

Microsoft SQL Server

2903

ThreadAbortException - Why is it rethrown?

by: Vivek | last post by:

Hi, I have a question regarding ThreadAbortException. Why is the thread abort exception rethrown at the end of a catch clause? Why is ThreadAbortException's behavior designed to be this way? Thanks in advance -Vivek

C# / C Sharp

3215

ASP.Net Application - SQL Server 2000 Access Problem on Windows 2003 server from XP

by: Vaap | last post by:

I did lot of googling to see if I can solve the SQL server not found problem while trying to run ASP.Net community starter kit from an XP machine to Windows 2003 server hosting SQL server 2000 database. Tried all possible combinations but it still fails. I have Windows 2003 server having SQL Server 2000 installed with SP2. The installation went Ok on a XP professional machine and I was able to create database and user logins etc on...

ASP.NET

1908

ThreadAbortException not behaving properly?

by: Steve - DND | last post by:

I just implemented a page that performs a Response.Redirect(url, true). As such, I wrapped it in a try catch, and explicitly caught a ThreadAbortException. However, the thread abort exception was still thrown at every catch block above the try/catches level, as well as at the *same* level as the try/catch. This does not seem like proper behavior at all. Once I've caught the exception, why is it still propagating up the stack? I could maybe...

ASP.NET

1735

Intermittent ThreadAbortException while processing posted XML

by: splap20 | last post by:

Every day a large chunk of XML is posted up to my app via http. The app interprets this XML and writes results to a SQLServer. Occasionally a ThreadAbortException is thrown during this process. Despite being caught, this exception propagates all the way up the call stack. I know this is by design and that I can use Thread.ResetAbort to stop this exception from bubbling up the stack. But I want to know why the exception is thrown in the...

ASP.NET

7449

ThreadAbortException occurs when the child thread is in catch block{}

by: foolmelon | last post by:

If a childThread is in the middle of a catch block and handling an exception caught, the main thread calls childThread.Abort(). At that time a ThreadAbortException is thrown in the childThread. The question is: after the ThreadAbortException is thrown, does the childThread continue run the remaining code in the catch block?

C# / C Sharp

3348

threadabortexception and web services

by: =?Utf-8?B?RXRoYW4gU3RyYXVzcw==?= | last post by:

Hi, I am running a web service which sometimes throws exceptions. I have a lot of error trapping within the web service, but I have missed the current problem. I am working on the current issue, but there even when I get this fixed, there may be others I have not thought of. My immediate problem is that the web service seems to throw a threadabortexception to the client when it has an uncaught exception (I may be wrong. I am a bit confused...

C# / C Sharp

1636

ThreadAbortException on Redirect

by: Zeba | last post by:

Hi ! I am using a httphandler to perform some url rewriting in my application. My web.config contains the following entry to direct all urls containing /App/*.ashx to my class AppHandler.cs in namespace mySite.Web <httpHandlers> <add verb="*" path="App/*.ashx" type="mySite.Web.AppHandler, App_Code"/>

C# / C Sharp

9528

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9359

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9310

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6792

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6072

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4863

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3298

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2774

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2206

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General