Python Script (Hive) node failing

Hi Team,

I am getting following error while executing example workflow from example server for Python Script (DB) node. Please help.

ERROR Python Script (DB)   2:8        Execute failed: Software caused connection abort: socket write error
ERROR PythonKernel                    D:\Program Files\knime_3.3.2\plugins\org.knime.python_3.3.0.v201611242050\py\PythonKernel.py:40: FutureWarning: The pandas.tslib module is deprecated and will be removed in a future version.
  from pandas.tslib import Timestamp
Traceback (most recent call last):
  File "D:\Program Files\knime_3.3.2\plugins\org.knime.python_3.3.0.v201611242050\py\PythonKernel.py", line 1047, in <module>
    run()
  File "D:\Program Files\knime_3.3.2\plugins\org.knime.python_3.3.0.v201611242050\py\PythonKernel.py", line 214, in run
    put_sql(command)
  File "D:\Program Files\knime_3.3.2\plugins\org.knime.python_3.3.0.v201611242050\py\PythonKernel.py", line 318, in put_sql
    db_util = DBUtil(sql)
  File "D:\Program Files\knime_3.3.2\plugins\org.knime.python_3.3.0.v201611242050\py\DBUtil.py", line 39, in __init__
    sql.jars)
  File "D:\Program Files\knime_3.3.2\plugins\org.knime.python_3.3.0.v201611242050\py\jaydebeapi.py", line 324, in connect
    jconn = _jdbc_connect(jclassname, jars, libs, *driver_args)
  File "D:\Program Files\knime_3.3.2\plugins\org.knime.python_3.3.0.v201611242050\py\jaydebeapi.py", line 132, in _jdbc_connect_jpype
    jvm_path = jpype.getDefaultJVMPath()
  File "D:\Program Files\Anaconda2\lib\site-packages\jpype\_core.py", line 114, in get_default_jvm_path
    return finder.get_jvm_path()
  File "D:\Program Files\Anaconda2\lib\site-packages\jpype\_jvmfinder.py", line 137, in get_jvm_path
    .format(self._libfile))
jpype._jvmfinder.JVMNotFoundException: No JVM shared library file (jvm.dll) found. Try setting up the JAVA_HOME environment variable properly.

 

I tried to set JAVA_HOME variable in KNIME preferences classpath variables with value --> C:/Program Files/Java/jdk1.8.0_71/jre/bin/server but it didnot work out. I also tried to setup the same in My Computer--> Advance Properties --> Environment Variables--. System variables. But that did not work either. Please advise.

Hey rghadge,

Sorry for the late reply. We're pretty sure that the problem relates to jpype1 and your JVM installation (as indicated in your post). One idea is that you download the Sun JDK and set your JAVA_HOME environment variable on the corresponding installation folder of the JRE which is part of the JDK. Jpype should then be able to find the JVM.

Does this help?

Best,

Christian