@cridiaz using KNIME in batch modus is somewhat of a hack and not really recommended. So if you want to use it anyway you might have to help us debug this one. So maybe first you could answer the additional questions about remote/cloud drive and R and JDBC drivers
Then you could maybe provide us with a log file in DEBUG mode: