June 20, 2002 at 9:44 am
Hi
I have a VB app which adds a new record to a recordset
object, the recordset then issues an update command but
SOMETIMES receives a time out error. I can see no
evedience of blocking. (There is a username/password field
which is randomly generated but does cause a violation of
unique constraint. This is handled and the update
cancelled in the code and a new random value is generated.)
When I use profiler
I see the SP:StmtStarting for the statement, I then see
the following
Event Event Sub Severity Integer Data
Class
Attention
Exception 6 25 822
Exception 6 25 822
Exception 8 25 3617
Exception 0 25 3617
Exception 0 25 3617
Is the Attention event raised by the client beacuse the
inital Insert failed? Could anyone point me in the right
direction?
Any help would be greatly appreciated, thanks in advance.
Harish
June 20, 2002 at 7:23 pm
Run again but turn on the text data column it should hold the actually text message. I believe thou you are getting a "timeout waiting for server to answer" and "not enough resources available". What version of SQL are you running and have you tried looking at CPU and Memory usage on the server.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 21, 2002 at 9:42 am
Hi Antares
Thanks for the advice, I checked the text column on a previously saved trace table, it was null. We are running version 7 not sure about Service Packs. The problem happend again but I couldn't run performance monitor (Im not sysad) but they will do for me next time, so I will let you know.
Do you have any ideas about the 822 error bol says this means problems with db files? Yet no mention of this in the error logs?
Thanks for the pointers
Harish
quote:
Run again but turn on the text data column it should hold the actually text message. I believe thou you are getting a "timeout waiting for server to answer" and "not enough resources available". What version of SQL are you running and have you tried looking at CPU and Memory usage on the server."Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply