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?