Execute failed: org.knime.core.data.MissingCell cannot be cast to org.knime.core.data.StringValue

cmora · February 5, 2019, 10:11pm

hello,
I’m new to KNIME and seeking help from the group.
I’m reading a csv file that contains missing data and tried using histogram nodes (JFreeChart, Javascript, and regular) to view the data.
Two of them display the data fine, but the Javascript histogram node does not. The error I receive is as follows:
ERROR Histogram (JavaScript) 0:12 Execute failed: org.knime.core.data.MissingCell cannot be cast to org.knime.core.data.StringValue

Any suggestions would be greatly appreciated.

s.roughley · February 5, 2019, 10:16pm

That shouldn’t really happen, as nodes should check for missing cells first before doing anything else with the cell. However, you’ve obviously found somewhere where it is happening, so either:

use a row filter node to remove rows with missing values
use one of the missing values nodes to replace them with a sensible default value for your use case

Steve

albrecht · February 6, 2019, 7:49am

Hi,

this behaviour is not expected. I filed a bug on our end. Thanks for finding and reporting it.

umutcankurt · February 14, 2019, 1:14pm

The same problem also exists in the Selenium nodes

@qqilihq

armingrudd · February 14, 2019, 2:35pm

Hi @umutcankurt,

I guess the error you are getting is related to the topic we discussed here.

Providing a screenshot of the node configuration may also help.

Best,
Armin

qqilihq · February 14, 2019, 3:19pm

And a stack trace, please. (enable DEBUG logging)

umutcankurt · February 15, 2019, 7:08am

Workflow @qqilihq @armingrudd

KNIME_Ireland_irl.eu-supply.com_project (Selenium).knwf (78.5 KB)

umutcankurt · February 15, 2019, 7:12am

org.osgi.framework.BundleException: Could not resolve module: org.erlwood.knime.cheminformatics [941]
Unresolved requirement: Require-Bundle: org.erlwood.knime.core; bundle-version=“3.2.1”
-> Bundle-SymbolicName: org.erlwood.knime.core; bundle-version=“3.3.0.v201701271222”; singleton:=“true”
org.erlwood.knime.core [942]
No resolution report for the bundle. Bundle was not resolved because of a uses contraint violation.
org.osgi.service.resolver.ResolutionException: Uses constraint violation. Unable to resolve resource org.erlwood.knime.core [osgi.identity; type=“osgi.bundle”; version:Version=“3.3.0.v201701271222”; osgi.identity=“org.erlwood.knime.core”; singleton:=“true”] because it is exposed to package ‘org.apache.cxf.configuration.security’ from resources org.apache.cxf.cxf-core [osgi.identity; type=“osgi.bundle”; version:Version=“3.0.7.v20180813-knime”; osgi.identity=“org.apache.cxf.cxf-core”] and org.apache.cxf [osgi.identity; type=“osgi.bundle”; version:Version=“2.7.12.v201805071222”; osgi.identity=“org.apache.cxf”; singleton:=“true”] via two dependency chains.

Chain 1:
org.erlwood.knime.core [osgi.identity; type=“osgi.bundle”; version:Version=“3.3.0.v201701271222”; osgi.identity=“org.erlwood.knime.core”; singleton:=“true”]
require: (&(osgi.wiring.bundle=org.apache.cxf.cxf-core)(&(bundle-version>=3.0.7)(!(bundle-version>=4.0.0))))
|
provide: osgi.wiring.bundle: org.apache.cxf.cxf-core
org.apache.cxf.cxf-core [osgi.identity; type=“osgi.bundle”; version:Version=“3.0.7.v20180813-knime”; osgi.identity=“org.apache.cxf.cxf-core”]

