Please help. I am getting below error when i try to install r packages in Alteryx
Code: install.packages(c("geosphere"), repos="http://cran.stat.nus.edu.sg/")
Error:
Info: R (4): Warning in install.packages(c("geosphere"), repos = "http://cran.stat.nus.edu.sg/") :
Info: R (4): 'lib = "C:/Program Files/Alteryx/R-3.4.4/library"' is not writable
Error: R (4): Error in install.packages(c("geosphere"), repos = "http://cran.stat.nus.edu.sg/") :
Info: R (4): unable to install packages
Error: R (4): Execution halted
Solved! Go to Solution.
Hi @alteryx_user,
I can't help directly on the GXBoost side, but i did have a similar issue with another R package. I think this error comes when one of the dependent packages is not up to date.
In the first instance, you can try to install the readr package using the R terminal directly. Go to
C:\Program Files\Alteryx\R-3.4.4\bin (or whatever Alteryx install folder you are using), open the terminal (run as admin) and type this (changed for your folders as required).
install.packages("readr", dependencies = TRUE, repos = "http://cran.us.r-project.org", lib = "C:\\Program Files\\Alteryx\\R-3.4.4\\library")
That should install an up to date version. If that doesn't work, it may be one of the dependent packages that is not up to date. In this case, the first thing to try is to figure out which package this is. I did this by trying to install the package using the R tool from the developer tab. In your case something like this should work - you just need any data stream to go in.
# Spatial objects returned as strings, use unserializeObject() to decode individual cells
the.data <- read.Alteryx("#1", mode="data.frame")
AlteryxMessage("Data Loaded as DF", msg.consts$INFO, priority.consts$LOW )
#conditional install function to install the package if not already there.
cond.install <- function(package.name){
options(repos = "http://cran.rstudio.com") #set repo
#check for package in library, if package is missing install
if(package.name%in%rownames(installed.packages())==FALSE) {
install.packages(package.name)}else{require(package.name, character.only = TRUE)}}
#call the function
cond.install("readr")
And after that you should get a message in the Alteryx results window which mentions a package and a version requirement - in my case it was the last line.
Then you can try to re-install this package to your R library using the same R terminal approach mentioned first. (see this link for more detail)
install.packages("YOUR PACKAGE", dependencies = TRUE, repos = "http://cran.us.r-project.org", lib = "C:\\Program Files\\Alteryx\\R-3.4.4\\library").
Hope this helps, however please bear in mind no guarantees that fixing any dependecies wont have any knock on effects elsewhere in the R tools within Alteryx (heopfully not).
Cheers
Tim
@alteryx_user updating the link - https://gallery.alteryx.com/#!app/Install-R-Packages/5d9264328a933711e447387c
After opening this application I'm not really sure how to use it. The only section that is clear is typing out the packages and using a comma between each package. Everything else is pretty unclear on what needs to be done. For example what is "Install the package(s) to your default personal directory"? Another example, what's "Select the folder where you would like the package(s) installed (you must have write permissions)"?
Hello,
I'm facing the same errors but i'm unable to access the workflow you shared.
Thank you
Hi,
Can you please update the link as I am getting Access Denied message?
Best,
@timrains This worked for me, thanks. The library needed to be installed in that specific folder because the version of R that alteryx is using is not the version of R that I use on a regular basis.