Roll back in vertica database

Hi,
I am facing issue like how to rollback vertica transition if any node get failed . I have list of files to process/load in vertica , am using variable loop start to iterate all files.
Anyone can suggest ???

Hi @amar.khavare -

Have you tried the DB Transaction Start / End nodes introduced in KNIME 4.1? This example workflow should give you an idea of how they work.

You can also read more about them in the documentation here:

https://docs.knime.com/latest/db_extension_guide/index.html#transaction_nodes

Does that help?

2 Likes

thanks @ScottF … Yes i have tried but in loop DB transaction not allowed plus am having two db connector vertica (actual data ) and MariaDB (Tracker data) .

I think we need some more detail here. Could you post an example workflow showing your approach, what you expect to happen, and how it’s failing? And maybe some relevant log or error messages?

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.