Hello community. I have workflow with DB Connector which is connected to Oracle DB. In normal mode(Knime run) it works fine, however using batch mode(Win scheduler + *bat file) it doesn’t work unfortunately. Any advises? [2020-05-20_105411]

Hi @EvgeniyKvitnitskiy , maybe as a workaround. Did you try with the old legency database nodes as well? In the past (like 3-4 years ago) they worked for me in batch mode :slight_smile: From the error message it seems like it does not manage to load the db-driver profile :confused: (just guessing maybe it is really just a warning) Did you execute the batch with the knime folder as execution folder? Does your execution batch specify the -preferences=file.epf parameter (with an file.epf containing the correct db profile?)

Please check this post - [image] Execution of Knime Workflow in Batch Mode KNIME Analytics Platform On the surface, running KNIME in batch looks relatively easy and it is. But its all the small details that can make it complex. The trick is to create a generic, highly parameterized batch job that can run any KNIME workflow. I’ve attached two sample Powershell scripts that will run 1 to many KNIME workflows. When one fails, execution will halt (that behavior can be changed). In my example, I included execution of workflows that have variables in them like Database server URL which are set a… Powershell script by @ScottMcLeodPSLGroup is really cool !

But it works perfect if I run WF manually…

[image] AnotherFraudUser: Did you try with the old legency database nodes as well? Thanks for that, I replace DB connector and DB reader to old one ant it works perfect. So something wrong with new nodes.

Great! It could be that somewhat the batch does not get the correct db profile configuration. I got a similar Problem where our KNIME Server did not have the correct configuration for the new db nodes, while the knime executor on the same server could run the same workflow without problems :slight_smile: Maybe @tobias.koetter knows more what to check when using the new db nodes together with batch mode

DB Connector failing while batch execution

KNIME Analytics Platform

dyagaty May 20, 2020, 5:19pm 3

Please check this post -

Powershell script by @ScottMcLeodPSLGroup is really cool !