R to table execute failed in Could not parse REXP
I created a workflow in Knime 4.1.3 under Windows7 where it worked fine. I moved to Windows10 recently and installed Knime 4.3.0 and R 3.6.3 and got the connection via Rserve up and running again.
Now I’m stumbling in this workflow on a “R to Table” node which runs in a “Could not parse REXP”. Something which did not happen before the migration to Windows10/Knime 4.3.0.
I found this topic, but there wasn’t a solution found.
Hello, all. Please help with some issue. In my table I have 2 fields: “firstdate” and “currentdate”. Also I have function “workdayscount” in postgresql database which counts number of business days between two dates. I try to run in R Snippet next code: "library(“RPostgreSQL”) drv passw con host = “111.111.111.1”, port = 5432, user = “user”, password = passw) work_days days In my case the script evaluates okay in the configuration and knime.out is a data.frame.
I added the last line of the script so you can see the contents of the knime.out variable.
When I execute the node the progress bar jumps to 30% after which the error is given.
In the knime.log I found this:
2021-01-22 08:28:20,345 : ERROR : KNIME-Worker-20-R to Table 0:743:0:705 : : Node : R to Table : 0:743:0:705 : Execute failed: Could not parse REXP. org.knime.r.controller.IRController$RException: Could not parse REXP. at org.knime.r.controller.RController.importBufferedDataTable(RController.java:765) at org.knime.r.RSnippetNodeModel.importDataFromR(RSnippetNodeModel.java:320) at org.knime.r.RSnippetNodeModel.executeSnippet(RSnippetNodeModel.java:223) at org.knime.r.RSnippetNodeModel.executeSnippet(RSnippetNodeModel.java:180) at org.knime.r.RSnippetNodeModel.executeInternal(RSnippetNodeModel.java:151) at org.knime.r.RSnippetNodeModel.execute(RSnippetNodeModel.java:139) at org.knime.core.node.NodeModel.executeModel(NodeModel.java:576) at org.knime.core.node.Node.invokeFullyNodeModelExecute(Node.java:1245) at org.knime.core.node.Node.execute(Node.java:1025) at org.knime.core.node.workflow.NativeNodeContainer.performExecuteNode(NativeNodeContainer.java:558) at org.knime.core.node.exec.LocalNodeExecutionJob.mainExecute(LocalNodeExecutionJob.java:95) at org.knime.core.node.workflow.NodeExecutionJob.internalRun(NodeExecutionJob.java:201) at org.knime.core.node.workflow.NodeExecutionJob.run(NodeExecutionJob.java:117) at org.knime.core.util.ThreadUtils$RunnableWithContextImpl.runWithContext(ThreadUtils.java:334) at org.knime.core.util.ThreadUtils$RunnableWithContext.run(ThreadUtils.java:210) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.knime.core.util.ThreadPool$MyFuture.run(ThreadPool.java:123) at org.knime.core.util.ThreadPool$Worker.run(ThreadPool.java:246) Caused by: org.rosuda.REngine.REXPMismatchException: attempt to access org.rosuda.REngine.REXPGenericVector as String at org.rosuda.REngine.REXP.asStrings(REXP.java:73) at org.knime.r.controller.RController.importCells(RController.java:851) at org.knime.r.controller.RController.importBufferedDataTable(RController.java:682) … 18 more
Any idea why this node worked before, but now runs in an error?