When you get the error "Specified cast is not valid." repeatedly

Gonçalo Veiga

Question

This error might occur, for example, when you're trying to put a text value into a number field, which is not convertible. OutSystems' TrueChange engine usually catches all of these ocurrences, but they might happen where we have most freedom, like in Advanced Queries.

If this mistake happens to occur in the input or OrderBy field and the filter is in session, then you might loose a lot of time looking for a mistake that is no longer there. The error is beig caused by the value which is still in session!!

The solution is, obviously, to log-out or close the browser, for example. You might also solve it, like I did, by just leaving for the day and, by the next day, the problem will be solved, because the session expired! :-)

I'm just posting this for future reference.

10 Dec 2009

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines