* using log directory 'd:/RCompile/CRANincoming/R-devel/CommonDataModel.Rcheck' * using R Under development (unstable) (2024-01-29 r85841 ucrt) * using platform: x86_64-w64-mingw32 * R was compiled by gcc.exe (GCC) 12.3.0 GNU Fortran (GCC) 12.3.0 * running under: Windows Server 2022 x64 (build 20348) * using session charset: UTF-8 * checking for file 'CommonDataModel/DESCRIPTION' ... OK * checking extension type ... Package * this is package 'CommonDataModel' version '0.2.0' * package encoding: UTF-8 * checking CRAN incoming feasibility ... NOTE Maintainer: 'Clair Blacketer ' New submission Possibly misspelled words in DESCRIPTION: CDM (3:13) DDL (3:17, 7:86, 7:186) OHDSql (7:64, 7:208) OMOP (3:8) SqlRender (7:153) csv (7:41) Package has a VignetteBuilder field but no prebuilt vignette index. The Description field should not start with the package name, 'This package' or similar. * 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 serialization versions ... OK * checking whether package 'CommonDataModel' can be installed ... OK * checking installed package size ... OK * checking package directory ... OK * checking for future file timestamps ... OK * checking DESCRIPTION meta-information ... OK * checking top-level files ... NOTE Non-standard file/directory found at top level: 'output' * checking for left-over files ... OK * checking index information ... OK * checking package subdirectories ... OK * checking R files for non-ASCII characters ... OK * checking R files for syntax errors ... OK * checking whether the package can be loaded ... OK * checking whether the package can be loaded with stated dependencies ... OK * checking whether the package can be unloaded cleanly ... OK * checking whether the namespace can be loaded with stated dependencies ... OK * checking whether the namespace can be unloaded cleanly ... OK * checking loading without being on the library search path ... 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 ... OK * checking Rd files ... NOTE checkRd: (-1) listSupportedVersions.Rd:10: Lost braces; missing escapes or markup? 10 | A character vector containing the support CDM versions in {major}.{minor} format. | ^ checkRd: (-1) listSupportedVersions.Rd:10: Lost braces; missing escapes or markup? 10 | A character vector containing the support CDM versions in {major}.{minor} format. | ^ * checking Rd metadata ... OK * checking Rd line widths ... 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 examples ... OK * checking for unstated dependencies in 'tests' ... OK * checking tests ... [19s] ERROR Running 'testthat.R' [19s] Running the tests in 'tests/testthat.R' failed. Complete output: > library(testthat) > library(CommonDataModel) > > test_check("CommonDataModel") DATABASECONNECTOR_JAR_FOLDER environment variable is empty string downloading drivers Consider adding `DATABASECONNECTOR_JAR_FOLDER='D:\temp\RtmpeASzDs'` to C:\Users\CRAN\Documents/.Renviron and restarting R. trying URL 'https://s3.amazonaws.com/redshift-downloads/drivers/jdbc/2.1.0.20/redshift-jdbc42-2.1.0.20.zip' Content type 'application/zip' length 8434563 bytes (8.0 MB) ================================================== downloaded 8.0 MB DatabaseConnector redshift JDBC driver downloaded to 'D:\temp\RtmpeASzDs'. Consider adding `DATABASECONNECTOR_JAR_FOLDER='D:\temp\RtmpeASzDs'` to C:\Users\CRAN\Documents/.Renviron and restarting R. trying URL 'https://ohdsi.github.io/DatabaseConnectorJars/postgresqlV42.2.18.zip' Content type 'application/zip' length 931791 bytes (909 KB) ================================================== downloaded 909 KB DatabaseConnector postgresql JDBC driver downloaded to 'D:\temp\RtmpeASzDs'. Consider adding `DATABASECONNECTOR_JAR_FOLDER='D:\temp\RtmpeASzDs'` to C:\Users\CRAN\Documents/.Renviron and restarting R. trying URL 'https://ohdsi.github.io/DatabaseConnectorJars/oracleV19.8.zip' Content type 'application/zip' length 4101479 bytes (3.9 MB) ================================================== downloaded 3.9 MB DatabaseConnector oracle JDBC driver downloaded to 'D:\temp\RtmpeASzDs'. Consider adding `DATABASECONNECTOR_JAR_FOLDER='D:\temp\RtmpeASzDs'` to C:\Users\CRAN\Documents/.Renviron and restarting R. trying URL 'https://ohdsi.github.io/DatabaseConnectorJars/sqlServerV9.2.0.zip' Content type 'application/zip' length 1262814 bytes (1.2 MB) ================================================== downloaded 1.2 MB DatabaseConnector sql server JDBC driver downloaded to 'D:\temp\RtmpeASzDs'. Connecting using PostgreSQL driver Connecting using PostgreSQL driver Connecting using PostgreSQL driver [ FAIL 5 | WARN 0 | SKIP 0 | PASS 31 ] ══ Failed tests ════════════════════════════════════════════════════════════════ ── Failure ('test-buildRelease.R:28:3'): buildRelease() output matches current ddl folder ── `generatedChecksums` (`actual`) and `currentChecksums` (`expected`) don't have the same values. * Only in `expected`: "8064ffa411b064848b7d2afab62dec9f", "012160a71e04897a3dc3feb211becd35", "a7570793c66e6c768451797dec29e762", "4952e058560ceb933da0f7759268cabf", "fd3d0b83aa6040695495fa77c536d90e", "c334af8007dc3b5f0b80dc2b4639d564", "de1be54d4589128832ab58ce63309247", "a83a2836d56da9638060b2784e290df3", "da5388cfaadd5c23dbdf6195728b3c9c", ... * Only in `actual`: "8c6e497df029d8854f33c602d8ba3f09", "7851a38d2fa642fdd711e27bc4c2e02e", "cd0836cd3724dbf35ee4c95927a06ead", "4215e201715ac1f19bda5cd19ffa8df5", "6b1b91ffcf66d881bad95ab230da4166", "6c3745405775d8537e79e9ea337a66de", "d087ca68b156f327ba753e9df37fec3d", "3983b25a0f09517e38207b54db7a43d7", "b5b6fb03cb6c50d2599603755a0543f5", ... ── Failure ('test-executeDdl.R:19:5'): Can connect to postgresql ─────────────── `con <- connect(connectionDetails)` threw an unexpected error. Message: Error: database name not included in server string but is required for PostgreSQL. Please specify server as / Class: rlang_error/error/condition Backtrace: ▆ 1. ├─testthat::expect_error(con <- connect(connectionDetails), NA) at test-executeDdl.R:19:5 2. │ └─testthat:::expect_condition_matching(...) 3. │ └─testthat:::quasi_capture(...) 4. │ ├─testthat (local) .capture(...) 5. │ │ └─base::withCallingHandlers(...) 6. │ └─rlang::eval_bare(quo_get_expr(.quo), quo_get_env(.quo)) 7. └─DatabaseConnector::connect(connectionDetails) 8. └─DatabaseConnector:::connectUsingJdbc(connectionDetails) 9. └─DatabaseConnector:::connectPostgreSql(connectionDetails) 10. └─rlang::abort("Error: database name not included in server string but is required for PostgreSQL. Please specify server as /") ── Failure ('test-executeDdl.R:20:5'): Can connect to postgresql ─────────────── `disconnect(con)` threw an unexpected error. Message: object 'con' not found Class: simpleError/error/condition Backtrace: ▆ 1. ├─testthat::expect_error(disconnect(con), NA) at test-executeDdl.R:20:5 2. │ └─testthat:::expect_condition_matching(...) 3. │ └─testthat:::quasi_capture(...) 4. │ ├─testthat (local) .capture(...) 5. │ │ └─base::withCallingHandlers(...) 6. │ └─rlang::eval_bare(quo_get_expr(.quo), quo_get_env(.quo)) 7. └─DatabaseConnector::disconnect(con) ── Error ('test-executeDdl.R:26:7'): DDL 5.3 runs on postgresql ──────────────── Error in `connectPostgreSql(connectionDetails)`: Error: database name not included in server string but is required for PostgreSQL. Please specify server as / Backtrace: ▆ 1. └─CommonDataModel:::dropAllTablesFromSchema(...) at test-executeDdl.R:26:7 2. └─CommonDataModel:::listTablesInSchema(connectionDetails, schema) at D:\RCompile\CRANincoming\R-devel\CommonDataModel.Rcheck\tests\testthat\setup.R:99:3 3. └─DatabaseConnector::connect(connectionDetails) at D:\RCompile\CRANincoming\R-devel\CommonDataModel.Rcheck\tests\testthat\setup.R:84:3 4. └─DatabaseConnector:::connectUsingJdbc(connectionDetails) 5. └─DatabaseConnector:::connectPostgreSql(connectionDetails) 6. └─rlang::abort("Error: database name not included in server string but is required for PostgreSQL. Please specify server as /") ── Error ('test-executeDdl.R:26:7'): DDL 5.4 runs on postgresql ──────────────── Error in `connectPostgreSql(connectionDetails)`: Error: database name not included in server string but is required for PostgreSQL. Please specify server as / Backtrace: ▆ 1. └─CommonDataModel:::dropAllTablesFromSchema(...) at test-executeDdl.R:26:7 2. └─CommonDataModel:::listTablesInSchema(connectionDetails, schema) at D:\RCompile\CRANincoming\R-devel\CommonDataModel.Rcheck\tests\testthat\setup.R:99:3 3. └─DatabaseConnector::connect(connectionDetails) at D:\RCompile\CRANincoming\R-devel\CommonDataModel.Rcheck\tests\testthat\setup.R:84:3 4. └─DatabaseConnector:::connectUsingJdbc(connectionDetails) 5. └─DatabaseConnector:::connectPostgreSql(connectionDetails) 6. └─rlang::abort("Error: database name not included in server string but is required for PostgreSQL. Please specify server as /") [ FAIL 5 | WARN 0 | SKIP 0 | PASS 31 ] Error: Test failures Execution halted * checking PDF version of manual ... [14s] OK * checking HTML version of manual ... OK * DONE Status: 1 ERROR, 3 NOTEs