Workflow runs fine but fails in batch mode with Microsoft SQL Server Connector (legacy) and Database Reader (legacy)

Hi everyone,
I have a workflow that contains
Microsoft SQL Server Connector (legacy)
Database Reader (legacy)

When I run it with KNIME directly it works fine and doesnt take long, but when I try to run it with the batch mode it doesnt work.
I tried removing the DB nodes and it works with the batch mode.
So I know there is a problem with this.

Does somebody has an idea of why is this not working?

I get the following error:

Java was started but returned exit code=4
-Dequinox.statechange.timeout=90000
-server
-Dsun.java2d.d3d=false
-Dosgi.classloader.lock=classname
-XX:+UnlockDiagnosticVMOptions
-XX:+UnsyncloadClass
-XX:+UseG1GC
-Dsun.net.client.defaultReadTimeout=0
-XX:CompileCommand=exclude,javax/swing/text/GlyphView,getBreakSpot
-Xmx15166m
-Dorg.eclipse.swt.browser.IEVersion=10001
-Dsun.awt.noerasebackground=true
-Dequinox.statechange.timeout=30000
-Djava.library.path=C:\Users(my username)\KNIME-DEPLOYMENT\knime_bin
-Djava.class.path=C:\Users(my username)\KNIME-DEPLOYMENT\knime_bin\plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
-os win32
-ws win32
-arch x86_64
-launcher C:\Users(my username)\KNIME-DEPLOYMENT\knime_bin\knime.exe
-name Knime
–launcher.library C:\Users(my username)\KNIME-DEPLOYMENT\knime_bin\plugins/org.eclipse.equinox.launcher.win32.win32.x86_64_1.1.551.v20171108-1834\eclipse_1630.dll
-startup C:\Users(my username)\KNIME-DEPLOYMENT\knime_bin\plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
–launcher.overrideVmargs
-nosave
-application org.knime.product.KNIME_BATCH_APPLICATION
-workflowDir=C:\Users(my username)\KNIME-DEPLOYMENT\workspace\SIP_c\SIP SILO(7)
-vm C:\Users(my username)\KNIME-DEPLOYMENT\knime_bin\plugins/org.knime.binary.jre.win32.x86_64_1.8.0.202-b08/jre/bin\server\jvm.dll
-vmargs
-Dequinox.statechange.timeout=90000
-server
-Dsun.java2d.d3d=false
-Dosgi.classloader.lock=classname
-XX:+UnlockDiagnosticVMOptions
-XX:+UnsyncloadClass
-XX:+UseG1GC
-Dsun.net.client.defaultReadTimeout=0
-XX:CompileCommand=exclude,javax/swing/text/GlyphView,getBreakSpot
-Xmx15166m
-Dorg.eclipse.swt.browser.IEVersion=10001
-Dsun.awt.noerasebackground=true
-Dequinox.statechange.timeout=30000
-Djava.library.path=C:\Users(my username)\KNIME-DEPLOYMENT\knime_bin
-Djava.class.path=C:\Users(my username)\KNIME-DEPLOYMENT\knime_bin\plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar

Thank you

1 Like

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