R Under development (unstable) (2024-01-29 r85841 ucrt) -- "Unsuffered Consequences" Copyright (C) 2024 The R Foundation for Statistical Computing Platform: x86_64-w64-mingw32/x64 R is free software and comes with ABSOLUTELY NO WARRANTY. You are welcome to redistribute it under certain conditions. Type 'license()' or 'licence()' for distribution details. R is a collaborative project with many contributors. Type 'contributors()' for more information and 'citation()' on how to cite R or R packages in publications. Type 'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. > 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