Chain 2:
org.erlwood.knime.core [osgi.identity; type=“osgi.bundle”; version:Version=“3.3.0.v201701271222”; osgi.identity=“org.erlwood.knime.core”; singleton:=“true”]
require: (&(osgi.wiring.bundle=org.apache.cxf.cxf-rt-transports-http-hc)(&(bundle-version>=3.0.7)(!(bundle-version>=4.0.0))))
|
provide: osgi.wiring.bundle; bundle-version:Version=“3.0.7.v20171115-knime”; osgi.wiring.bundle=“org.apache.cxf.cxf-rt-transports-http-hc”
org.apache.cxf.cxf-rt-transports-http-hc [osgi.identity; type=“osgi.bundle”; version:Version=“3.0.7.v20171115-knime”; osgi.identity=“org.apache.cxf.cxf-rt-transports-http-hc”]
import: (osgi.wiring.package=org.apache.cxf.configuration.security)
|
export: osgi.wiring.package: org.apache.cxf.configuration.security
org.apache.cxf [osgi.identity; type=“osgi.bundle”; version:Version=“2.7.12.v201805071222”; osgi.identity=“org.apache.cxf”; singleton:=“true”]
at org.eclipse.osgi.container.Module.start(Module.java:444)
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1634)
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1613)
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.doContainerStartLevel(ModuleContainer.java:1585)
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1528)
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1)
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340)

org.osgi.framework.BundleException: Could not resolve module: org.erlwood.knime.core [942]
Bundle was not resolved because of a uses contraint violation.
org.osgi.service.resolver.ResolutionException: Uses constraint violation. Unable to resolve resource org.erlwood.knime.core [osgi.identity; type=“osgi.bundle”; version:Version=“3.3.0.v201701271222”; osgi.identity=“org.erlwood.knime.core”; singleton:=“true”] because it is exposed to package ‘org.apache.cxf.configuration.security’ from resources org.apache.cxf.cxf-core [osgi.identity; type=“osgi.bundle”; version:Version=“3.0.7.v20180813-knime”; osgi.identity=“org.apache.cxf.cxf-core”] and org.apache.cxf [osgi.identity; type=“osgi.bundle”; version:Version=“2.7.12.v201805071222”; osgi.identity=“org.apache.cxf”; singleton:=“true”] via two dependency chains.

Chain 1:
org.erlwood.knime.core [osgi.identity; type=“osgi.bundle”; version:Version=“3.3.0.v201701271222”; osgi.identity=“org.erlwood.knime.core”; singleton:=“true”]
require: (&(osgi.wiring.bundle=org.apache.cxf.cxf-core)(&(bundle-version>=3.0.7)(!(bundle-version>=4.0.0))))
|
provide: osgi.wiring.bundle: org.apache.cxf.cxf-core
org.apache.cxf.cxf-core [osgi.identity; type=“osgi.bundle”; version:Version=“3.0.7.v20180813-knime”; osgi.identity=“org.apache.cxf.cxf-core”]

Chain 2:
org.erlwood.knime.core [osgi.identity; type=“osgi.bundle”; version:Version=“3.3.0.v201701271222”; osgi.identity=“org.erlwood.knime.core”; singleton:=“true”]
require: (&(osgi.wiring.bundle=org.apache.cxf.cxf-rt-transports-http-hc)(&(bundle-version>=3.0.7)(!(bundle-version>=4.0.0))))
|
provide: osgi.wiring.bundle; bundle-version:Version=“3.0.7.v20171115-knime”; osgi.wiring.bundle=“org.apache.cxf.cxf-rt-transports-http-hc”
org.apache.cxf.cxf-rt-transports-http-hc [osgi.identity; type=“osgi.bundle”; version:Version=“3.0.7.v20171115-knime”; osgi.identity=“org.apache.cxf.cxf-rt-transports-http-hc”]
import: (osgi.wiring.package=org.apache.cxf.configuration.security)
|
export: osgi.wiring.package: org.apache.cxf.configuration.security
org.apache.cxf [osgi.identity; type=“osgi.bundle”; version:Version=“2.7.12.v201805071222”; osgi.identity=“org.apache.cxf”; singleton:=“true”]
at org.eclipse.osgi.container.Module.start(Module.java:444)
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1634)
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1613)
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.doContainerStartLevel(ModuleContainer.java:1585)
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1528)
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1)
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340)

