473,837 Members | 1,771 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

General Network Error - MS Stumped

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.Sql Client.SqlExcep tion: General network error. Check your
network documentation.
at System.Data.Sql Client.SqlConne ction.OnError(S qlException exception,
TdsParserState state)
at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, TdsParserState state)
at System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning()
at System.Data.Sql Client.TdsParse r.ReadNetlib(In t32 bytesExpected)
at System.Data.Sql Client.TdsParse r.ReadBuffer()
at System.Data.Sql Client.TdsParse r.ReadByteArray (Byte[] buff, Int32
offset, Int32 len)
at System.Data.Sql Client.TdsParse r.ReadEncodingC har(Int32 length,
Encoding encoding)
at System.Data.Sql Client.TdsParse r.ReadSqlValue( _SqlMetaData md, Int32
length)
at System.Data.Sql Client.TdsParse r.ProcessRow(_S qlMetaData[] columns,
Object[] buffer, Int32[] map, Boolean useSQLTypes)
at System.Data.Sql Client.SqlDataR eader.PrepareSQ LRecord(Int32 i)
at System.Data.Sql Client.SqlDataR eader.GetSqlStr ing(Int32 i)
at System.Data.Sql Client.SqlDataR eader.GetString (Int32 i)
Nov 18 '05 #1
7 2030
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" <jo********@hot mail.com> wrote in message
news:u5******** ******@TK2MSFTN GP12.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.Sql Client.SqlExcep tion: General network error. Check your
network documentation.
at System.Data.Sql Client.SqlConne ction.OnError(S qlException exception,
TdsParserState state)
at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, TdsParserState state)
at System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning()
at System.Data.Sql Client.TdsParse r.ReadNetlib(In t32 bytesExpected)
at System.Data.Sql Client.TdsParse r.ReadBuffer()
at System.Data.Sql Client.TdsParse r.ReadByteArray (Byte[] buff, Int32
offset, Int32 len)
at System.Data.Sql Client.TdsParse r.ReadEncodingC har(Int32 length,
Encoding encoding)
at System.Data.Sql Client.TdsParse r.ReadSqlValue( _SqlMetaData md, Int32
length)
at System.Data.Sql Client.TdsParse r.ProcessRow(_S qlMetaData[] columns,
Object[] buffer, Int32[] map, Boolean useSQLTypes)
at System.Data.Sql Client.SqlDataR eader.PrepareSQ LRecord(Int32 i)
at System.Data.Sql Client.SqlDataR eader.GetSqlStr ing(Int32 i)
at System.Data.Sql Client.SqlDataR eader.GetString (Int32 i)

Nov 18 '05 #2
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" <ke***@takempis .com> wrote in message
news:OV******** ******@tk2msftn gp13.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" <jo********@hot mail.com> wrote in message
news:u5******** ******@TK2MSFTN GP12.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.Sql Client.SqlExcep tion: General network error. Check your
network documentation.
at System.Data.Sql Client.SqlConne ction.OnError(S qlException exception, TdsParserState state)
at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, TdsParserState state)
at System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning()
at System.Data.Sql Client.TdsParse r.ReadNetlib(In t32 bytesExpected)
at System.Data.Sql Client.TdsParse r.ReadBuffer()
at System.Data.Sql Client.TdsParse r.ReadByteArray (Byte[] buff, Int32
offset, Int32 len)
at System.Data.Sql Client.TdsParse r.ReadEncodingC har(Int32 length,
Encoding encoding)
at System.Data.Sql Client.TdsParse r.ReadSqlValue( _SqlMetaData md, Int32 length)
at System.Data.Sql Client.TdsParse r.ProcessRow(_S qlMetaData[] columns,
Object[] buffer, Int32[] map, Boolean useSQLTypes)
at System.Data.Sql Client.SqlDataR eader.PrepareSQ LRecord(Int32 i)
at System.Data.Sql Client.SqlDataR eader.GetSqlStr ing(Int32 i)
at System.Data.Sql Client.SqlDataR eader.GetString (Int32 i)


