community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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. 

Moderator
Moderator

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
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