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


#1

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.


#2

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


#3

Hi,

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


#4

The same problem also exists in the Selenium nodes


@qqilihq


#5

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


#6

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


#7

Workflow @qqilihq @armingrudd

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


#8

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


#9

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


#10

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


#11

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.