I’ve just experienced DB Writer Node obviously ignoring Remove Existing Table option checked in a workflow.
The workflow walks over a list of tables to be copied from a PostgreSQL database to an MS SQL Database in a loop. In the first loop iteration, the DB Writer failed with a Null Pointer Exception. There was a “Execute failed: (“NullPointerException”): data” entry in my log. I noticed the table was created and filled with the data in MS SQL Database (The Number of rows was as expected too). I unchecked “Append write status column” option as an attempt to solve the issue (I learnt subsequently this didn’t help) and re-executed the node. Now I got “Execute failed: There is already an object named ‘sat_tekstavu’ in the database.” error message despite having “Remove existing table” option checked.
Attaching a console log output. DB Writer obviously ignores Remove Existing Table option.log (197.4 KB)
This is how my workflow looks like:
And here I’m attaching an export of my workflow: DWH to MS SQL.knwf (515.9 KB)