Rilson Nascimento (ron2@cin.ufpe.br) writes:
> I need your valuable help to correct an error that is happening during a
> workload test with SQL Server 2000, below I give more information about
> the problem:
>
> Error:
> 32420 -1 0 3267434067953 2003/07/17 12:34:27.953 WARNING 2: An error=10054
> (type=7, loc=(null)) occured in thread for w_id=3019, d_id=6
> 32421 -1 0 3267434067953 2003/07/17 12:34:27.953 WARNING Server01 Thread
> for w_id=3019, d_id=6 is terminating.

It is not clear to me which program that generates this output. It does
not look like the SQL Server error log to me.

The link suggested by Jens Doose was obviously not relevant. He pointed
you to a DB-Library error, and I doubt that you use DB-Library.

Message 10054 in SQL Server is "The data value for one or more columns
overflowed the type used by the provider.", which could apply to your
situation - but you would have to stretch it a bit.

Since I don't really from where this message is coming and whether it
is related to SQL Server at all, I cannot really assist any better than
this.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Hi Erland,

thank you for your reply.

Indeed the error message is not being generated on SQL Server error log.
This error is being captured on the Remote Terminal Emulator (RTE) machines.
I have already seen the SQL Server log and Event Viewer but found nothing
relevant there.

The transaction flow is depicted below:

RTE <---http---> WEB SERVER <---odbc---> SQL SERVER

The error is captured on the RTE log, which has a software for generate
workload
and record errors and response time. As the RTE is at the end of the chain,
I suppose
the error can be occurring anywhere between RTE and SQL Server, including
the
very network as well.
The first problem is precisely what your stated: I don't know where this
message is coming from.

I suspect from a network error, due to the fact that as the error starts to
come up
the user connections are being closed at the same pace.

The likelihood of being a type-overflowing error is minimal, since the
population of emulated
users is very well controlled regarding the range of values they can
randomly use to generate transactions.


"Erland Sommarskog" <sommar@algonet.se> wrote in message
news:Xns93C03D7C134Yazorman@127.0.0.1...
> Rilson Nascimento (ron2@cin.ufpe.br) writes:
> > I need your valuable help to correct an error that is happening during a
> > workload test with SQL Server 2000, below I give more information about
> > the problem:
> >
> > Error:
> > 32420 -1 0 3267434067953 2003/07/17 12:34:27.953 WARNING 2: An
error=10054
> > (type=7, loc=(null)) occured in thread for w_id=3019, d_id=6
> > 32421 -1 0 3267434067953 2003/07/17 12:34:27.953 WARNING Server01 Thread
> > for w_id=3019, d_id=6 is terminating.
>
> It is not clear to me which program that generates this output. It does
> not look like the SQL Server error log to me.
>
> The link suggested by Jens Doose was obviously not relevant. He pointed
> you to a DB-Library error, and I doubt that you use DB-Library.
>
> Message 10054 in SQL Server is "The data value for one or more columns
> overflowed the type used by the provider.", which could apply to your
> situation - but you would have to stretch it a bit.
>
> Since I don't really from where this message is coming and whether it
> is related to SQL Server at all, I cannot really assist any better than
> this.
>
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@algonet.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp