Athena Login Error: Error in h(simpleError(msg, call))

[luisccmm]

Error when trying to log in.

Script

con_athena <- dbConnect(RAthena::athena(),
                        aws_access_key_id='XXXXXXXXXXXXXXX',
                         aws_secret_access_key='XXXXXXXXXXXXXXXXXXXXXXXX',
                         s3_staging_dir=XXXXXXXXXXXXXXXXXXXXXXXX',
                         region_name='eu-central-1')
                         

ERROR MESSAGE
Error in h(simpleError(msg, call)) :
error in evaluating the argument 'drv' in selecting a method for function 'dbConnect': ‘jdrv’ is not a slot in class “AthenaDriver”

• Session info -----------------------------------------------------------------------------------------
  setting value
  version R version 4.2.1 (2022-06-23 ucrt)
  os Windows Server x64 (build 14393)
  system x86_64, mingw32
  ui RStudio
  language (EN)
  collate Spanish_Spain.1252
  ctype Spanish_Spain.1252
  tz Europe/Paris
  date 2023-09-28
  rstudio 2022.02.3+492 Prairie Trillium (desktop)
  pandoc NA

• Packages ---------------------------------------------------------------------------------------------
  ! package * version date (UTC) lib source
  assertthat 0.2.1 2019-03-21 [1] CRAN (R 4.2.2)
  AWR.Athena 2.0.7-0 2023-07-27 [1] Github (nfultz/AWR.Athena@849d948)
  cachem 1.0.6 2021-08-19 [1] CRAN (R 4.2.1)
  callr 3.7.2 2022-08-22 [1] CRAN (R 4.2.1)
  cli 3.4.1 2022-09-23 [1] CRAN (R 4.2.1)
  crayon 1.5.2 2022-09-29 [1] CRAN (R 4.2.1)
  data.table 1.14.2 2021-09-27 [1] CRAN (R 4.2.1)
  DBI * 1.1.3 2022-06-18 [1] CRAN (R 4.2.2)
  devtools 2.4.4 2022-07-20 [1] CRAN (R 4.2.1)
  digest 0.6.29 2021-12-01 [1] CRAN (R 4.2.1)
  dplyr 1.0.10 2022-09-01 [1] CRAN (R 4.2.2)
  ellipsis 0.3.2 2021-04-29 [1] CRAN (R 4.2.1)
  fansi 1.0.3 2022-03-24 [1] CRAN (R 4.2.1)
  fastmap 1.1.0 2021-01-25 [1] CRAN (R 4.2.1)
  fs 1.5.2 2021-12-08 [1] CRAN (R 4.2.1)
  generics 0.1.3 2022-07-05 [1] CRAN (R 4.2.1)
  glue 1.6.2 2022-02-24 [1] CRAN (R 4.2.1)
  htmltools 0.5.3 2022-07-18 [1] CRAN (R 4.2.1)
  htmlwidgets 1.5.4 2021-09-08 [1] CRAN (R 4.2.1)
  httpuv 1.6.6 2022-09-08 [1] CRAN (R 4.2.1)
  jsonlite 1.8.2 2022-10-02 [1] CRAN (R 4.2.1)
  knitr 1.40 2022-08-24 [1] CRAN (R 4.2.1)
  later 1.3.0 2021-08-18 [1] CRAN (R 4.2.1)
  lattice 0.20-45 2021-09-22 [1] CRAN (R 4.2.1)
  lifecycle 1.0.3 2022-10-07 [1] CRAN (R 4.2.1)
  magrittr 2.0.3 2022-03-30 [1] CRAN (R 4.2.1)
  Matrix 1.4-1 2022-03-23 [1] CRAN (R 4.2.1)
  memoise 2.0.1 2021-11-26 [1] CRAN (R 4.2.1)
  mime 0.12 2021-09-28 [1] CRAN (R 4.2.0)
  miniUI 0.1.1.1 2018-05-18 [1] CRAN (R 4.2.1)
  pillar 1.8.1 2022-08-19 [1] CRAN (R 4.2.1)
  pkgbuild 1.3.1 2021-12-20 [1] CRAN (R 4.2.1)
  pkgconfig 2.0.3 2019-09-22 [1] CRAN (R 4.2.1)
  pkgload 1.3.0 2022-06-27 [1] CRAN (R 4.2.1)
  png 0.1-7 2013-12-03 [1] CRAN (R 4.2.0)
  prettyunits 1.1.1 2020-01-24 [1] CRAN (R 4.2.1)
  processx 3.7.0 2022-07-07 [1] CRAN (R 4.2.1)
  profvis 0.3.7 2020-11-02 [1] CRAN (R 4.2.1)
  promises 1.2.0.1 2021-02-11 [1] CRAN (R 4.2.1)
  ps 1.7.1 2022-06-18 [1] CRAN (R 4.2.1)
  purrr 0.3.5 2022-10-06 [1] CRAN (R 4.2.1)
  R6 2.5.1 2021-08-19 [1] CRAN (R 4.2.1)
  RAthena 2.6.1 2022-12-20 [1] CRAN (R 4.2.3)
  Rcpp 1.0.9 2022-07-08 [1] CRAN (R 4.2.1)
  remotes 2.4.2 2021-11-30 [1] CRAN (R 4.2.2)
  reticulate 1.30 2023-06-09 [1] CRAN (R 4.2.3)
  D rJava 1.0-6 2021-12-10 [1] CRAN (R 4.2.0)
  RJDBC 0.2-10 2022-03-24 [1] CRAN (R 4.2.3)
  rlang 1.0.6 2022-09-24 [1] CRAN (R 4.2.1)
  rstudioapi 0.14 2022-08-22 [1] CRAN (R 4.2.1)
  sessioninfo 1.2.2 2021-12-06 [1] CRAN (R 4.2.1)
  shiny 1.7.2 2022-07-19 [1] CRAN (R 4.2.1)
  stringi 1.7.8 2022-07-11 [1] CRAN (R 4.2.1)
  stringr 1.5.0 2022-12-02 [1] CRAN (R 4.2.3)
  tibble 3.1.8 2022-07-22 [1] CRAN (R 4.2.1)
  tidyselect 1.2.0 2022-10-10 [1] CRAN (R 4.2.2)
  urlchecker 1.0.1 2021-11-30 [1] CRAN (R 4.2.1)
  usethis 2.1.6 2022-05-25 [1] CRAN (R 4.2.1)
  utf8 1.2.2 2021-07-24 [1] CRAN (R 4.2.1)
  vctrs 0.4.2 2022-09-29 [1] CRAN (R 4.2.1)
  xfun 0.33 2022-09-12 [1] CRAN (R 4.2.1)
  xtable 1.8-4 2019-04-21 [1] CRAN (R 4.2.1)

[1] C:/Users/luis.carmona/Documents/R-4.2.1/library

D -- DLL MD5 mismatch, broken installation.

[DyfanJones]

I believe you are getting an error due to AWR.Athena. RAthena class is different from AWR.Athena and doesn't create an jdr slot.

Both AWR.Athena and RAthena create a class called AthenaDriver, this is the confusion you are getting :)

I recommend you cleaning your session and initialise RAthena without AWR.Athena in your environment.