OHDSI Home | Forums | Wiki | Github

Achilles install issue

Hello Folks ,

Trying to install the Achilles on windows in R but getting below Error while trying to install the sqlrender Thanks a lot in advance :slight_smile: 1.SQL render

install_github(“ohdsi/SqlRender”, args="–no-multiarch")
Downloading GitHub repo ohdsi/SqlRender@master

checking for file ‘C:\Users\Admin\AppData\Local\Temp\RtmpCeCFYl\remotes33ccd7c71f0\OHDSI-SqlRender-b969427/DESCRIPTION’ …

√ checking for file ‘C:\Users\Admin\AppData\Local\Temp\RtmpCeCFYl\remotes33ccd7c71f0\OHDSI-SqlRender-b969427/DESCRIPTION’ (344ms)

  • preparing ‘SqlRender’:
    checking DESCRIPTION meta-information …

    checking DESCRIPTION meta-information …

√ checking DESCRIPTION meta-information

  • checking for LF line-endings in source and make files and shell scripts

  • checking for empty or unneeded directories

  • building ‘SqlRender_1.6.3.tar.gz’

Installing package into ‘C:/Users/Admin/Documents/R/win-library/3.6’
(as ‘lib’ is unspecified)

  • installing source package ‘SqlRender’ …
    ** using staged installation
    ** R
    ** inst
    ** byte-compile and prepare package for lazy loading
    Error: .onLoad failed in loadNamespace() for ‘rJava’, details:
    call: inDL(x, as.logical(local), as.logical(now), …)
    error: unable to load shared object ‘C:/Users/Admin/Documents/R/win-library/3.6/rJava/libs/x64/rJava.dll’:
    LoadLibrary failure: The specified module could not be found.
    Execution halted
    ERROR: lazy loading failed for package ‘SqlRender’
  • removing ‘C:/Users/Admin/Documents/R/win-library/3.6/SqlRender’
  • restoring previous ‘C:/Users/Admin/Documents/R/win-library/3.6/SqlRender’
    Error: Failed to install ‘SqlRender’ from GitHub:
    (converted from warning) installation of package ‘C:/Users/Admin/AppData/Local/Temp/RtmpCeCFYl/file33ccd2f6f32/SqlRender_1.6.3.tar.gz’ had non-zero exit status
    Error in validate_signal_args(msg, type, call, .subclass) :
    unused argument (.subclass)
  1. Database connector

install_github(“ohdsi/DatabaseConnector”)
Downloading GitHub repo ohdsi/DatabaseConnector@master
These packages have more recent versions available.
Which would you like to update?

1: All
2: CRAN packages only
3: None
4: bit (1.1-14 → 1.1-15.1) [CRAN]
5: DBI (1.0.0 → 1.1.0 ) [CRAN]

Enter one or more numbers, or an empty line to skip updates:

√ checking for file ‘C:\Users\Admin\AppData\Local\Temp\RtmpCeCFYl\remotes33cc758660bb\OHDSI-DatabaseConnector-aedc5e8/DESCRIPTION’ (438ms)

  • preparing ‘DatabaseConnector’: (717ms)
    checking DESCRIPTION meta-information …

    checking DESCRIPTION meta-information …

√ checking DESCRIPTION meta-information

  • installing the package to process help pages

      -----------------------------------
    
  • installing source package ‘DatabaseConnector’ …
    ** using staged installation
    ** R
    ** inst
    ** byte-compile and prepare package for lazy loading
    Error: .onLoad failed in loadNamespace() for ‘rJava’, details:
    call: inDL(x, as.logical(local), as.logical(now), …)
    error: unable to load shared object ‘C:/Users/Admin/Documents/R/win-library/3.6/rJava/libs/x64/rJava.dll’:
    LoadLibrary failure: The specified module could not be found.
    Execution halted
    ERROR: lazy loading failed for package ‘DatabaseConnector’

  • removing ‘C:/Users/Admin/AppData/Local/Temp/Rtmpg1fMjM/Rinst33d079ad58c9/DatabaseConnector’
    -----------------------------------
    ERROR: package installation failed

Error: Failed to install ‘DatabaseConnector’ from GitHub:
System command error, exit status: 1, stdout + stderr (last 10 lines):
E> ** byte-compile and prepare package for lazy loading
E> Error: .onLoad failed in loadNamespace() for ‘rJava’, details:
E> call: inDL(x, as.logical(local), as.logical(now), …)
E> error: unable to load shared object ‘C:/Users/Admin/Documents/R/win-library/3.6/rJava/libs/x64/rJava.dll’:
E> LoadLibrary failure: The specified module could not be found.
E> Execution halted
E> ERROR: lazy loading failed for package ‘DatabaseConnector’
E> * removing ‘C:/Users/Admin/AppData/Local/Temp/Rtmpg1fMjM/Rinst33d079ad58c9/DatabaseConnector’
E> -----------------------------------
E> ERROR: package installation failed

Regards
Abhishek Verma

This looks a lot like issues with rJava. I’ve dealt with it on macos, but not windows. stackoverflow.com was helpful.

Install JDK 8, make sure JAVA_HOME OS variable is set. Run R CMD javareconf to ensure that the Java config is set properly.

t