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

[JohnJPS]

Hi @ries9112,

Could you try adding the square brackets as shown here:

prediction[] = lapply(prediction, as.character)

Hope that helps!

John

[ries9112]

Hey @JohnJPS, sorry I should have specified that I tried that as well and did not work. 

With this code:

Still getting this result:

It doesn't really matter at the end of the day because I just changed the R code to write csv files that are then picked up once the code finishes using a block until done tool, and that works totally fine and as expected, just a bit weird that the solution did not work for me when picking up the csv outputs works 100% fine, so thought I would share.

Thanks anyways!
Ricky

[Tam]

Thanks for @JohnJPS explanation note.