Demonstration of the KNIME Webportal

#1

This workflow will allow the user to pick a data source and do some decision tree model learning on it. Valid data sources are an in-built SQLite database or the upload of either another SQLite DB file or a custom KNIME table file. The workflow will then analyse the table and offer the user too choose the target and independent variables. A (very simple) report will be generated and shown to the user.


This is a companion discussion topic for the original entry at https://kni.me/w/JN3ejEP4GX7d4u9z
0 Likes

#2

Hi, my name is Michael and I am new to Knime so my query may be very basic.

I am trying to run the demo of the KNIME Webportal, located, I believe, on the KNIME Forum.

When I attempt to execute I get hung up on Node 54.

The error message reads:

Could not create connection to database [SQLite_Cantopen]

Unable to open DB file [ out of memory ]

DB Table Selector

  • error while selecting SQL Query
  • select from SQL Lite Master where type = ta

Frankly, this is all Greek to me.

Any suggestions on how to run this or a simpler Demo ?

Thanks,

Michael

0 Likes

#3

Hi @mgelormino9 -

I wasn’t able to recreate your problem when I ran this workflow. Perhaps as an alternative, you could try this other Hub workflow?

0 Likes

#4

Thanks Scott.

I appreciate it and I got it to run.

It took a bit of tweeking - trial and error.

At the outset, it indicated certain extensions were required but I could not select and add them and I am not sure why.

I also received multiple error messages which seemed to be focused on:

  1. my inability to add extensions for
  • KNIME data generation
  • KNIME JPMML integration
  1. an Empty Table Creator.

I suspect these repeat below and I only add them for information.

The good news is I got the demo to run - the not so good news is I know not how.

Looks like trouble shooting is part of the game.

Thanks,

Michael

ERROR MESSAGES:

