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!

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

Alteryx Partner



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. 


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?



Jess Silveri
Premium Support Advisor | Alteryx
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[$`DBT`) &$`DBUL`) & !$`EDUL`) &$`EDT`) & (LO$`LDTSO`=="BAT") & (LOA$`DATO`=="BAT"),]

write.Alteryx(V1, 1)



V2 <- LO[$`D2T`) &$`D2UL`) & !$`E2UL`) &$`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.