Alteryx does not recognize R lemon package

[DeorajK]

I'm using R lemon package to build out some charts. However, after running my workflow I'm getting the error message in the attachment.  

I have the lemon package installed on my machine but Alteryx is not recognizing it.

I'm using Alteryx 2018.4 and I have downloaded the updated version of the lemon R package. 

Is the error a result of Alteryx 2018.4 not compatible with the lemon package?

Here are my R codes:

.libPaths()
mydata <- read.Alteryx("#1", mode="data.frame")
AlteryxGraph(1, width=12000, height=6000, res=500)
library(ggplot2)
library(lemon)

mydata$Numb <- mydata$Count

# Stacked
ggplot(mydata, aes(x=DateCalc, y=Count, fill=ItemDue)) +
geom_col(position = "stack", width = 0.2)+
facet_rep_wrap(~FinalAuditName,scales = "fixed", repeat.tick.labels = TRUE)+
scale_y_continuous(breaks=seq(0, 10, 1))+
theme(axis.text.x = element_text(angle = 45))+
theme(axis.text = element_text(size = 6))+
theme(axis.title = element_text(size = 10))+
ggtitle("Audit Finding Due Date Forecast")+
xlab("")+ ylab("# of Deliverables")
invisible(dev.off())

[vsoni · Accepted solution]

It looks like the 'ggplot_add' is a dependency of the lemon package which isn't installed.

I've created a post which you should be able to re-work to automatically get and install all required dependencies here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Offline-R-and-Python-Package-Installat...

[DeorajK]

Thank you very much! This works well for me.

[DeorajK]

After I install the R packages extensions all is working well until I published the workflow to the server.

I received the below message when I ran the workflow from the server. Does this mean Alteryx server doesn't have the R package extensions? If so, how do I fix this?

Oops!

The job FindingsReport_Infra_RE did not complete successfully and resulted in the following errors:

• Error in library(lemon) : there is no package called 'lemon' (Tool Id: 232)
• Execution halted (Tool Id: 232)
• The R.exe exit code (1) indicated an error. (Tool Id: 232)
• Error in library(lemon) : there is no package called 'lemon' (Tool Id: 175)
• Execution halted (Tool Id: 175)
• The R.exe exit code (1) indicated an error. (Tool Id: 175)
• Error in library(lemon) : there is no package called 'lemon' (Tool Id: 296)
• Execution halted (Tool Id: 296)
• The R.exe exit code (1) indicated an error. (Tool Id: 296)
• Error in library(lemon) : there is no package called 'lemon' (Tool Id: 333)
• Execution halted (Tool Id: 333)
• The R.exe exit code (1) indicated an error. (Tool Id: 333)

[vsoni]

It looks like the packages aren't installed on your Alteryx Server, which is why youre getting these errors.

Once the packages are installed on the server, you should be able to run the script - you can install them using Designer on your Alteryx server.

Note: Dependencies also need to be installed.

[DeorajK]

Thank  you very much for your reply.

Can you share the instructions how to install the packages with the dependencies on the server? I want to make sure I'm doing this the right way because we will be using a lot of R packages in our workflows.

Looking forward for your reply.

Thanks,

Deoraj.

[BenMoss]

Here's a blog post I created on this subject, hopefully it's of use: https://www.theinformationlab.co.uk/2019/01/17/installing-r-packages-both-on-alteryx-designer-and-on...

[DeorajK]

Thank you for your response. I have informed the server admin team to have a look.