* using log directory 'd:/Rcompile/CRANpkg/local/4.5/CodelistGenerator.Rcheck'
* using R Under development (unstable) (2024-06-07 r86704 ucrt)
* using platform: x86_64-w64-mingw32
* R was compiled by
    gcc.exe (GCC) 13.2.0
    GNU Fortran (GCC) 13.2.0
* running under: Windows Server 2022 x64 (build 20348)
* using session charset: UTF-8
* checking for file 'CodelistGenerator/DESCRIPTION' ... OK
* this is package 'CodelistGenerator' version '3.0'
* package encoding: UTF-8
* checking package namespace information ... OK
* checking package dependencies ... OK
* checking if this is a source package ... OK
* checking if there is a namespace ... OK
* checking for hidden files and directories ... OK
* checking for portable file names ... OK
* checking whether package 'CodelistGenerator' can be installed ... OK
* checking installed package size ... OK
* checking package directory ... OK
* checking 'build' directory ... OK
* checking DESCRIPTION meta-information ... OK
* checking top-level files ... OK
* checking for left-over files ... OK
* checking index information ... OK
* checking package subdirectories ... OK
* checking code files for non-ASCII characters ... OK
* checking R files for syntax errors ... OK
* checking whether the package can be loaded ... [0s] OK
* checking whether the package can be loaded with stated dependencies ... [0s] OK
* checking whether the package can be unloaded cleanly ... [0s] OK
* checking whether the namespace can be loaded with stated dependencies ... [0s] OK
* checking whether the namespace can be unloaded cleanly ... [1s] OK
* checking loading without being on the library search path ... [1s] OK
* checking use of S3 registration ... OK
* checking dependencies in R code ... OK
* checking S3 generic/method consistency ... OK
* checking replacement functions ... OK
* checking foreign function calls ... OK
* checking R code for possible problems ... [6s] OK
* checking Rd files ... [1s] OK
* checking Rd metadata ... OK
* checking Rd cross-references ... OK
* checking for missing documentation entries ... OK
* checking for code/documentation mismatches ... OK
* checking Rd \usage sections ... OK
* checking Rd contents ... OK
* checking for unstated dependencies in examples ... OK
* checking R/sysdata.rda ... OK
* checking installed files from 'inst/doc' ... OK
* checking files in 'vignettes' ... OK
* checking examples ... [2s] OK
* checking for unstated dependencies in 'tests' ... OK
* checking tests ... [110s] ERROR
  Running 'testthat.R' [109s]
Running the tests in 'tests/testthat.R' failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional test configuration?
  > # Learn more about the roles of various files in:
  > # * https://r-pkgs.org/tests.html
  > # * https://testthat.r-lib.org/reference/test_package.html#special-files
  > 
  > library(testthat)
  > library(CodelistGenerator)
  > 
  > test_check("CodelistGenerator")
  Starting 2 test processes
  [ FAIL 1 | WARN 0 | SKIP 11 | PASS 346 ]
  
  ══ Skipped tests (11) ══════════════════════════════════════════════════════════
  • On CRAN (4): 'test-summariseCodeUse.R:2:1', 'test-summariseCodeUse.R:293:3',
    'test-summariseOrphanCodes.R:81:3', 'test-getCandidateCodes.R:310:3'
  • Sys.getenv("CDM5_REDSHIFT_DBNAME") == "" is TRUE (4):
    'test-codesFrom.R:100:3', 'test-dbms.R:5:3', 'test-findUnmappedCodes.R:3:3',
    'test-summariseCodeUse.R:490:3'
  • Sys.getenv("CDM5_SQL_SERVER_SERVER") == "" is TRUE (1):
    'test-codesInUse.R:36:3'
  • Sys.getenv("SNOWFLAKE_SERVER") == "" is TRUE (1): 'test-dbms.R:143:3'
  • Sys.getenv("darwinDbDatabaseServer") == "" is TRUE (1):
    'test-synthea_sql_server.R:2:3'
  
  ══ Failed tests ════════════════════════════════════════════════════════════════
  ── Error ('test-tableCodeUse.R:238:3'): table code use output formats ──────────
  Error in `dplyr::collect(removeClass(x, "cdm_table"))`: Failed to collect lazy table.
  Caused by error:
  ! rapi_execute: Failed to run query
  Error: Out of Memory Error: Failed to allocate block of 1048576 bytes (bad allocation)
  Backtrace:
       ▆
    1. ├─CodelistGenerator::summariseCodeUse(...) at test-tableCodeUse.R:238:3
    2. │ └─CodelistGenerator:::getCodeUse(...)
    3. │   └─CodelistGenerator:::getSummaryCounts(...)
    4. │     ├─dplyr::bind_rows(...)
    5. │     │ └─rlang::list2(...)
    6. │     └─CodelistGenerator:::getGroupedPersonCount(...)
    7. │       ├─... %>% dplyr::mutate(estimate_name = "person_count")
    8. │       ├─dplyr::bind_rows(...)
    9. │       │ └─rlang::list2(...)
   10. │       └─... %>% dplyr::collect()
   11. ├─dplyr::mutate(., estimate_name = "person_count")
   12. ├─visOmopResults::uniteStrata(., cols = groupBy)
   13. │ └─visOmopResults::uniteNameLevel(...)
   14. │   └─visOmopResults:::assertTibble(x, columns = cols)
   15. │     └─visOmopResults:::assertNull(x, null, errorMessage, call)
   16. ├─dplyr::collect(.)
   17. ├─omopgenerics:::collect.cdm_table(.)
   18. │ ├─dplyr::collect(removeClass(x, "cdm_table"))
   19. │ └─dbplyr:::collect.tbl_sql(removeClass(x, "cdm_table"))
   20. │   ├─base::withCallingHandlers(...)
   21. │   ├─dbplyr::db_collect(...)
   22. │   └─dbplyr:::db_collect.DBIConnection(...)
   23. │     ├─DBI::dbSendQuery(con, sql)
   24. │     └─duckdb::dbSendQuery(con, sql)
   25. │       └─duckdb (local) .local(conn, statement, ...)
   26. │         └─duckdb:::duckdb_result(...)
   27. │           └─duckdb:::duckdb_execute(res)
   28. │             └─duckdb:::rapi_execute(...)
   29. └─base::.handleSimpleError(...)
   30.   └─dbplyr (local) h(simpleError(msg, call))
   31.     └─cli::cli_abort("Failed to collect lazy table.", parent = cnd)
   32.       └─rlang::abort(...)
  
  [ FAIL 1 | WARN 0 | SKIP 11 | PASS 346 ]
  Error: Test failures
  Execution halted
* checking for unstated dependencies in vignettes ... OK
* checking package vignettes ... OK
* checking re-building of vignette outputs ... [27s] OK
* checking PDF version of manual ... [23s] OK
* checking HTML version of manual ... [5s] OK
* DONE
Status: 1 ERROR