KNIME_BATCH_APPLICATION Fails on Postgresql 11

KNIME Analytics Platform
1

Hi,

I want to test simple table read-write process from oracle 12.2.0.1.0 to postgresql 11.
I works in KNIME but when i want to run in batch file KNIME_BATCH_APPLICATION Fails.

Console says;

INFO main BatchExecutor ===== Executing workflow C:\Users\noy\knime-workspace\TEST =====
ERROR main BatchExecutor Workflow is locked by another KNIME instance
INFO main BatchExecutor ========= Workflow did not execute sucessfully ============

Can anyone help?

2

Hi there!

It means your workflow is already opened. I guess in your GUI. Close it there and run again. Opening a KNIME workflow creates a .knimeLock file in you workflow directory in knime-workspace which prevents others from calling it. Even from youself in batch mode :smiley:

Br,
Ivan

3

Hi,
GUI is close. Only batch file is running and there is no lock file.

4

Hi!

That is a bit weird. Can you try creating another workflow and run it in batch mode if you haven’t tried that? This will helps us see if it is only workflow related or not.

Also can you provide a bit more information like your KNIME version, OS you are running, KNIME log file after batch execution start?

Br,
Ivan

5

Hi,
It’s really weird.
I tried diffrent OS (windows 10, Windows 2016), different flows etc. Knime is the latest version 3.7.1.
I’m using ojdbc8.jar for oracle 12 db and postgresql-42.2.5.jar for postgresql 11
I tested both oracle to oracle, postgre to postgre with no error.
But oracle to postgre fail.
Here is the knime.log

2019-02-11 15:11:52,574 : DEBUG : main : WorkflowManager : TEST : 0 : Project “TEST 0” removed (1 remaining)
2019-02-11 15:12:05,887 : INFO : main : NodeLogger : : : #########################################################################################
2019-02-11 15:12:05,889 : INFO : main : NodeLogger : : : # #
2019-02-11 15:12:05,889 : INFO : main : NodeLogger : : : # Welcome to KNIME Analytics Platform v3.7.1.v201901281154 (Build January 29, 2019) #
2019-02-11 15:12:05,889 : INFO : main : NodeLogger : : : # Based on Eclipse, http://www.eclipse.org #
2019-02-11 15:12:05,889 : INFO : main : NodeLogger : : : # #
2019-02-11 15:12:05,889 : INFO : main : NodeLogger : : : #########################################################################################
2019-02-11 15:12:05,890 : INFO : main : NodeLogger : : : # #
2019-02-11 15:12:05,890 : INFO : main : NodeLogger : : : # Copyright by KNIME AG, Zurich, Switzerland and others. #
2019-02-11 15:12:05,890 : INFO : main : NodeLogger : : : # Website: http://www.knime.com #
2019-02-11 15:12:05,890 : INFO : main : NodeLogger : : : # E-mail: contact@knime.com #
2019-02-11 15:12:05,890 : INFO : main : NodeLogger : : : # #
2019-02-11 15:12:05,890 : INFO : main : NodeLogger : : : #########################################################################################
2019-02-11 15:12:05,890 : INFO : main : NodeLogger : : : # For more details see the KNIME log file: #
2019-02-11 15:12:05,890 : INFO : main : NodeLogger : : : # C:\Users\noy\knime-workspace.metadata\knime\knime.log
2019-02-11 15:12:05,891 : INFO : main : NodeLogger : : : #---------------------------------------------------------------------------------------#
2019-02-11 15:12:05,891 : INFO : main : NodeLogger : : : # logging date=Mon Feb 11 15:12:05 EET 2019
2019-02-11 15:12:05,891 : INFO : main : NodeLogger : : : # java.version=1.8.0_152
2019-02-11 15:12:05,891 : INFO : main : NodeLogger : : : # java.vm.version=25.152-b16
2019-02-11 15:12:05,891 : INFO : main : NodeLogger : : : # java.vendor=Oracle Corporation
2019-02-11 15:12:05,891 : INFO : main : NodeLogger : : : # os.name=Windows 10
2019-02-11 15:12:05,891 : INFO : main : NodeLogger : : : # os.arch=amd64
2019-02-11 15:12:05,891 : INFO : main : NodeLogger : : : # number of CPUs=4
2019-02-11 15:12:05,892 : INFO : main : NodeLogger : : : # assertions=off
2019-02-11 15:12:05,903 : INFO : main : NodeLogger : : : # host=noy-nb
2019-02-11 15:12:05,906 : INFO : main : NodeLogger : : : # username=noy
2019-02-11 15:12:05,906 : INFO : main : NodeLogger : : : # max mem=7241MB
2019-02-11 15:12:05,909 : INFO : main : NodeLogger : : : # application=org.knime.product.KNIME_APPLICATION
2019-02-11 15:12:05,910 : INFO : main : NodeLogger : : : # ID=01-8beb66db16311a34
2019-02-11 15:12:05,910 : INFO : main : NodeLogger : : : #########################################################################################
2019-02-11 15:12:05,929 : DEBUG : main : DatabaseConnectionSettings : : : Settings database timeout to 15 seconds
2019-02-11 15:12:05,976 : DEBUG : main : DatabaseConnectionSettings : : : Database concurrency (sync via database connection) is true.
2019-02-11 15:12:05,980 : DEBUG : main : KNIMECorePlugin : : : Setting KNIME max thread count to 8
2019-02-11 15:12:05,980 : DEBUG : main : KNIMECorePlugin : : : Setting KNIME temp dir to “C:\Users\noy\AppData\Local\Temp”
2019-02-11 15:12:08,110 : DEBUG : main : KnimeEncryption : : : Replacing current encryption key supplier “null” with this new one “org.knime.workbench.core.EclipseEncryptionKeySupplier@704641e3”.
2019-02-11 15:12:08,153 : DEBUG : main : DatabaseDriverLoader : : : Could not load JDBC ODBC driver class ‘sun.jdbc.odbc.JdbcOdbcDriver’. Class has been removed in Java 8.
2019-02-11 15:12:08,155 : DEBUG : main : DatabaseDriverLoader : : : Load driver from file: C:\DevTools\KNIME\plugins\org.knime.database.connectors_3.7.0.v201808081048\lib\jtds-1.3.1.jar
2019-02-11 15:12:08,183 : DEBUG : main : DatabaseDriverLoader : : : Database driver net.sourceforge.jtds.jdbc.Driver loaded successful from file C:\DevTools\KNIME\plugins\org.knime.database.connectors_3.7.0.v201808081048\lib\jtds-1.3.1.jar. Driver info: Driver class name: net.sourceforge.jtds.jdbc.Driver major version: 1 minor version: 3 jdbc compliant: false
2019-02-11 15:12:08,183 : DEBUG : main : DatabaseDriverLoader : : : Adding driver to buildin map: net.sourceforge.jtds.jdbc.Driver
2019-02-11 15:12:08,278 : DEBUG : main : DatabaseDriverLoader : : : Load driver from file: C:\DevTools\KNIME\plugins\org.knime.database.connectors_3.7.0.v201808081048\lib\postgresql-9.4-1201.jdbc41.jar
2019-02-11 15:12:08,288 : DEBUG : main : DatabaseDriverLoader : : : Database driver org.postgresql.Driver loaded successful from file C:\DevTools\KNIME\plugins\org.knime.database.connectors_3.7.0.v201808081048\lib\postgresql-9.4-1201.jdbc41.jar. Driver info: Driver class name: org.postgresql.Driver major version: 9 minor version: 4 jdbc compliant: false
2019-02-11 15:12:08,288 : DEBUG : main : DatabaseDriverLoader : : : Adding driver to buildin map: org.postgresql.Driver
2019-02-11 15:12:08,494 : DEBUG : main : DatabaseDriverLoader : : : Load driver from file: C:\DevTools\KNIME\ojdbc8.jar
2019-02-11 15:12:08,696 : DEBUG : main : DatabaseDriverLoader : : : Database driver oracle.jdbc.OracleDriver loaded successful from file C:\DevTools\KNIME\ojdbc8.jar. Driver info: Driver class name: oracle.jdbc.OracleDriver major version: 12 minor version: 2 jdbc compliant: true
2019-02-11 15:12:08,696 : DEBUG : main : DatabaseDriverLoader : : : Adding driver to user map: oracle.jdbc.OracleDriver. Files: [file:/C:/DevTools/KNIME/ojdbc8.jar]
2019-02-11 15:12:09,195 : DEBUG : main : DatabaseDriverLoader : : : Database driver oracle.jdbc.driver.OracleDriver loaded successful from file C:\DevTools\KNIME\ojdbc8.jar. Driver info: Driver class name: oracle.jdbc.driver.OracleDriver major version: 12 minor version: 2 jdbc compliant: true
2019-02-11 15:12:09,195 : DEBUG : main : DatabaseDriverLoader : : : Adding driver to user map: oracle.jdbc.driver.OracleDriver. Files: [file:/C:/DevTools/KNIME/ojdbc8.jar]
2019-02-11 15:12:09,848 : DEBUG : main : DatabaseDriverLoader : : : Load driver from file: C:\DevTools\KNIME\Microsoft JDBC Driver 6.0 for SQL Server\sqljdbc_6.0\enu\jre8\sqljdbc42.jar
2019-02-11 15:12:10,006 : DEBUG : main : DatabaseDriverLoader : : : Database driver com.microsoft.sqlserver.jdbc.SQLServerDriver loaded successful from file C:\DevTools\KNIME\Microsoft JDBC Driver 6.0 for SQL Server\sqljdbc_6.0\enu\jre8\sqljdbc42.jar. Driver info: Driver class name: com.microsoft.sqlserver.jdbc.SQLServerDriver major version: 6 minor version: 0 jdbc compliant: true
2019-02-11 15:12:10,007 : DEBUG : main : DatabaseDriverLoader : : : Adding driver to user map: com.microsoft.sqlserver.jdbc.SQLServerDriver. Files: [file:/C:/DevTools/KNIME/Microsoft%20JDBC%20Driver%206.0%20for%20SQL%20Server/sqljdbc_6.0/enu/jre8/sqljdbc42.jar]
2019-02-11 15:12:10,206 : DEBUG : main : DatabaseDriverLoader : : : Load driver from file: C:\DevTools\KNIME\postgresql-42.2.5.jar
2019-02-11 15:12:10,215 : DEBUG : main : DatabaseDriverLoader : : : Database driver org.postgresql.Driver loaded successful from file C:\DevTools\KNIME\postgresql-42.2.5.jar. Driver info: Driver class name: org.postgresql.Driver major version: 42 minor version: 2 jdbc compliant: false
2019-02-11 15:12:10,215 : DEBUG : main : DatabaseDriverLoader : : : Adding driver to user map: org.postgresql.Driver. Files: [file:/C:/DevTools/KNIME/postgresql-42.2.5.jar]
2019-02-11 15:12:10,406 : DEBUG : main : DatabaseConnectionSettings : : : Settings database timeout to 15 seconds
2019-02-11 15:12:10,444 : INFO : main : BatchExecutor : : : ===== Executing workflow C:\Users\noy\knime-workspace\TEST =====
2019-02-11 15:12:10,570 : DEBUG : main : NodeTimer$GlobalNodeStats : : : Successfully read node usage stats from file: C:\Users\noy\knime-workspace.metadata\knime\nodeusage_3.0.json
2019-02-11 15:12:10,593 : DEBUG : main : NodeContainer : : : ROOT has new state: EXECUTED
2019-02-11 15:12:10,593 : DEBUG : main : WorkflowManager : : : Created subworkflow
2019-02-11 15:12:10,594 : DEBUG : main : NodeContainer : : : KNIME MetaNode Repository 1 has new state: EXECUTED
2019-02-11 15:12:10,594 : DEBUG : main : WorkflowManager : : : Created subworkflow 1
2019-02-11 15:12:10,595 : DEBUG : main : WorkflowManager : : : Added new subworkflow 1
2019-02-11 15:12:10,595 : DEBUG : main : WorkflowManager : : : Created project 1
2019-02-11 15:12:10,604 : ERROR : main : BatchExecutor : : : Workflow is locked by another KNIME instance
2019-02-11 15:12:10,604 : INFO : main : BatchExecutor : : : ========= Workflow did not execute sucessfully ============

6

SOLVED!!!
Removed jar files from preferences.
Restarted KNIME.
Re-installed jar files.

1 Like
7

That is always a good option to try :smiley:
Glad it worked.
Br,
Ivan