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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

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

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