Forum Discussion

Pretty's avatar
Pretty
New Contributor III
4 years ago

How to give multiple key columns in join?

I have multiple tables and I need to join them all with different key columns by using the join snap, but it is resulting in the following error:-Failure: Right join path not found for input2, Reason...
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?

  • Aleksandar_A's avatar
    Aleksandar_A
    Contributor III
    3 years ago
    Copy LinkReport

    Hello @SL12345,

    Yes it is possible to update the Snaplex on a scheduled task, but you should use $parameters.runtime_path_id parameter.

    Let me know if this helps you.

    Regards,
    Aleksandar.

    • SL12345's avatar
      SL12345
      New Contributor III
      3 years ago
      Copy LinkReport

      Hi Alexandar,

      Unfortunately, it doesn’t work

      my mapper looks like this:

      i will get an error:

      Reason: Failed with status code: 400 [error: {“error_list”:[{“message”:“runtime_path_id:‘out-Snaplex’ does not match ‘[1]+/rt/\\w+/[\\w\\-+.]+$’”}]}]

      ‘out-Snaplex’ is the name of our snaplex which can be set in scheduled task manually via manager

      1. \\w\\.- ↩︎

      • Aleksandar_A's avatar
        Aleksandar_A
        Contributor III
        3 years ago
        Copy LinkReport

        Here is what you can try to do:

        1.Read a task that uses the wanted Snaplex, and retrieve the runtime_path_id from there.
        2.Use that value to update the task using the Mapper above.

        I’ve tried on my own and it works fine, but keep in mind that the Snaplex Name from the Drop Down Menu in the Manager is different that the runtime_path_id.

        Let me know if you need further clarification.

        Regards,
        Aleksandar.