Prev: SQL Server 2000, Non-Clustered Index Creation and Blocking
Next: Tracking results of changes to database
From: gerry on 19 Apr 2010 12:48
Hello Charles ,

I just saw your response on microsoft.com/communities - I found it via
google as it never showed up on the newsgroup ?!?

The problem isn't the that the exception is thrown ( in fact I want the user
to see them ) , the problem is that once an exception is thrown the web
service call will fail 100% of the time after that until the sql service is
restarted.

The only time we see any exceptions being thrown is after the webservice
machine is rebooted. We can access the web service after a reboot from the
sql server machine via web browser but not from the sqlclr webservice call .

Gerry




"Charles Wang [MSFT]" 4/2/2010 5:31 PM PST



Hi,
Once you receive a thread abort exception, even you use
catch to handle it.
It will still be thrown out after the catch handling
unless you call
ResetAbort().Does the following code help for you?
==============================
try{
string response = ws.Call1( null , null , Method , Arg1 );
}
catch(ThreadAbortException ex)
{
Thread.ResetAbort();
... //put your code here for additional handling
}
catch(Exception){
.../*Other exception handling*/
}
=================================


Best regards,
Charles Wang






"gerry" <germ2(a)newsgroup.nospam> wrote in message
news:udoFmm3zKHA.928(a)TK2MSFTNGP05.phx.gbl...
>I adjusted the code example for a little more context.
> I also added an additional try catch to see if that catches something.
>
> "gerry" <germ2(a)newsgroup.nospam> wrote in message
> news:%23OJSjR3zKHA.928(a)TK2MSFTNGP05.phx.gbl...
>> We have an sqlclr Stored procedure that invokes a web service.
>> SqlServer sits on on one machine and the web service on another within
>> the same lan.
>> Everything works fine until the web service machine is rebooted - at
>> which point all attempts to use the SP bomb with the exception below
>> until we restart the Sql Service.
>> I am probably wrong but it sounds like a connection to the webservice is
>> being opened once and held open for all subsequent requests. When the
>> webservice machine is rebooted the connection is broken causing this
>> exception.
>>
>> MySP was created by using 'Add Web Reference'
>>
>
>
>
> [SqlProcedure]
> public static void HPU_MySP( string Request )
> {
> using ( MyWS ws = new MyWS() )
> {
> ///
> /// errors during ws call leave connection open
> /// even though object is disposed
> /// 2 solutions so far :
> ///
> /// 1:
> /// try {
> /// rtn = ws.Call();
> /// } catch(ThreadAbortException){
> /// try{ ws.Abort(); }catch(Exception){}
> /// throw;
> /// }
> ///2:
> /// change
> /// rtn = ws.Call();
> /// to
> /// rtn = ws.EndCall( ws.BeginCall( null , null ) );
> ///
> /// see
> http://dbaspot.com/forums/ms-sqlserver/218732-aborting-web-service-method-invokes-after-threadabortexception.html
> ///
> // string response = ws.Call1( null , null , Method , Arg1 );
> try{
> string response = ws.EndCall1( ws.BeginCall1( null , null , Method
> , Arg1 , null , null ) );
>
> }catch(Exception){
> try( ws.Abort(); } catch(Exception ) { }
> throw;
> }
> ...
> }
> }
>
>
>>
>>
>>
>>
>> Msg 6522, Level 16, State 1, Procedure MySP, Line 0
>> A .NET Framework error occurred during execution of user-defined routine
>> or aggregate "MySP":
>> System.TypeInitializationException: The type initializer for
>> 'Microsoft.SqlServer.Server.SmiContextFactory' threw an exception. --->
>> System.Threading.ThreadAbortException: Exception of type
>> 'System.Threading.ThreadAbortException' was thrown.
>> System.Threading.ThreadAbortException:
>>
>> System.TypeInitializationException:
>> at Microsoft.SqlServer.Server.SqlContext.get_CurrentContext()
>> at Microsoft.SqlServer.Server.SqlContext.get_Pipe()
>> at GmsSqlClr.StoredProcedures.MySP(String Request)
>>
>>
>
>


From: "Charles Wang [MSFT]" on 22 Apr 2010 05:08
Gerry,
I have not been able to reproduce your issue. There must be some crash
happened in the SQL Server process. To track the root cause of this issue,
dump analysis will be helpful, but this requires you contact Microsoft
Customer Support Services (CSS) via telephone so that a dedicated Support
Professional can assist you in a more efficient manner. Please be advised
that contacting phone support will be a charged call.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

Best regards,
Charles Wang




 | 
Pages: 1
Prev: SQL Server 2000, Non-Clustered Index Creation and Blocking
Next: Tracking results of changes to database