Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

Error: R (3): There was an error in WriteYXDBStreaming

Highlighted
Alteryx Partner

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. 

Highlighted
Alteryx
Alteryx

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,

Jess Silveri
Premium Support Advisor | Alteryx
Highlighted
6 - Meteoroid

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.

Labels