Hi,
After some testing with Jupyter Notebook integration with Knime I came across a peculiar problem specifically with the new DB Connector. In this case we tested both BigQuery and Oracle. IF the workflow has not been run fully and saved the workflow fails to execute from Jupyter Notebook. If the workflow is run and stored without resetting the workflow runs fine. Here is an example workflow. OBS: We do close the workflow as previously reported in another topic.
The errors generated in Jupyter Notebook end with this error message.
Thanks for any insights that other can help with.
Thanks,
Jan
ERROR:root:captured stdout: CompilerOracle: exclude javax/swing/text/GlyphView.getBreakSpot
Install location:
file:/c:/Program Files/KNIME/
Configuration file:
file:/c:/Program Files/KNIME/configuration/config.ini loaded
Configuration location:
file:/c:/Program Files/KNIME/configuration/
Framework located:
file:/c:/Program Files/KNIME/plugins/org.eclipse.osgi_3.12.100.v20180210-1608.jar
Loading extension: reference:file:javax.transaction_1.1.1.v201105210645.jar
eclipse.properties not found
Loading extension: reference:file:org.eclipse.osgi.compatibility.state_1.1.0.v20170516-1513.jar
eclipse.properties not found
Framework classpath:
file:/c:/Program Files/KNIME/plugins/org.eclipse.osgi_3.12.100.v20180210-1608.jar
file:/c:/Program Files/KNIME/plugins/
file:/c:/Program Files/KNIME/plugins/javax.transaction_1.1.1.v201105210645.jar
file:/c:/Program Files/KNIME/plugins/org.eclipse.osgi.compatibility.state_1.1.0.v20170516-1513.jar
Debug options:
file:/C:/Users/Jan/.options not found
Time to load bundles: 6
Starting application: 1200
Start VM: -server
-Dsun.java2d.d3d=false
-Dosgi.classloader.lock=classname
-XX:+UnlockDiagnosticVMOptions
-XX:+UnsyncloadClass
-XX:+UseG1GC
-Dsun.net.client.defaultReadTimeout=0
-XX:CompileCommand=exclude,javax/swing/text/GlyphView,getBreakSpot
-Xmx8113m
-Dorg.eclipse.swt.browser.IEVersion=10001
-Dsun.awt.noerasebackground=true
-Dequinox.statechange.timeout=30000
-Djava.class.path=C:\Program Files\KNIME\plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
-os win32
-ws win32
-arch x86_64
-launcher C:\Program Files\KNIME\knime.exe
-name Knime
ālauncher.library C:\Program Files\KNIME\plugins/org.eclipse.equinox.launcher.win32.win32.x86_64_1.1.551.v20171108-1834\eclipse_1630.dll
-startup C:\Program Files\KNIME\plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
ālauncher.overrideVmargs
-debug
-application org.knime.product.KNIME_BATCH_APPLICATION
-data C:\Users\Jan\AppData\Local\Temp\tmp6rgmxpka\knime_data
-nosave
-workflowDir=C:\Users\Jan\knime-workspace\ParameterReading\Oracle DB Connector2
-option=13,outputPathOrUrl,C:\Users\Jan\AppData\Local\Temp\tmp6rgmxpka\output_13.json,String
-vm C:\Program Files\KNIME\plugins/org.knime.binary.jre.win32.x86_64_1.8.0.202-b08/jre/bin\server\jvm.dll
-vmargs
-server
-Dsun.java2d.d3d=false
-Dosgi.classloader.lock=classname
-XX:+UnlockDiagnosticVMOptions
-XX:+UnsyncloadClass
-XX:+UseG1GC
-Dsun.net.client.defaultReadTimeout=0
-XX:CompileCommand=exclude,javax/swing/text/GlyphView,getBreakSpot
-Xmx8113m
-Dorg.eclipse.swt.browser.IEVersion=10001
-Dsun.awt.noerasebackground=true
-Dequinox.statechange.timeout=30000
-Djava.class.path=C:\Program Files\KNIME\plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
ERROR:root:captured stderr: Oct 01, 2019 2:04:29 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-http (158) [org.apache.cxf.transport.http.HTTPTransportFactory, org.apache.cxf.transport.http.HTTPWSDLExtensionLoader, org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder, org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder, org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider]
Oct 01, 2019 2:04:29 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-http-hc (159) [org.apache.cxf.transport.http.HTTPConduitFactory, org.apache.cxf.transport.ConduitInitiator]
log4j:ERROR Could not instantiate class [org.apache.hadoop.log.metrics.EventCounter].
java.lang.ClassNotFoundException: org.apache.hadoop.log.metrics.EventCounter cannot be found by org.apache.log4j_1.2.15.v201012070815
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:484)
ā¦
log4j:ERROR Could not instantiate appender named āEventCounterā.
ERROR main BatchExecutor Workflow is locked by another KNIME instance
Oct 01, 2019 2:04:31 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener unregister
INFO: Removing the extensions for bundle 158
Oct 01, 2019 2:04:31 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener unregister
INFO: Removing the extensions for bundle 159
FileNotFoundError Traceback (most recent call last)
C:\ProgramData\Anaconda3\lib\site-packages\knime.py in run_workflow_using_multiple_service_tables(input_datas, path_to_knime_executable, path_to_knime_workflow, input_service_table_node_ids, output_service_table_node_ids, save_after_execution, live_passthru_stdout_stderr, output_as_pandas_dataframes, input_json_filename_pattern, output_json_filename_pattern)
261 for output_json_filepath in expected_output_json_files:
ā> 262 with open(output_json_filepath) as output_json_fh:
263 single_node_knime_output = json.load(output_json_fh)
FileNotFoundError: [Errno 2] No such file or directory: āC:\Users\Jan\AppData\Local\Temp\tmp6rgmxpka\output_13.jsonā
During handling of the above exception, another exception occurred:
ChildProcessError Traceback (most recent call last)
in
1 with knime.Workflow(workflow_path=workflow,workspace_path=workspace) as wf:
----> 2 wf.execute()
C:\ProgramData\Anaconda3\lib\site-packages\knime.py in execute(self, live_passthru_stdout_stderr, output_as_pandas_dataframes)
382 save_after_execution=self.save_after_execution,
383 live_passthru_stdout_stderr=live_passthru_stdout_stderr,
ā> 384 output_as_pandas_dataframes=output_as_pandas_dataframes,
385 )
386 self._data_table_outputs[:] = outputs
C:\ProgramData\Anaconda3\lib\site-packages\knime.py in run_workflow_using_multiple_service_tables(input_datas, path_to_knime_executable, path_to_knime_workflow, input_service_table_node_ids, output_service_table_node_ids, save_after_execution, live_passthru_stdout_stderr, output_as_pandas_dataframes, input_json_filename_pattern, output_json_filename_pattern)
270 logging.error(f"captured stdout: {result.stdout}")
271 logging.error(f"captured stderr: {result.stderr}")
ā> 272 raise ChildProcessError(āOutput from KNIME not foundā)
273
274 if output_as_pandas_dataframes:
ChildProcessError: Output from KNIME not found