OHDSI Home | Forums | Wiki | Github

Fix for error trying to install Data Quality Dashboard

Were installing the Data Quality Dashboard R package using the instructions here:

Which indicate the following should be run from R:

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

— 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.

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.