'WriteYXDBStreaming' Error using R node

ckestler

Has anyone ever seen this error before when trying to query to a database using an R node? 

My code runs in R, but not in Alteryx..and I get this 'WriteYXDBStreaming Error.

Also, my first call to the DB works, but not the rest. (first is: s_o <- sqlQuery(mxctl,s_o_query) ...see bottom of R code)

When I check the data types of the output, they are all of class data.frame.

I have attached my workflow. Thanks in advance!

ServiceAppNew.yxwz

JohnJPS

Other thougths include data embedded in the data table that doesn't write out nicely as character data; or simply a really large data frame that wants to be chunked...

Forcing to character data... you could try this prior to Write.Alteryx, where df is your data frame...

df[] <- lapply(df, as.character)

That way you should have a data frame that's all character data.

If it continues to fail, you could even try to write.csv manually from within tyour script, then using a Block Until Done tool, read in that output after the R tool has completed.  Hopefully it doesn't come to that, but it's something you could try.