An existing connection was forcibly closed by the remote host

Question

0.00/5 (No votes)

See more:

Hi,

I have developed webservice using .NET 2.0.This is scheduled job. In this webservice i am calling third party database.
The third party database returns the data through typed dataset,
The web service is calling in console project(.exe file).
The console project deployed sql server agent in sql server 2005 management studio.
if data is very high(in lakhs) and the job will be continue up to 4 to 5 hours and job is failing then
i am getting following error.

System.IO.IOException: Unable to read data from the transport connection. ---> System.Net.Sockets.SocketException:
An existing connection was forcibly closed by the remote host

if data is very less then it works properly.this thing happening only on production server.
same if i debug on local machine then it is working perfectly fine without any error.

please give me solution for same.

Thanks in advance

Posted 29-Jul-10 0:26am

harshitha2006

Updated 1-Apr-22 21:49pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Accepted Answer · 2010-07-29T01:30:00

Leaving a connection open any longer than absolutely necessary is a bad idea.

You probably should refactor your code so that the job is kicked off by the service, and the service method terminates. At that point, you can either have the remote host contact your machhine via WCF (or TCP) when the job is done, and then your app can retrieve the data.