Hello, all. Please help with some issue. In my table I have 2 fields: “first_date” and “current_date”. Also I have function “work_days_count” in postgresql database which counts number of business days between two dates. I try to run in R Snippet next code: "library(“RPostgreSQL”) drv <- dbDriver(“PostgreSQL”) passw <- “pass” con <- dbConnect(drv, dbname = “dbname”, host = “111.111.111.1”, port = 5432, user = “user”, password = passw) work_days <- function(row){ days <- dbGetQuery(conn = con, statement = paste0(“select work_days_count(’”, row[[“first_date”]], “’,’”, row[[“current_date”]],"’)")) return(days) } knime.in$workdays <- apply(knime.in, 1, work_days) dbDisconnect(con) knime.out <- knime.in" It works without issues when I press button “Eval script” in R Snippet window. But when I try to execute node I get error “Execute failed: Could not parse REXP”. Can anyone help me?

ERROR R Snippet Execute failed: Could not parse REXP

mlauber71 February 17, 2020, 3:26pm 2

The usual questions would be which version of R and especially RServe do you use? You will need 1.8.6 and should have a current version of KNIME and R.

In the meantime you could check these discussions if they might help you.

Install R alongside KNIME on Windows and MacOS

R and Rtools

RServe 1.8.6 on MacOSX

1 Like