Forum Discussion

chrisbodman's avatar
chrisbodman
New Contributor II
5 years ago

Not Comparable Objects: BigInteger 350930 and Integer 350930

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 ...
  • ptaylor's avatar
    ptaylor
    Employee
    5 years ago
    Copy LinkReport

    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 (</>).

    • chrisbodman's avatar
      chrisbodman
      New Contributor II
      5 years ago
      Copy LinkReport

      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
      • ptaylor's avatar
        ptaylor
        Employee
        5 years ago
        Copy LinkReport

        Sorry, I’m not understanding this expression and what it’s referring to. Can you show the context where you’re using it?