* using log directory 'd:/RCompile/CRANincoming/R-devel/ResultModelManager.Rcheck' * using R Under development (unstable) (2025-09-14 r88831 ucrt) * using platform: x86_64-w64-mingw32 * R was compiled by gcc.exe (GCC) 14.2.0 GNU Fortran (GCC) 14.2.0 * running under: Windows Server 2022 x64 (build 20348) * using session charset: UTF-8 * checking for file 'ResultModelManager/DESCRIPTION' ... OK * this is package 'ResultModelManager' version '0.6.0' * package encoding: UTF-8 * checking CRAN incoming feasibility ... NOTE Maintainer: 'Jamie Gilbert ' Found the following (possibly) invalid URLs: URL: https://ohdsi.org (moved to https://www.ohdsi.org/) From: DESCRIPTION man/ResultModelManager-package.Rd README.md Status: 301 Message: Moved Permanently For content that is 'Moved Permanently', please change http to https, add trailing slashes, or replace the old by the new URL. * 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 'ResultModelManager' can be installed ... OK * checking installed package size ... OK * checking package directory ... OK * checking for future file timestamps ... OK * checking 'build' directory ... OK * checking DESCRIPTION meta-information ... OK * checking top-level files ... NOTE Non-standard file/directory found at top level: 'sql' * 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 ... 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 whether startup messages can be suppressed ... 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 ... OK * 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 sizes of PDF files under 'inst/doc' ... OK * checking installed files from 'inst/doc' ... OK * checking files in 'vignettes' ... OK * checking examples ... OK * checking for unstated dependencies in 'tests' ... OK * checking tests ... [20s] ERROR Running 'testthat.R' [20s] Running the tests in 'tests/testthat.R' failed. Complete output: > library(testthat) > library(ResultModelManager) Loading required package: R6 Loading required package: DatabaseConnector > > test_check("ResultModelManager") Connecting using SQLite driver trying URL 'https://jdbc.postgresql.org/download/postgresql-42.7.3.jar' Content type 'application/java-archive' length 1089312 bytes (1.0 MB) ================================================== downloaded 1.0 MB DatabaseConnector postgresql JDBC driver downloaded to 'D:\temp\2025_09_15_22_55_17_32430\RtmpQ98bOU\filec5585bd356f7'. Connecting using SQLite driver | | | 0% | |=================================== | 50% | |======================================================================| 100% Executing SQL took 0.014 secs Connecting using SQLite driver Closing database connection Connecting using SQLite driver Closing database connection Connecting using SQLite driver Closing database connection | | | 0% | |======================================================================| 100% Executing SQL took 0.00418 secs Connecting using SQLite driver | | | 0% | |=================================== | 50% | |======================================================================| 100% Executing SQL took 0.00518 secs Using DatabaseConnector jdbc driver. Initializing pooled connection Connecting using SQLite driver Initializing pooled connection Connecting using SQLite driver Initializing pooled connection Connecting using SQLite driver | | | 0% | |======================================================================| 100% Executing SQL took 0.00429 secs Migrator using SQL files in ResultModelManager Connecting using SQLite driver Creating migrations table Executing SQL took 0.00547 secs Migrations table created Executing migration: Migration_1-example.sql Executing SQL took 0.00385 secs Saving migration: Migration_1-example.sql Executing SQL took 0.00364 secs Migration complete Migration_1-example.sql Executing migration: Migration_2-MultiPlatformExample.sql Executing SQL took 0.00538 secs Saving migration: Migration_2-MultiPlatformExample.sql Executing SQL took 0.00346 secs Migration complete Migration_2-MultiPlatformExample.sql Closing database connection Connecting using SQLite driver Migrator using SQL files in ResultModelManager Connecting using SQLite driver Closing database connection Migrator using SQL files in directory structure Connecting using SQLite driver Creating migrations table Executing SQL took 0.00364 secs Migrations table created Executing migration: Migration_1-example.sql Executing SQL took 0.00569 secs Saving migration: Migration_1-example.sql Executing SQL took 0.00483 secs Migration complete Migration_1-example.sql Executing migration: Migration_2-MultiPlatformExample.sql Executing SQL took 0.00713 secs Saving migration: Migration_2-MultiPlatformExample.sql Executing SQL took 0.00376 secs Migration complete Migration_2-MultiPlatformExample.sql Closing database connection Connecting using SQLite driver Migrator using SQL files in directory structure Column databaseId in table foo in results folder foo.zip is of type character, but was expecting bigint. Attempting to convert. Column charField in table foo in results folder foo.zip is of type numeric, but was expecting varchar. Attempting to convert. Column dateField in table foo in results folder foo.zip is of type character, but was expecting date. Attempting to convert. Connecting using SQLite driver | | | 0% | |============ | 17% | |======================= | 33% | |=================================== | 50% | |=============================================== | 67% | |========================================================== | 83% | |======================================================================| 100% Executing SQL took 0.00621 secs Inserting data took 0.0153 secs Executing SQL took 0.0035 secs Inserting data took 0.0447 secs Executing SQL took 0.00288 secs Inserting data took 0.00989 secs Executing SQL took 0.00302 secs Using DatabaseConnector jdbc driver. Connecting using SQLite driver Using DatabaseConnector jdbc driver. Initializing pooled connection Connecting using SQLite driver Connecting using SQLite driver Executing SQL took 0.00367 secs Executing SQL took 0.00292 secs Closing database connection null/na primary keys found duplicate primary keys found Connecting using SQLite driver Inserting data took 0.0579 secs Connecting using SQLite driver | | | 0% | |============ | 17% | |======================= | 33% | |=================================== | 50% | |=============================================== | 67% | |========================================================== | 83% | |======================================================================| 100% Executing SQL took 0.0103 secs Connecting using SQLite driver [ FAIL 2 | WARN 0 | SKIP 16 | PASS 135 ] ══ Skipped tests (16) ══════════════════════════════════════════════════════════ • On CRAN (7): 'test-DataMigrationManager.R:70:3', 'test-DataMigrationManager.R:92:3', 'test-PyFunctions.R:2:3', 'test-PyFunctions.R:39:3', 'test-PyFunctions.R:112:3', 'test-PyFunctions.R:167:3', 'test-QueryNamespace.R:63:3' • results db not available (9): 'test-DataModel.R:18:3', 'test-DataModel.R:56:3', 'test-DataModel.R:145:3', 'test-DataModel.R:200:3', 'test-DataModel.R:239:3', 'test-DataModelFunctions.R:93:3', 'test-PooledConnection.R:34:3', 'test-ResultExportManager.R:131:3', 'test-Utils.R:15:3' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Failure ('test-DataModelFunctions.R:230:3'): Delete primary key rows function SQLITE ── `result` (`actual`) not identical to `keptRows` (`expected`). `names(actual)`: "id" "id_2" `names(expected)`: "ID" "ID_2" `actual$id` is a double vector (5, 7) `expected$id` is absent `actual$id_2` is a double vector (6, 8) `expected$id_2` is absent `actual$ID` is absent `expected$ID` is a double vector (5, 7) `actual$ID_2` is absent `expected$ID_2` is a double vector (6, 8) ── Failure ('test-ResultExportManager.R:70:3'): exportDataFrame method exports data frame correctly ── `exportManager$exportDataFrame(df2, "table1", append = TRUE)` did not throw the expected error. [ FAIL 2 | WARN 0 | SKIP 16 | PASS 135 ] Error: Test failures In addition: Warning message: In .subset2(e, "finalize")() : Due to changes in the R6 package, this method is deprecated and will be removed in a future version. Please use closeConnection instead Execution halted Warning messages: 1: In .subset2(e, "finalize")() : Due to changes in the R6 package, this method is deprecated and will be removed in a future version. Please use closeConnection instead 2: In .subset2(e, "finalize")() : Due to changes in the R6 package, this method is deprecated and will be removed in a future version. Please use closeConnection instead 3: In .subset2(e, "finalize")() : Due to changes in the R6 package, this method is deprecated and will be removed in a future version. Please use closeConnection instead * checking for unstated dependencies in vignettes ... OK * checking package vignettes ... OK * checking re-building of vignette outputs ... [52s] OK * checking PDF version of manual ... [13s] OK * checking HTML version of manual ... OK * DONE Status: 1 ERROR, 2 NOTEs