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...
Forum Discussion
Hi @ptaylor
Thank you for help.
it worked if provide key and Initialization vector details in snap it self.
but it did not worked if i consider key to be taken from account and Initialization vector information in snap it self.
below configuration worked
But if select account for key its not working.
The Passphrase-Based Key account generates a random seed every time it’s used, so the ciphertext will be different each time, even if the input, passphrase and IV haven’t changed.
If having consistent ciphertext is important to you, use a KeyStore account instead. You create a symmetric key and store it in a keystore file, then configure the account with that file plus a password and alias to access that key. Here’s an example of how to create a keystore ks.jks containing a 128-bit AES key with password mypassword and alias myalias:
keytool -genseckey -keyalg AES -keysize 128 -storepass mypassword -alias myalias -storetype JCEKS -keystore ks.jks
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.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
\\w\\.- ↩︎
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.
