Re: General Network Error - MS Stumped

From: Joe Ross (joeross252_at_hotmail.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 17:20:22 -0500

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: 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.sqlserver.connect)
  • Re: General Network Error - MS Stumped
    ... you will have spent more than the cost of 2 machines in salaries trying to ... > server is a Dell PowerEdge 2650 hooked into a PowerVault 220. ... >>> exception thrown appears at the bottom of this post. ... >>> The verdict is that IIS is basically halting the request. ...
    (microsoft.public.sqlserver.connect)
  • Re: General Network Error - MS Stumped
    ... you will have spent more than the cost of 2 machines in salaries trying to ... > server is a Dell PowerEdge 2650 hooked into a PowerVault 220. ... >>> exception thrown appears at the bottom of this post. ... >>> The verdict is that IIS is basically halting the request. ...
    (microsoft.public.sqlserver.server)
  • Re: General Network Error - MS Stumped
    ... you will have spent more than the cost of 2 machines in salaries trying to ... > server is a Dell PowerEdge 2650 hooked into a PowerVault 220. ... >>> exception thrown appears at the bottom of this post. ... >>> The verdict is that IIS is basically halting the request. ...
    (microsoft.public.dotnet.framework.aspnet)
Loading