# DB Connector failing while batch execution **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [May 20, 2020, 7:57am UTC](https://forum.knime.com/t/db-connector-failing-while-batch-execution/23937 "2020-05-20T07:57:23Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![EvgeniyKvitnitskiy](https://forum-cdn.knime.com/user_avatar/forum.knime.com/evgeniykvitnitskiy/32/5613_2.png) [@EvgeniyKvitnitskiy](https://forum.knime.com/u/EvgeniyKvitnitskiy)\ **Post date:** [May 20, 2020, 7:57am UTC](https://forum.knime.com/t/db-connector-failing-while-batch-execution/23937/1 "2020-05-20T07:57:23Z")
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](https://forum-cdn.knime.com/uploads/default/original/3X/3/9/3999d202821387e9b5b5ac3659bfd8390ca91ec6.png) ---
**Author:** ![AnotherFraudUser](https://forum-cdn.knime.com/user_avatar/forum.knime.com/anotherfrauduser/32/16912_2.png) [@AnotherFraudUser](https://forum.knime.com/u/AnotherFraudUser)\ **Post date:** [May 20, 2020, 3:41pm UTC](https://forum.knime.com/t/db-connector-failing-while-batch-execution/23937/2 "2020-05-20T15:41:09Z")
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 🙂 From the error message it seems like it does not manage to load the db-driver profile 😕 (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?) ---
**Author:** ![dyagaty](https://forum-cdn.knime.com/user_avatar/forum.knime.com/dyagaty/32/16890_2.png) [@dyagaty](https://forum.knime.com/u/dyagaty)\ **Post date:** [May 20, 2020, 5:19pm UTC](https://forum.knime.com/t/db-connector-failing-while-batch-execution/23937/3 "2020-05-20T17:19:21Z")
Please check this post - > [@Execution of Knime Workflow in Batch Mode](https://forum.knime.com/t/execution-of-knime-workflow-in-batch-mode/10946/3): > > 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 ! ---
**Author:** ![EvgeniyKvitnitskiy](https://forum-cdn.knime.com/user_avatar/forum.knime.com/evgeniykvitnitskiy/32/5613_2.png) [@EvgeniyKvitnitskiy](https://forum.knime.com/u/EvgeniyKvitnitskiy)\ **Post date:** [May 21, 2020, 3:24pm UTC](https://forum.knime.com/t/db-connector-failing-while-batch-execution/23937/4 "2020-05-21T15:24:43Z")
But it works perfect if I run WF manually… ---
**Author:** ![EvgeniyKvitnitskiy](https://forum-cdn.knime.com/user_avatar/forum.knime.com/evgeniykvitnitskiy/32/5613_2.png) [@EvgeniyKvitnitskiy](https://forum.knime.com/u/EvgeniyKvitnitskiy)\ **Post date:** [May 21, 2020, 4:04pm UTC](https://forum.knime.com/t/db-connector-failing-while-batch-execution/23937/5 "2020-05-21T16:04:39Z")
> [@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. ---
**Author:** ![AnotherFraudUser](https://forum-cdn.knime.com/user_avatar/forum.knime.com/anotherfrauduser/32/16912_2.png) [@AnotherFraudUser](https://forum.knime.com/u/AnotherFraudUser)\ **Post date:** [May 21, 2020, 4:55pm UTC](https://forum.knime.com/t/db-connector-failing-while-batch-execution/23937/6 "2020-05-21T16:55:29Z")
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 🙂 Maybe @tobias.koetter knows more what to check when using the new db nodes together with batch mode ---
**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\ **Post date:** [May 28, 2020, 4:55pm UTC](https://forum.knime.com/t/db-connector-failing-while-batch-execution/23937/7 "2020-05-28T16:55:32Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.