Click here to Skip to main content
14,644,142 members
Rate this:
Please Sign up or sign in to vote.
See more:
I'm trying to fix a bug which makes a scheduler we run at work crash every few days. It's the same task that is run every morning and I'd say that it fails 30% of the time.

From my computer where I work on the code I can't access one of the databases that's queried so atm I can't do more than add some logging to program and push it and hope it catches something interesting.

There are a few things that happens in the failing function that can cause the failure I think.

We append some info from the record sets to a string which is returned. And another record set gets updated with values from another record set and then updated.

So I'm curious if one record set say rs!numeric tries to be updated by something like rs!varchar could this throw a mismatch?
Posted
Comments
CHill60 28-May-15 4:27am
   
Yes.
Member 11683251 28-May-15 4:52am
   
Thanks! Then my extra log functions wont be in vain.
CHill60 28-May-15 4:55am
   
Definitely worth it! I used to put "levels" of logging in - highest level recorded virtually everything (trace), lowest level only errors - controlled via an INI file or other config.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100