OHDSI Home | Forums | Wiki | Github

SqlRender Install Issues

Hello,

For some reason my my Achilles instance stopped working so I started over reinstalling everything. When I get to the step of installing running install_github(“ohdsi/SqlRender”) in R, I get the following error…

23: tools:::.test_load_package(“SqlRender”, “/usr/lib64/R/library”)
An irrecoverable exception occurred. R is aborting now …
ERROR: loading failed

  • removing ‘/usr/lib64/R/library/SqlRender’
    Installation failed: Command failed (1)
    ‘/usr/lib64/R/bin/R’ --no-site-file --no-environ --no-save --no-restore
    –quiet CMD INSTALL
    ‘/tmp/RtmpZKsIbV/devtoolsada2d0de44b/OHDSI-DatabaseConnector-af471f3’
    –library=’/usr/lib64/R/library’ --install-tests

Might it be related to this?

Yeah that seems to be the root of it. I’m on CentoOS. When I downgraded from 2.6.32-696.3.2.el6.x86_64 to 2.6.32-696.3.1.el6.x86_64, things seem to be working again. Thanks for your help.

i everyone,
im a new user of the OHDSI package for an SCCS analyses. I have some issue when installing the SqlRender package and it seems that the problem is coming from library (rjava), i have already reinstall Java. Please i need some help, im not a developer neither a statistician, just an epidemiologist student. Thank you.
This is what i get when i run: install_github(“ohdsi/SqlRender”)
Downloading GitHub repo ohdsi/SqlRender@master
from URL https://api.github.com/repos/ohdsi/SqlRender/zipball/master
Installing SqlRender
“C:/PROGRA~1/R/R-33~1.3/bin/x64/R” --no-site-file --no-environ --no-save --no-restore
–quiet CMD INSTALL
“C:/Users/Toshiba/AppData/Local/Temp/RtmpkdmU7s/devtools16745fe457dc/OHDSI-SqlRender-2fe5b3b”
–library=“C:/Users/Toshiba/Documents/R/win-library/3.3” --install-tests

installing source package ‘SqlRender’ …
** R
** inst
** tests
** preparing package for lazy loading
Error : .onLoad failed in loadNamespace() for ‘rJava’, details:
call: fun(libname, pkgname)
error: No CurrentVersion entry in Software/JavaSoft registry! Try re-installing Java and make sure R and Java have matching architectures.
ERROR: lazy loading failed for package ‘SqlRender’
removing ‘C:/Users/Toshiba/Documents/R/win-library/3.3/SqlRender’
restoring previous ‘C:/Users/Toshiba/Documents/R/win-library/3.3/SqlRender’
Installation failed: Command failed (1)

Have you tried installing both 32-bit and 64-bit versions of Java, as recommended in the video tutorial?

t