Re: General Network Error - MS Stumped

From: Kevin Spencer (kevin_at_takempis.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 07:43:52 -0500

If it does turn out to be a hardware or installed software issue, I believe
you will have spent more than the cost of 2 machines in salaries trying to
find it. 

-- 
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Joe Ross" <joeross252@hotmail.com> wrote in message
news:O1JOAaL$DHA.1732@TK2MSFTNGP12.phx.gbl...
> Unforunately, we're a small company and don't have the "luxury" of
> duplicating the environment.  However, there is plenty of horsepower there
> to meet our needs.  The web server is a Dell PowerEdge 1750 and the
database
> server is a Dell PowerEdge 2650 hooked into a PowerVault 220.  Usage is
> quite light.
>
> I would love to be able to do what you say and I appreciate the value it
> would bring to solving the problem, unfortunately, it's not realistic for
us
> at this time.
>
> Thanks
> -joe
>
>
> "Kevin Spencer" <kevin@takempis.com> wrote in message
> news:OVDsMqJ$DHA.2524@tk2msftngp13.phx.gbl...
> > Have you eliminated hardware or installed software issues by trying to
run
> > this on a different pair of machines?
> >
> > -- 
> > HTH,
> > Kevin Spencer
> > .Net Developer
> > Microsoft MVP
> > Big things are made up
> > of lots of little things.
> >
> > "Joe Ross" <joeross252@hotmail.com> wrote in message
> > news:u55gTVJ$DHA.1796@TK2MSFTNGP12.phx.gbl...
> > > I've been working with Microsoft support for over 3 weeks now on an
> > > intermittent General Network Error we're seeing in our production
> > > environment between our ASP.NET application and SQL Server 2000.  They
> are
> > > continuing to work on the issue, but it seems as if our progress is
> > grinding
> > > to a halt.  I asked this question on the newsgroups before going to MS
> but
> > > figured I'd give it another shot now that I have more information.
> > >
> > > The problem occurs intermittently (maybe 10 to 15 times per day).  It
> > seems
> > > to be related to queries that return "large" amounts of data from SQL.
> > The
> > > problem started after we made an equipment change.  We went from a
> single
> > > server hosting both our ASP.NET application and SQL Server 2000, to
one
> > > server hosting IIS and another machine running SQL.  An example of the
> > > exception thrown appears at the bottom of this post.
> > >
> > > MS had us perform 3 data captures initially: MPSRPT_MDAC on the IIS
> > machine,
> > > MPSRPT_MDAC on the SQL machine, and SQLDIAG on the database server.
The
> > MS
> > > rep found nothing too out of the ordinary with our configuration, so
he
> > > asked me to do a network capture on both machines while the error
> > occurred.
> > >
> > > I was able to get a good capture in a small window and sent it off to
> MS.
> > > The verdict is that IIS is basically halting the request.  It is
> resetting
> > > the database connection partway through retrieving the results of the
> > stored
> > > proc.  IIS attempts to close the connection for some reason, SQL
ignores
> > and
> > > keeps pumping back data, then IIS raises a reset.  MS confirmed that
> there
> > > is no packet loss.  MS has not determined why this is happening and
has
> > not
> > > advised me to capture any additional data.
> > >
> > > If someone has any ideas, I am willing to provide as much detail as
> > > possible.  I wanted to keep this initial post as concise as possible.
> > >
> > > Thanks for any assistance you can provide,
> > > -joe
> > >
> > > EXCEPTION:
> > > System.Data.SqlClient.SqlException: General network error.  Check your
> > > network documentation.
> > >    at System.Data.SqlClient.SqlConnection.OnError(SqlException
> exception,
> > > TdsParserState state)
> > >    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > > exception, TdsParserState state)
> > >    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
> > >    at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> > >    at System.Data.SqlClient.TdsParser.ReadBuffer()
> > >    at System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff, Int32
> > > offset, Int32 len)
> > >    at System.Data.SqlClient.TdsParser.ReadEncodingChar(Int32 length,
> > > Encoding encoding)
> > >    at System.Data.SqlClient.TdsParser.ReadSqlValue(_SqlMetaData md,
> Int32
> > > length)
> > >    at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[]
columns,
> > > Object[] buffer, Int32[] map, Boolean useSQLTypes)
> > >    at System.Data.SqlClient.SqlDataReader.PrepareSQLRecord(Int32 i)
> > >    at System.Data.SqlClient.SqlDataReader.GetSqlString(Int32 i)
> > >    at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Im totally stumped - IIS not working on two separate machines - 500 Internal Server Error
    ... Make sure the extensions have been registered with your IIS server. ... If not, uninstall VS.net, get IIS running properly and then install ... on two 'totally independent' machines. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: General Network Error - MS Stumped
    ... >> exception thrown appears at the bottom of this post. ... >> asked me to do a network capture on both machines while the error ... >> I was able to get a good capture in a small window and sent it off to ... >> The verdict is that IIS is basically halting the request. ...
    (microsoft.public.sqlserver.connect)
  • Re: General Network Error - MS Stumped
    ... >> exception thrown appears at the bottom of this post. ... >> asked me to do a network capture on both machines while the error ... >> I was able to get a good capture in a small window and sent it off to ... >> The verdict is that IIS is basically halting the request. ...
    (microsoft.public.sqlserver.server)
  • Re: General Network Error - MS Stumped
    ... >> exception thrown appears at the bottom of this post. ... >> asked me to do a network capture on both machines while the error ... >> I was able to get a good capture in a small window and sent it off to ... >> The verdict is that IIS is basically halting the request. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Help!- Socket error in Web Service when network is disabled.
    ... network disabled on the Server, or on the Client machines? ... > I have a web service installed on a windows 2003 server machine. ... > On the other machines under the same scenario no exception comes. ...
    (microsoft.public.dotnet.framework.webservices.enhancements)