Nov 18 '05 #3
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" <jo********@hot mail.com> wrote in message
news:O1******** ******@TK2MSFTN GP12.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" <ke***@takempis .com> wrote in message
news:OV******** ******@tk2msftn gp13.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" <jo********@hot mail.com> wrote in message
news:u5******** ******@TK2MSFTN GP12.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.Sql Client.SqlExcep tion: General network error. Check your
network documentation.
at System.Data.Sql Client.SqlConne ction.OnError(S qlException

exception, TdsParserState state)
at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, TdsParserState state)
at System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning()
at System.Data.Sql Client.TdsParse r.ReadNetlib(In t32 bytesExpected)
at System.Data.Sql Client.TdsParse r.ReadBuffer()
at System.Data.Sql Client.TdsParse r.ReadByteArray (Byte[] buff, Int32
offset, Int32 len)
at System.Data.Sql Client.TdsParse r.ReadEncodingC har(Int32 length,
Encoding encoding)
at System.Data.Sql Client.TdsParse r.ReadSqlValue( _SqlMetaData md, Int32 length)
at System.Data.Sql Client.TdsParse r.ProcessRow(_S qlMetaData[]

columns, Object[] buffer, Int32[] map, Boolean useSQLTypes)
at System.Data.Sql Client.SqlDataR eader.PrepareSQ LRecord(Int32 i)
at System.Data.Sql Client.SqlDataR eader.GetSqlStr ing(Int32 i)
at System.Data.Sql Client.SqlDataR eader.GetString (Int32 i)



Nov 18 '05 #4
I respectfully disagree. Thank you for your overly helpful advice.

-joe

"Kevin Spencer" <ke***@takempis .com> wrote in message
news:uW******** ******@TK2MSFTN GP12.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" <jo********@hot mail.com> wrote in message
news:O1******** ******@TK2MSFTN GP12.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" <ke***@takempis .com> wrote in message
news:OV******** ******@tk2msftn gp13.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" <jo********@hot mail.com> wrote in message
news:u5******** ******@TK2MSFTN GP12.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.Sql Client.SqlExcep tion: General network error. Check your > network documentation.
> at System.Data.Sql Client.SqlConne ction.OnError(S qlException

exception,
> TdsParserState state)
> at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion > exception, TdsParserState state)
> at System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning()
> at System.Data.Sql Client.TdsParse r.ReadNetlib(In t32 bytesExpected) > at System.Data.Sql Client.TdsParse r.ReadBuffer()
> at System.Data.Sql Client.TdsParse r.ReadByteArray (Byte[] buff, Int32 > offset, Int32 len)
> at System.Data.Sql Client.TdsParse r.ReadEncodingC har(Int32 length,
> Encoding encoding)
> at System.Data.Sql Client.TdsParse r.ReadSqlValue( _SqlMetaData md,

Int32
> length)
> at System.Data.Sql Client.TdsParse r.ProcessRow(_S qlMetaData[] columns, > Object[] buffer, Int32[] map, Boolean useSQLTypes)
> at System.Data.Sql Client.SqlDataR eader.PrepareSQ LRecord(Int32 i)
> at System.Data.Sql Client.SqlDataR eader.GetSqlStr ing(Int32 i)
> at System.Data.Sql Client.SqlDataR eader.GetString (Int32 i)
>
>



Nov 18 '05 #5
> I respectfully disagree. Thank you for your overly helpful advice.

You stated originally that you had already spent 3 weeks on this problem
without a resolution. I don't know what your salaries are like, but 3 weeks
is a lot of man-hours, and Microsoft support is expensive. Maybe you should
disagree later, when and if you get it fixed.

Thank you for your overly defensive reply.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Joe Ross" <jo********@hot mail.com> wrote in message
news:Oa******** *****@TK2MSFTNG P10.phx.gbl...
I respectfully disagree. Thank you for your overly helpful advice.

-joe

"Kevin Spencer" <ke***@takempis .com> wrote in message
news:uW******** ******@TK2MSFTN GP12.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" <jo********@hot mail.com> wrote in message
news:O1******** ******@TK2MSFTN GP12.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" <ke***@takempis .com> wrote in message
news:OV******** ******@tk2msftn gp13.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" <jo********@hot mail.com> wrote in message
> news:u5******** ******@TK2MSFTN GP12.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.Sql Client.SqlExcep tion: General network error. Check your > > network documentation.
> > at System.Data.Sql Client.SqlConne ction.OnError(S qlException
exception,
> > TdsParserState state)
> > at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion > > exception, TdsParserState state)
> > at System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning()
> > at System.Data.Sql Client.TdsParse r.ReadNetlib(In t32 bytesExpected) > > at System.Data.Sql Client.TdsParse r.ReadBuffer()
> > at System.Data.Sql Client.TdsParse r.ReadByteArray (Byte[] buff, Int32 > > offset, Int32 len)
> > at System.Data.Sql Client.TdsParse r.ReadEncodingC har(Int32 length, > > Encoding encoding)
> > at System.Data.Sql Client.TdsParse r.ReadSqlValue( _SqlMetaData md, Int32
> > length)
> > at System.Data.Sql Client.TdsParse r.ProcessRow(_S qlMetaData[]

columns,
> > Object[] buffer, Int32[] map, Boolean useSQLTypes)
> > at System.Data.Sql Client.SqlDataR eader.PrepareSQ LRecord(Int32 i) > > at System.Data.Sql Client.SqlDataR eader.GetSqlStr ing(Int32 i)
> > at System.Data.Sql Client.SqlDataR eader.GetString (Int32 i)
> >
> >
>
>



