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?)

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 !

1 Like