Does that other ETL process work with the same database(what Oracle users might call a schema)?
https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html
The problem here is that unicode has a few problems, so it can’t be supported 100%, and everything and everyone support it a bit differently. The default is often ASCII, and if you want to support unicode:
One good thing though, these are unicode, so it SHOULD be doable:
From wikipedia…
“The Unicode codepoints for the letter are U+0142 for the lower case, and U+0141 for the capital.[11] In the LaTeX typesetting system Ł and ł may be typeset with the commands \L{} and \l{}, respectively. The HTML-codes are Ł and ł for Ł and ł, respectively.”
Your first task should be to run the process with a few of the offending records in preview mode. Check the target(just before the converter in the preview window). If it is right, the problem is with the target driver, or some target centric area. Check the source. If it is bad, the problem is with the source driver, or some source centric area. THEY are usually the culprit. Then maybe try key points in between to find one that fails, and work back from there.
OH, and if you are using an oracle version prior to 12(I forget the EXACT version in 12 where they fixed it), and you find the problem is THERE, it might be an ENVIRONMENT problem. You will have to fix the environment(it is just a couple environment variable settings)
and restart the drivers and/or snaplex.
@Shaily - If the first child pipeline has an open output view and there are no documents output from that snap, then you have effectively stopped execution and the second child can’t be called.
Keep in mind that SnapLogic works with streaming data, so if you stop the stream, there is nothing to continue with. Almost all snaps will not execute if there is no input coming into the input view.
I do agree with @darshthakkar that consulting the documentation is a good action to understand Pipeline Execute better.
Welcome to the community, Shaily!
Did you get a chance to go through the documentation on usage of Pipeline Execute snap? Click on this link to access the same.
As far as I could understand, in order to use 2 pipeline execute snaps, can you use a copy snap before the pipeline execute as below?
Also, I would suggest to follow the naming convention while renaming the snap, not to use spaces (although it has nothing to do with the functionality but a good practice to follow).
A couple of questions:
1. Do you want error to be generated from the first pipeline execute snap? If yes, you need to enable that view.
2. Which data are you wanting to put in the second pipeline execute, is it the same as first pipeline execute? If that’s the case, copy snap would help. If you have some conditions, I would recommend using a router snap.
3. As per the screenshot provided, there is no parameter you’re passing in the pipeline execute, what exactly are you trying to achieve?
Please go through the documentation on naming convention too.
Thanks!
Best Regards,
Darsh
