Problems installing dplyr-snowflakedb

[pfifas]

Hi Snowflake-Team,

I encounter an error installing this using devtools. The error message is rather cryptic:

√  checking for file '####\AppData\Local\Temp\RtmpsLvk57\remotes177c66e07207\snowflakedb-dplyr-snowflakedb-a4299ad/DESCRIPTION' (867ms)
-  preparing 'dplyr.snowflakedb':
√  checking DESCRIPTION meta-information ... 
-  checking for LF line-endings in source and make files and shell scripts
-  checking for empty or unneeded directories
-  building 'dplyr.snowflakedb_0.3.0.tar.gz'

Installing package into ‘####/R/win-library/3.6’
(as ‘lib’ is unspecified)
* installing *source* package 'dplyr.snowflakedb' ...
** using staged installation
** R
** byte-compile and prepare package for lazy loading
Error:  (converted from warning) package 'RJDBC' was created under R version 3.6.1
Execution stopped
ERROR: lazy loading failed for package 'dplyr.snowflakedb'
* removing '#####/R/win-library/3.6/dplyr.snowflakedb'
Error in i.p(...) : 
  (converted from warning) installation of package ‘#####/AppData/Local/Temp/RtmpsLvk57/file177c68ac45af/dplyr.snowflakedb_0.3.0.tar.gz’ had non-zero exit status

I have installed Java JDK and RJava successfully. Any clue what might be the causing this error?

Here is my Session Info:

sessionInfo()
R version 3.6.0 (2019-04-26)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 17134)

Matrix products: default

locale:
[1] LC_COLLATE=German_Germany.1252  LC_CTYPE=German_Germany.1252    LC_MONETARY=German_Germany.1252
[4] LC_NUMERIC=C                    LC_TIME=German_Germany.1252    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

loaded via a namespace (and not attached):
 [1] Rcpp_1.0.1        rstudioapi_0.10   magrittr_1.5      usethis_1.5.0     devtools_2.0.2    pkgload_1.0.2    
 [7] R6_2.4.0          rlang_0.4.0       tools_3.6.0       pkgbuild_1.0.3    sessioninfo_1.1.1 cli_1.1.0        
[13] withr_2.1.2       remotes_2.0.4     assertthat_0.2.1  digest_0.6.18     rprojroot_1.3-2   crayon_1.3.4     
[19] processx_3.3.1    callr_3.2.0       fs_1.3.1          ps_1.3.0          curl_3.3          testthat_2.1.1   
[25] memoise_1.1.0     glue_1.3.1        compiler_3.6.0    desc_1.2.0        backports_1.1.4   prettyunits_1.0.2

Any help much appreciated.

Best P

[rdatasculptor]

I had the same error. @pfifas have you figured out how to install properly?

If not, help from Snowflake company is most appreciated.

[rdatasculptor]

Okay, solved it.

Error: (converted from warning) package 'RJDBC' was created under R version 3.6.1

Try update your R installation to the one mentioned above. It solved the problem for me.

[pfifas]

@rdatasculptor apologies for the late reply, but yes that does the trick for me! Thanks!