Nov 18 '05 #6
Joe -

At the risk of being 'overly' helpful, I would suggest that you may be
making too many assumptions about the operational data, for example the MS
assertion that no packets are being lost. The monitoring tools are not
infallible and they may in fact be wrong ( it even happened to me once long
ago ;-).

It sounds like MS is looking primarily at configuration data and not
performance data. Interaction under load between IIS and .NET may be
creating contention for resources or devices. If the queries are returning
'large' amounts of data, then the workload is not light, it's heavy and
there may well be a performance bottleneck in the server or network. It
could even be caused by a bad driver for a network device. Find every error
log and run every monitor on the system. There may be a lower level problem
within the apparent problem.

I'd also look very closely at application level performance, particularly
the heavy hitters, to see if you can reduce sudden bursts of demand. If the
heavy hitters are not critical, slow them down and spread out the demand.
If your delivery date is in extreme unction, you may even need to redesign
the queries to work around it.

In any case, I think you may need to fully instrument your server, collect
all the configuration and operation data available and do a more complete
analysis of your system. I've run across problems with complex interactions
in the past and a strictly analytic approach was the only way out.

For what it's worth ....

- Bill Breitmayer

"Joe Ross" <jo********@hot mail.com> wrote in message
news:Oa******** *****@TK2MSFTNG P10.phx.gbl...
I respectfully disagree. Thank you for your overly helpful advice.

-joe

"Kevin Spencer" <ke***@takempis .com> wrote in message
news:uW******** ******@TK2MSFTN GP12.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" <jo********@hot mail.com> wrote in message
news:O1******** ******@TK2MSFTN GP12.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" <ke***@takempis .com> wrote in message
news:OV******** ******@tk2msftn gp13.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" <jo********@hot mail.com> wrote in message
> news:u5******** ******@TK2MSFTN GP12.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.Sql Client.SqlExcep tion: General network error. Check your > > network documentation.
> > at System.Data.Sql Client.SqlConne ction.OnError(S qlException
exception,
> > TdsParserState state)
> > at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion > > exception, TdsParserState state)
> > at System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning()
> > at System.Data.Sql Client.TdsParse r.ReadNetlib(In t32 bytesExpected) > > at System.Data.Sql Client.TdsParse r.ReadBuffer()
> > at System.Data.Sql Client.TdsParse r.ReadByteArray (Byte[] buff, Int32 > > offset, Int32 len)
> > at System.Data.Sql Client.TdsParse r.ReadEncodingC har(Int32 length, > > Encoding encoding)
> > at System.Data.Sql Client.TdsParse r.ReadSqlValue( _SqlMetaData md, Int32
> > length)
> > at System.Data.Sql Client.TdsParse r.ProcessRow(_S qlMetaData[]

columns,
> > Object[] buffer, Int32[] map, Boolean useSQLTypes)
> > at System.Data.Sql Client.SqlDataR eader.PrepareSQ LRecord(Int32 i) > > at System.Data.Sql Client.SqlDataR eader.GetSqlStr ing(Int32 i)
> > at System.Data.Sql Client.SqlDataR eader.GetString (Int32 i)
> >
> >
>
>



Nov 18 '05 #7
Bill-

I appreciate you taking the time to make such a detailed response. We are
going to take your advice and look at better instrumenting our application
to collect more meaningful data. We've realized that although we'll keep
working with MS on the issue, the solution will probably come from within.

I'll respond back to these groups when we make progress.

Thanks
-joe

"Bill Breitmayer" <bi************ @worldnet.att.n et> wrote in message
news:pM******** *************@b gtnsc05-news.ops.worldn et.att.net...
Joe -

At the risk of being 'overly' helpful, I would suggest that you may be
making too many assumptions about the operational data, for example the MS
assertion that no packets are being lost. The monitoring tools are not
infallible and they may in fact be wrong ( it even happened to me once long ago ;-).

It sounds like MS is looking primarily at configuration data and not
performance data. Interaction under load between IIS and .NET may be
creating contention for resources or devices. If the queries are returning 'large' amounts of data, then the workload is not light, it's heavy and
there may well be a performance bottleneck in the server or network. It
could even be caused by a bad driver for a network device. Find every error log and run every monitor on the system. There may be a lower level problem within the apparent problem.

I'd also look very closely at application level performance, particularly
the heavy hitters, to see if you can reduce sudden bursts of demand. If the heavy hitters are not critical, slow them down and spread out the demand.
If your delivery date is in extreme unction, you may even need to redesign
the queries to work around it.

In any case, I think you may need to fully instrument your server, collect
all the configuration and operation data available and do a more complete
analysis of your system. I've run across problems with complex interactions in the past and a strictly analytic approach was the only way out.