org.osgi.framework.BundleException: Could not resolve module: com.knime.server.nodes [1392]
Unresolved requirement: Require-Bundle: org.knime.explorer.nodes; bundle-version="[3.6.0,4.0.0)"
-> Bundle-SymbolicName: org.knime.explorer.nodes; bundle-version=“3.7.0.v201808081048”; singleton:=“true”
org.knime.explorer.nodes [1053]
No resolution report for the bundle. Bundle was not resolved because of a uses contraint violation.
org.osgi.service.resolver.ResolutionException: Uses constraint violation. Unable to resolve resource org.knime.explorer.nodes [osgi.identity; type=“osgi.bundle”; version:Version=“3.7.0.v201808081048”; osgi.identity=“org.knime.explorer.nodes”; singleton:=“true”] because it is exposed to package ‘org.mozilla.javascript’ from resources org.mozilla.javascript [osgi.identity; type=“osgi.bundle”; version:Version=“1.7.5.v201504281450”; osgi.identity=“org.mozilla.javascript”] and com.pervasive.datarush.core.runtime [osgi.identity; type=“osgi.bundle”; version:Version=“6.6.1.17”; osgi.identity=“com.pervasive.datarush.core.runtime”; singleton:=“true”] via two dependency chains.

Chain 1:
org.knime.explorer.nodes [osgi.identity; type=“osgi.bundle”; version:Version=“3.7.0.v201808081048”; osgi.identity=“org.knime.explorer.nodes”; singleton:=“true”]
require: (&(osgi.wiring.bundle=org.eclipse.birt.report.engine)(&(bundle-version>=4.5.0)(!(bundle-version>=5.0.0))))
|
provide: osgi.wiring.bundle: org.eclipse.birt.report.engine
org.mozilla.javascript [osgi.identity; type=“osgi.bundle”; version:Version=“1.7.5.v201504281450”; osgi.identity=“org.mozilla.javascript”]

Chain 2:
org.knime.explorer.nodes [osgi.identity; type=“osgi.bundle”; version:Version=“3.7.0.v201808081048”; osgi.identity=“org.knime.explorer.nodes”; singleton:=“true”]
require: (&(osgi.wiring.bundle=com.fifesoft.languagesupport)(&(bundle-version>=2.5.7)(!(bundle-version>=3.0.0))))
|
provide: osgi.wiring.bundle; bundle-version:Version=“2.6.0.v20171114-knime”; osgi.wiring.bundle=“com.fifesoft.languagesupport”
com.fifesoft.languagesupport [osgi.identity; type=“osgi.bundle”; version:Version=“2.6.0.v20171114-knime”; osgi.identity=“com.fifesoft.languagesupport”]
import: (osgi.wiring.package=org.mozilla.javascript)
|
export: osgi.wiring.package: org.mozilla.javascript
com.pervasive.datarush.core.runtime [osgi.identity; type=“osgi.bundle”; version:Version=“6.6.1.17”; osgi.identity=“com.pervasive.datarush.core.runtime”; singleton:=“true”]
at org.eclipse.osgi.container.Module.start(Module.java:444)
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1634)
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1613)
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.doContainerStartLevel(ModuleContainer.java:1585)
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1528)
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1)
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340)

Cannot bind to an undefined command: plug-in=‘org.knime.workbench.editor’, id=‘knime.commands.editor.gridSettings’

Warnings while parsing the key bindings from the ‘org.eclipse.ui.commands’ and ‘org.eclipse.ui.bindings’ extension point

armingrudd · February 15, 2019, 11:36am

Dear @umutcankurt
Please pay attention to what I have already told you.
You have to use “Wait” node after each “Click” node in your workflow:

Your problem is because of the loading time of the page after the clicks.

Best,
Armin

umutcankurt · February 15, 2019, 6:01pm

Yes Armin This time plug-in works correctly. the problem was solved for me Thanks for the support
@armingrudd
@qqilihq

qqilihq · February 23, 2019, 1:26pm

fyi:

Handling of missing values by the Execute JavaScript node is fixed in the 3.1.1 release. In case of missing values, the executed JavaScript will now simply receive null arguments.