Hi all, I’m currently doing the L2-DS course, Part 1, Exercise 4 on Date&Time Data Type & In-Database Processing.
For Activity II, I am getting this error when trying to run the H2 Connector node:
I have used the exact same configuration as the one in the solution workflow, but the error still persists.
Could anyone please advise? Thank you.
Hi @hozeping ,
Thank you for reporting this issue. As a quick workaround, I managed to execute the node by changing the version of the database driver to one of the older versions. I’ll try to find a better solution but this should solve the issue for now.
Best,
Lada
Hi @kundeng ,
Not sure I understand your question correctly, feel free to share more details on the issue you are describing if my answer is not helping:
I can see that two components that are supposed to have visualizations do have the layout:
The third component doesn’t need a layout as it doesn’t have visualizations.
Best,
Lada
Hi Everyone i’m having a problem with Excercise 4 Your First Data Pipeline in the L2-DE course, it´s my final excersice and i´m getting this error in my catch error block “Encountered scope-end whithout compatible head” i get that it means that doesn’t find the start of my try-catch but i checked the conections and solutions and still getting that error.
Could someone help me with this?
Hi @Sebastian_Arazo ,
thanks for reaching out! Did you try to re-execute the workflow from the Try node? This happens sometimes if you develop the nodes between the try&catch nodes and usually simple re-execution helps.
Let us know if you need more help.
Lada
Hi everyone! I’m with a problem in exercise “03 Date&Time Transformation & In-Database processing”, “Activity II: In-database processing: filtering, pivoting and sorting”.
Hi @AnDR3h0l4nDa ,
Thanks for reaching out. I tried this workflow in all the three L2 courses and the DB Writer works for me. My first guess is that maybe you provide the wrong table as input - the one that doesn’t have the column “Month (Number)” yet or maybe you named this column differently in the Date&Time Part Extractor node. This would then fail because 1) the database table already exists, 2) by default the rows will be appended to the existing table, 3) and in that case all the columns must be present with the same names in the new input table.
Could you please check that you send the correct table as input and if this doesn’t help tell us which KNIME Analytics Platform version you’re using, which L2 course you’re taking and send us a screenshot of the workflow including all the upstream nodes for DB Writer and a screenshot of the configuration windows of the DB Writer and Date&Time Part Extractor nodes? Thanks!
Best,
Lada
