I figured this one out. You can’t add paths to null objects.
Since ACHData is null for the second record, it’s impossible to add ACHData.employeeId. If I reverse the order of the rows in the mapper then the result is that ACHData is null for the record, because ACHData.employeeId is set by the first row and then everything is cleared by the second row.
This is currently undocumented behavior.
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 (</>).
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
Sorry, I’m not understanding this expression and what it’s referring to. Can you show the context where you’re using it?