Log file is located at: C:\Users\Michael Gelormino\knime-workspace.metadata\knime\knime.log
WARN MISSING Empty Table Creator 0:47:0:58 Node can’t be executed - Node “Empty Table Creator” not available from extension “KNIME Data Generation” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.datageneration” is not installed)
WARN MISSING Empty Table Creator 0:47:0:58 Node can’t be executed - Node “Empty Table Creator” not available from extension “KNIME Data Generation” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.datageneration” is not installed)
ERROR LoadWorkflowRunnable Errors during load: Status: Error: 08_Guided_Analytics - Demo for Q 2 - Model Selection via Web Portal_07112019.knwf 0 loaded with errors
ERROR LoadWorkflowRunnable Status: Error: 08_Guided_Analytics - Demo for Q 2 - Model Selection via Web Portal_07112019.knwf 0
ERROR LoadWorkflowRunnable Status: Error: Choose & Read Data 0:47
ERROR LoadWorkflowRunnable Status: Error: Node “Empty Table Creator” not available from extension “KNIME Data Generation” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.datageneration” is not installed)
ERROR LoadWorkflowRunnable Status: Warning: MISSING Empty Table Creator 0:47:0:58
ERROR LoadWorkflowRunnable Status: Warning: State has changed from CONFIGURED to IDLE
ERROR LoadWorkflowRunnable Status: Warning: State has changed from CONFIGURED to IDLE
ERROR LoadWorkflowRunnable Status: Error: Model Training 0:537
ERROR LoadWorkflowRunnable Status: Error: Current Model 0:537:510
ERROR LoadWorkflowRunnable Status: Error: Node “JPMML Classifier” not available from extension “KNIME JPMML Integration” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.jpmml” is not installed)
WARN MISSING Empty Table Creator 0:47:0:58 Node can’t be executed - Node “Empty Table Creator” not available from extension “KNIME Data Generation” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.datageneration” is not installed)
WARN MISSING Empty Table Creator 0:47:0:58 Node can’t be executed - Node “Empty Table Creator” not available from extension “KNIME Data Generation” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.datageneration” is not installed)
WARN MISSING Empty Table Creator 0:47:0:58 Node can’t be executed - Node “Empty Table Creator” not available from extension “KNIME Data Generation” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.datageneration” is not installed)
ERROR LoadWorkflowRunnable Errors during load: Status: Error: 08_Guided_Analytics - Demo for Q 2 - Model Selection via Web Portal_07112019.knwf 0 loaded with errors
ERROR LoadWorkflowRunnable Status: Error: 08_Guided_Analytics - Demo for Q 2 - Model Selection via Web Portal_07112019.knwf 0
ERROR LoadWorkflowRunnable Status: Error: Choose & Read Data 0:47
ERROR LoadWorkflowRunnable Status: Error: Node “Empty Table Creator” not available from extension “KNIME Data Generation” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.datageneration” is not installed)
ERROR LoadWorkflowRunnable Status: Warning: MISSING Empty Table Creator 0:47:0:58
ERROR LoadWorkflowRunnable Status: Warning: State has changed from CONFIGURED to IDLE
ERROR LoadWorkflowRunnable Status: Warning: State has changed from CONFIGURED to IDLE
ERROR LoadWorkflowRunnable Status: Error: Model Training 0:537
ERROR LoadWorkflowRunnable Status: Error: Current Model 0:537:510
ERROR LoadWorkflowRunnable Status: Error: Node “JPMML Classifier” not available from extension “KNIME JPMML Integration” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.jpmml” is not installed)
WARN MISSING Empty Table Creator 0:47:0:58 Node can’t be executed - Node “Empty Table Creator” not available from extension “KNIME Data Generation” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.datageneration” is not installed)
WARN MISSING Empty Table Creator 0:47:0:58 Node can’t be executed - Node “Empty Table Creator” not available from extension “KNIME Data Generation” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.datageneration” is not installed)
WARN MISSING Empty Table Creator 0:47:0:58 Node can’t be executed - Node “Empty Table Creator” not available from extension “KNIME Data Generation” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.datageneration” is not installed)
ERROR LoadWorkflowRunnable Errors during load: Status: Error: 08_Guided_Analytics - Demo for Q 2 - Model Selection via Web Portal_07112019.knwf 0 loaded with errors
ERROR LoadWorkflowRunnable Status: Error: 08_Guided_Analytics - Demo for Q 2 - Model Selection via Web Portal_07112019.knwf 0
ERROR LoadWorkflowRunnable Status: Error: Choose & Read Data 0:47
ERROR LoadWorkflowRunnable Status: Error: Node “Empty Table Creator” not available from extension “KNIME Data Generation” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.datageneration” is not installed)
ERROR LoadWorkflowRunnable Status: Warning: MISSING Empty Table Creator 0:47:0:58
ERROR LoadWorkflowRunnable Status: Warning: State has changed from CONFIGURED to IDLE
ERROR LoadWorkflowRunnable Status: Warning: State has changed from CONFIGURED to IDLE
ERROR LoadWorkflowRunnable Status: Error: Model Training 0:537
ERROR LoadWorkflowRunnable Status: Error: Current Model 0:537:510
ERROR LoadWorkflowRunnable Status: Error: Node “JPMML Classifier” not available from extension “KNIME JPMML Integration” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.jpmml” is not installed)
WARN MISSING Empty Table Creator 2:47:0:58 Node can’t be executed - Node “Empty Table Creator” not available from extension “KNIME Data Generation” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.datageneration” is not installed)
WARN MISSING Empty Table Creator 2:47:0:58 Node can’t be executed - Node “Empty Table Creator” not available from extension “KNIME Data Generation” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.datageneration” is not installed)
ERROR LoadWorkflowRunnable Errors during load: Status: Error: 08_Guided_Analytics.knwf 2 loaded with errors
ERROR LoadWorkflowRunnable Status: Error: 08_Guided_Analytics.knwf 2
ERROR LoadWorkflowRunnable Status: Error: Choose & Read Data 2:47
ERROR LoadWorkflowRunnable Status: Error: Node “Empty Table Creator” not available from extension “KNIME Data Generation” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.datageneration” is not installed)
ERROR LoadWorkflowRunnable Status: Warning: MISSING Empty Table Creator 2:47:0:58
ERROR LoadWorkflowRunnable Status: Warning: State has changed from CONFIGURED to IDLE
ERROR LoadWorkflowRunnable Status: Warning: State has changed from CONFIGURED to IDLE
ERROR LoadWorkflowRunnable Status: Error: Model Training 2:537
ERROR LoadWorkflowRunnable Status: Error: Current Model 2:537:510
ERROR LoadWorkflowRunnable Status: Error: Node “JPMML Classifier” not available from extension “KNIME JPMML Integration” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.jpmml” is not installed)
WARN Table Creator 2:575 Node created an empty data table.
WARN MISSING Empty Table Creator 2:47:0:58 Node can’t be executed - Node “Empty Table Creator” not available from extension “KNIME Data Generation” (provided by “KNIME AG, Zurich, Switzerland”; plugin “org.knime.datageneration” is not installed)

0 Likes