Were installing the Data Quality Dashboard R package using the instructions here:
Which indicate the following should be run from R:
install.packages(“devtools”)
devtools::install_github(“OHDSI/DataQualityDashboard”)
However, when we run it we get errors like what is shown below.
— ERROR ------------------
…
Warning: package ‘DatabaseConnector’ was built under R version 4.0.5
Error: package or namespace load failed for ‘DatabaseConnector’:
.onLoad failed in loadNamespace() for ‘rJava’, details:
call: inDL(x, as.logical(local), as.logical(now), …)
error: unable to load shared object ‘C:/Users/greshje/AppData/Local/R/cache/R/renv/cache/v5/R-4.0/x86_64-w64-mingw32/rJava/1.0-4/0cd1ee479ba887170411af6d81705003/rJava/libs/i386/rJava.dll’:
LoadLibrary failure: %1 is not a valid Win32 application.
Error : package ‘DatabaseConnector’ could not be loaded
Error: loading failed
Execution halted
*** arch - x64
Warning: package ‘DatabaseConnector’ was built under R version 4.0.5
ERROR: loading failed for ‘i386’
- removing ‘C:/_WORKSPACES/_ECLIPSE_WORKSPACE/workspace/OMOP-Synthia/omop-synthea-etl/renv/library/R-4.0/x86_64-w64-mingw32/DataQualityDashboard’
installation of package �C:/Users/greshje/AppData/Local/Temp/Rtmp8uWnJX/file51bc27b720e/DataQualityDashboard_1.0.0.tar.gz� had non-zero exit status
etc…
— END ERROR --------------------
Our initial research suggests this is a missmatch between R and Java 32 v 64 bit versions. However, we confirmed this was not the issue. We were able to resolve by using the following instead.
install.packages("devtools")
devtools::install_github("OHDSI/DataQualityDashboard", INSTALL_opts=c("--no-multiarch"))
This same fix seems to apply to pretty much all of the packages that use the database connector.