I'm going to disagree. I think in this situation is was a failure. Sure you can tell yourself that it should be caught now (and it should) but...

I agree the problem is probably with your query.  Since it's dynamic make sure you are properly joining your tables (if you're joining) and make sure your where clause is...