Re: General Network Error - MS Stumped
From: Joe Ross (joeross252_at_hotmail.com)
Date: 02/27/04
- Next message: Jim Cheshire [MSFT]: "Re: How do i get rid of the weird message in the eventlog"
- Previous message: Martin Dechev: "Re: Pageable DataGrid"
- In reply to: Kevin Spencer: "Re: General Network Error - MS Stumped"
- Next in thread: Kevin Spencer: "Re: General Network Error - MS Stumped"
- Reply: Kevin Spencer: "Re: General Network Error - MS Stumped"
- Reply: Bill Breitmayer: "Re: General Network Error - MS Stumped"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 27 Feb 2004 09:29:49 -0500
I respectfully disagree. Thank you for your overly helpful advice.
-joe
"Kevin Spencer" <kevin@takempis.com> wrote in message
news:uW6oBBT$DHA.2476@TK2MSFTNGP12.phx.gbl...
> 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)
> > > >
> > > >
> > >
> > >
> >
> >
>
>
- Next message: Jim Cheshire [MSFT]: "Re: How do i get rid of the weird message in the eventlog"
- Previous message: Martin Dechev: "Re: Pageable DataGrid"
- In reply to: Kevin Spencer: "Re: General Network Error - MS Stumped"
- Next in thread: Kevin Spencer: "Re: General Network Error - MS Stumped"
- Reply: Kevin Spencer: "Re: General Network Error - MS Stumped"
- Reply: Bill Breitmayer: "Re: General Network Error - MS Stumped"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
