Not Comparable Objects: BigInteger 350930 and Integer 350930

[chrisbodman]

I’ve done a join to 5 tables. All works fine in validation. No errors at all. If I use a specific value in the where clause in the 4 SQL Selects, it’ll run fine. If I give it a parameter (instead of a hardcoded value). I get the error “Not Comparable Objects: BigInteger 350930 and Integer 350930”. They’re exactly the same field type in the DB. If I replace $PropertyId with 350930, it’ll work. It’s getting the values, as they’re shown in the error. I’ve tried casting them both to the same time (Integer, Float, and String), and then I get the error that they’re not ascending, if I change to ascending, I get an error saying they’re not descending, etc etc.

[viktor_n]

Hi @chrisbodman,

First, you need to parse fields to be the same data type(before be passed in Join) also you need to set “Sorted streams” in Join to “Unsorted” or put Sort snap on each Join input and set “Sorted streams” to the way you sorted in Sort snap(ascending or descending).

Hope this will solve your problem. 🙂

Regards.
Viktor Nedanovski