I’m having issues with the DB Merge node not finishing execution. It starts executing and shows 0%, but never finishes (at least within an hour, then I gave up). It’s also impossible to stop execution. I have to exit the workflow.
I’m using Knime 4.4.0. My table is on Snowflake, it contains 15 columns (strings, numbers, date&time) and ca. 1,700 rows. Interestingly, I have another table that’s identical to this one except that it has less than 10 rows. When I apply the identical operation to this table with the DB Merge node, it executes in 1-2 seconds.
Does anyone know how I could solve this problem? Thanks in advance!
Would you be able to turn on debug for logging within the preferences → KNIME tab, and select the debug radio button, then restart KNIME and run the workflow with the issue, as well as the workflow that runs fine (the one with less than 10 rows), and send us the output of the log? The console should tell you where your log file is located.
I am also curious if you can try another workflow where the number of rows is somewhere around 200 rows and see if it executes still?
Does the identical Table also contain the same number of columns?
What is the operation that you are applying to the Table?
Once we get a bit more information, hopefully we can help narrow this down and solve your issue.
Thanks, Zack. While waiting for a response I found a workaround and moved on. If I have time to get back to the problem and test the above I’ll let you know the outcome.