Timeout Problem with long running queries....

[tajeshwar]

Hi all,

This is second time I am posting my problem out here. I have written an
app which do some real data crunching in a stored procedure.
Now if this processing long time my connection breaks in between and I
receive timeout error. In my case this pattern repeats again and again
(about 50 times by now...) in which the query timeouts after approx 18
hours. When I run profiler I see an Attention Eventclass message
which basically means connection breaking. Nothing comes in sql error
logs.

Recently I was able to lay my hands on a KB article which says that
their is a known bug that setting commantimeout = 0 doesn't work properly
in
some scenarios and microsoft is coming up with some hotfix. But it is
not available to general community :-(. I am unable to find it yet.......

Is my problem related to this. I am also attaching the KB article which
talks abt this bug (Microsoft Knowledge Base Article - 823679)

TIA

Tajeshwar

 

[Sushil Chordia]

Tajeshwar, Setting CommandTimeout to 0 might be the problem. This is problem
is fixed with v2 (Whidbey Beta), You need to contact PSS for requesting a
fix for 1.1. As a workaround, please use a value < 32Kb for a timeout, For
example: 32000.

 

[tajeshwar]

Thanks Sushil,

But my calculations can take more than 8 hours. And 32000 sec will provide
me just

about 9 hours. Is their no other way to get this thing corrected.......

Regards,

Tajeshwar