For what it's worth ....

- Bill Breitmayer

"Joe Ross" <jo********@hot mail.com> wrote in message
news:Oa******** *****@TK2MSFTNG P10.phx.gbl...
I respectfully disagree. Thank you for your overly helpful advice.

-joe

"Kevin Spencer" <ke***@takempis .com> wrote in message
news:uW******** ******@TK2MSFTN GP12.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" <jo********@hot mail.com> wrote in message
news:O1******** ******@TK2MSFTN GP12.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" <ke***@takempis .com> wrote in message
> news:OV******** ******@tk2msftn gp13.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" <jo********@hot mail.com> wrote in message
> > news:u5******** ******@TK2MSFTN GP12.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.Sql Client.SqlExcep tion: General network error.
Check your
> > > network documentation.
> > > at System.Data.Sql Client.SqlConne ction.OnError(S qlException
> exception,
> > > TdsParserState state)
> > > at

System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
> > > exception, TdsParserState state)
> > > at System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning()
> > > at System.Data.Sql Client.TdsParse r.ReadNetlib(In t32

bytesExpected)
> > > at System.Data.Sql Client.TdsParse r.ReadBuffer()
> > > at System.Data.Sql Client.TdsParse r.ReadByteArray (Byte[] buff,

Int32
> > > offset, Int32 len)
> > > at System.Data.Sql Client.TdsParse r.ReadEncodingC har(Int32

length, > > > Encoding encoding)
> > > at System.Data.Sql Client.TdsParse r.ReadSqlValue( _SqlMetaData md, > Int32
> > > length)
> > > at System.Data.Sql Client.TdsParse r.ProcessRow(_S qlMetaData[]
columns,
> > > Object[] buffer, Int32[] map, Boolean useSQLTypes)
> > > at System.Data.Sql Client.SqlDataR eader.PrepareSQ LRecord(Int32 i) > > > at System.Data.Sql Client.SqlDataR eader.GetSqlStr ing(Int32 i)
> > > at System.Data.Sql Client.SqlDataR eader.GetString (Int32 i)
> > >
> > >
> >
> >
>
>



Nov 18 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2602
by: stanley j Mroczek | last post by:
Every thing is on one machine, Programs and sql. Sql is up and running(can test with query analyzer). No changes where made! This was working fine. How do you track this error? What network documentation? Nothing shows in the event viewer. where do I start? General network error. Check your network documentation. Description: An unhandled exception occurred during the execution of the current web request. Please review the
2
5066
by: SteveS | last post by:
Hello all. This problem is stumping me.... I run a page called "default.aspx". For some reason when I execute this page, I get the error below. It seems to run through the entire code behind just find (including all the sql steps), but after the Page_Load() event I get this error. I really don't know why. Any ideas? ================================================================== General network error. Check your network...
7
442
by: stan | last post by:
I have .net 2003 and SQL 2000 setup on one system. All I have is one computer (no network). I am able to get to the internet that works. I can run SQL Query Analyzer and it works. The program was running fine. I did not make any changes to the program or the stored procedures. But I am now getting this error. I don't know what or where to check for error. General network error. Check your network documentation. Description: An...
0
1686
by: David Sworder | last post by:
Hi there, I am using the SQL managed provider in ADO.NET to fill a dataset with a large number of records. I periodically get an exception with the description "General Network Error" when trying to fill the dataset. The problem occurs rarely. I've searched Google and have seen many posts dealing with this problem. The typical culprits are: Network Problems: A bad cable, NIC, or router can cause this problem. In my case, however, both the...
11
10859
by: galina betz | last post by:
Please help! Getting this error intermittently: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
3
2278
by: Yong | last post by:
I get a general network error when I try to make asynchronously call ExecuteNonQuery on long sql statements that run in parallel. Here is the background info on what I'm trying to accomplish: I have a sql file with two long T-SQL batches, each of which contains about 50 thousand simple insert statments into 2 non-indexed tables. Batch 1 inserts into Table 1 and batch 2 inserts into Table 2, so they can run in parallel. I parse each...
0
1523
by: Yong | last post by:
I'm not getting any reply to my previous thread so I'm stating a new one. I get a General Network Error due to my SqlCommand object not having a big enough CommandTimeout to complete very long sql statements. My question is this: Why does SQL generate a General Network Error instead of the Timeout Expired Error? When I run my program multiple times, there are cases where I'd get the Timeout Expired Error ("The timeout period elapsed...
0
2198
by: johnkamal | last post by:
Hi, Some times while opening a page, I am getting the following error message, Please help me to rectify the problem. Server Error in '/' Application. General network error. Check your network documentation. Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception...
0
9846
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10897
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10583
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10280
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9419
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5679
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5859
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4056
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3128
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.