"Mr. Murdock" <MrMurdock@discussions.microsoft.com> wrote in message
news:8957D5D6-2A85-40F5-A11C-297669DBEDC8@microsoft.com...
>I have tried increasing the webservice object timeout and execution timeout
> (debug ='false') but It didn't work.
>
> I don't receive any error messages.
>
> "Mr. Murdock" wrote:
>
>> Hello,
>>
>> I have a multithread method that calls a really long SP. It takes around
>> 2
>> hours to run. this method is in a Webservice. I'm using Thread object to
>> control the multithread procedure and each thread creates it own data
>> connection to avoid connection already open exception.
>>
>> It starts OK, runs for sometime and just drops. I have created a log
>> procedure to trace it and it looks like .NET is dropping the thread
>> together
>> with the data connection.
>>
>> I tried with other SPs and works fine but for this long one it doesn't.
>>
>> Should I remove the Thread object and call the async webservice method
>> instead?
>> Could this be some kind of timeout?

"John Saunders [MVP]" wrote:

> "Mr. Murdock" <MrMurdock@discussions.microsoft.com> wrote in message
> news:8957D5D6-2A85-40F5-A11C-297669DBEDC8@microsoft.com...
> >I have tried increasing the webservice object timeout and execution timeout
> > (debug ='false') but It didn't work.
> >
> > I don't receive any error messages.
> >
> > "Mr. Murdock" wrote:
> >
> >> Hello,
> >>
> >> I have a multithread method that calls a really long SP. It takes around
> >> 2
> >> hours to run. this method is in a Webservice. I'm using Thread object to
> >> control the multithread procedure and each thread creates it own data
> >> connection to avoid connection already open exception.
> >>
> >> It starts OK, runs for sometime and just drops. I have created a log
> >> procedure to trace it and it looks like .NET is dropping the thread
> >> together
> >> with the data connection.
> >>
> >> I tried with other SPs and works fine but for this long one it doesn't.
> >>
> >> Should I remove the Thread object and call the async webservice method
> >> instead?
> >> Could this be some kind of timeout?
>
> What is it that led you to believe that the thread is "just dropped"?
>
> Also, web services are not appropriate for running any long-running task.
> You should be using something like a Windows Service to run such a task,
> perhaps triggered by the web service.
> --
> --------------------------------------------------------------------------------
> John Saunders | MVP - Windows Server System - Connected System Developer
>
>