Under specific circumstances a tester was able to trigger a bug. The steps leading up to tripping said bug were given to me, then I spent three days pestering the tester to show me exactly what they were doing (I could not replicate the bug).

Lo and behold there were a grip of other steps in there. *sigh* Okay. I was able to distill a fifteen minutes of steps into about four minutes of pertinent actions that caused the problem. Fun. Unfortunately I spent the better part of four days sifting through one vb logic branch then had to jump to another. Then into a myriad of stored procedures. Great.

Thirty minutes ago I found the issue... it came down to reinitializing a variable to null. Why null? No idea. I don't care. All I care about is in this one specific procedure there are three if-statements. The variable in question is the output for a stored procedure called in each of those if statements. THAT procedure has internal logic that says 'if this value is null do this.. else do that'. The variable that controlled that was not being cleared out between if statements.

My fucking god. I am ecstatic that I found it. I am horrified that such an elementary thing occurred.

My mind hurts.