Dear KNIME users,
I have made a workflow that accesses and downloads files from an SFTP server, lists the file names and then uses them as a variable to parse the files. In the end, the workflow uploads the information onto a Postgres DB. If I execute this workflow in Knime, it works without any problems, but I’d like it to be executed automatically daily. Therefore, I researched and found the batch execution. I’m entering the following code:
“C:\Program Files\KNIME\knime.exe” -consoleLog -noexit -nosplash -application org.knime.product.KNIME_BATCH_APPLICATION -workflowDir=“knime-workspace\KNIME_project”
Once I run it, it seems like the workflow does not execute the first node (SSH connector) to connect to the SFTP server.
This is part of what I’m getting when I execute it with the windows cmd:
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.knime.database.driver.DBDriverRegistry$DriverClassLoader (file:/C:/Program Files/KNIME/plugins/org.knime.database_4.4.0.v202105282026/knime-db-core.jar) to method java.lang.ClassLoader.findLibrary(java.lang.String)
WARNING: Please consider reporting this to the maintainers of org.knime.database.driver.DBDriverRegistry$DriverClassLoader
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
WARN main Node No connection available. Execute the connector node first.
WARN main Node Errors loading flow variables into node : Coding issue: Cannot create URL of data file from 'missing’in filereader config
WARN main Node Errors loading flow variables into node : Coding issue: Cannot create URL of data file from 'missing’in filereader config
WARN main Node Errors loading flow variables into node : Coding issue: Cannot create URL of data file from 'missing’in filereader config
WARN main Node Errors loading flow variables into node : Coding issue: Cannot create URL of data file from 'missing’in filereader config
MBean class org.knime.core.data.join.implementation.JoinImplementation$JoinProgressMonitor does not implement DynamicMBean, and neither follows the Standard MBean conventions (javax.management.NotCompliantMBeanException: Class org.knime.core.data.join.implementation.JoinImplementation$JoinProgressMonitor is not a JMX compliant Standard MBean) nor the MXBean conventions (javax.management.NotCompliantMBeanException: org.knime.core.data.join.implementation.JoinImplementation$JoinProgressMonitor: Class org.knime.core.data.join.implementation.JoinImplementation$JoinProgressMonitor is not a JMX compliant MXBean)
[…]
I hope you can help me!