Dears,
I have recently upgraded to Alteryx 2018.2 and I see lot of errors which using R tool and any other Predictive Tools.
Recently I am facing issue using R tool node. I have to push data frame from R tool to Tableau server or to excel file but I am getting following error : Error: R (3): There was an error in WriteYXDBStreaming
Kindly assist.
Thank you in advance.
Solved! Go to Solution.
Hi @alphasupport,
I've seen this error in relation to field names or invalid field types. Can you post a sample or mock up of your data and workflow for us to review?
Thanks,
Hi, I'm also having the same problem.
I follow the same syntax in a different work flow and didn't have any problems.
Here is a dummy example of the code I'm submitting:
LO <- read_excel("path", col_names = TRUE)
colnames(LO) <- gsub(" ","_", colnames(LO))
V1 <- LO[is.na(LO$`DBT`) & is.na(LO$`DBUL`) & !is.na(LO$`EDUL`) & is.na(LO$`EDT`) & (LO$`LDTSO`=="BAT") & (LOA$`DATO`=="BAT"),]
write.Alteryx(V1, 1)
V2 <- LO[is.na(LO$`D2T`) & is.na(LO$`D2UL`) & !is.na(LO$`E2UL`) & is.na(LO$`E2T`) & (LO$`L2TSO`=="BAT") & (LO$`D2TO`=="BAT"),]
write.Alteryx(V2, 2)
The error message says "There was an error in WriteYXDBStreaming". The code works in the R environment so I wasn't sure if there's an issue with the tool or if I'm missing something that I need to add.