โ02-24-2021 08:00 AM
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.
โ02-24-2021 08:51 AM
Does this happen during validation, or only during execution? If only during validation, try holding the Shift key as you click the validate icon, or click the Retry link if that is shown. This will avoid using cached data, which can sometimes lead to errors like youโre seeing because of the way that data is serialized to the cache during one validation and then deserialized from the cache on a subsequent validation. Values of types such as Integer will become normalized to other types like BigInteger in the process of serialization/deserialization.
โ02-24-2021 08:55 AM
I realize you said โAll works fine in validationโ, but I just want to be sure Iโm understanding you correctly. Iโve only seen the โNot Comparable Objectsโ error during validation when it was using cached data from a previous validation.
Also, do you have a stack trace from the Pipeline Statistics window? If so, please post it here using a Preformatted Text block (</>).
โ03-01-2021 02:49 AM
Hi,
It works in validation if I give it a static value. So, if I have the expression, $propertyid == 123456, itโll work fine in validation, but then I get the error if I try to execute it. If I have $propertyid == propId, itโll fail both in validation and execution with the same error (which is the same as the other error message).
Reason:
Not comparable objects: BigInteger 350930 and Integer 350930
Hide Details...
Join[5fd9a86c47060ece477be9b6_087b0009-f8f6-4091-a8c5-3223a624649d -- 15187eed-c7f4-4a27-941c-19d928dcf354]
com.snaplogic.snap.api.SnapDataException: Failed to perform join operation
at com.snaplogic.snaps.transform.MultiJoin.execute(MultiJoin.java:216)
at com.snaplogic.cc.snap.common.SnapRunnableImpl.executeSnap(SnapRunnableImpl.java:770)
at com.snaplogic.cc.snap.common.SnapRunnableImpl.execute(SnapRunnableImpl.java:552)
at com.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:836)
at com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:402)
at com.snaplogic.cc.snap.common.SnapRunn ableImpl.call(SnapRunnableImpl.java:116)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Reason: Not comparable objects: BigInteger 350930 and Integer 350930
Resolution: Please address the reported issue.
Error Fingerprint[0] = efp:com.snaplogic.snaps.transform.Ix2j0m3w
โ03-01-2021 08:54 AM
Sorry, Iโm not understanding this expression and what itโs referring to. Can you show the context where youโre using it?