Hi,
I have a simple workflow where there is Snowflake connector and DB query reader.
It doesn’t work in batch mode, although it works fine while opened in Knime software (both directly or by using “Call local workflow” node).
The log shows this error:
ERROR : KNIME-Worker-1-Snowflake Connector 0:982 : : Node : Snowflake Connector : 0:982 : Execute failed: JDBC driver encountered communication error. Message: Cannot run program “xdg-open”: CreateProcess error=2, The system cannot find the file specified.
net.snowflake.client.jdbc.SnowflakeSQLLoggedException: JDBC driver encountered communication error. Message: Cannot run program “xdg-open”: CreateProcess error=2, The system cannot find the file specified.
at net.snowflake.client.jdbc.DefaultSFConnectionHandler.initialize(DefaultSFConnectionHandler.java:109)
at net.snowflake.client.jdbc.DefaultSFConnectionHandler.initializeConnection(DefaultSFConnectionHandler.java:79)
at net.snowflake.client.jdbc.SnowflakeConnectionV1.initConnectionWithImpl(SnowflakeConnectionV1.java:116)
at net.snowflake.client.jdbc.SnowflakeConnectionV1.(SnowflakeConnectionV1.java:96)
at net.snowflake.client.jdbc.SnowflakeDriver.connect(SnowflakeDriver.java:164)
at org.knime.database.connection.UrlDBConnectionController$ControlledDriver.connect(UrlDBConnectionController.java:95)
at org.knime.database.connection.UrlDBConnectionController.createConnection(UrlDBConnectionController.java:308)
at org.knime.database.connection.UserDBConnectionController.createConnection(UserDBConnectionController.java:249)
at org.knime.database.connection.AbstractConnectionProvider.createConnection(AbstractConnectionProvider.java:89)
at org.knime.database.connection.impl.DBConnectionManager.lambda$2(DBConnectionManager.java:501)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Some details:
Knime version - 4.4 (zip file, no installation)
Snowflake connection - happens through OKTA (mobile push confirmation)
Batch parameters - “X:\knime4.4\knime.exe” --launcher.suppressErrors -nosave -reset -nosplash -application org.knime.product.KNIME_BATCH_APPLICATION -data “X:\logfolder” -workflowDir=“X:\workflow”
Any way to get through this?
P.S. - my first post here, but let me say that I’m a huge fan of Knime, absolutely adore it.