Issue when running CohortDiagnostics

[siirsu]

Describe the bug
When I try to run the cohort diagnostics script, I face an error when creating the merged results .sqlite file.

To Reproduce
Steps to reproduce the behavior:

1. Go to ExploreDiagnostics.R
2. Enter database name and define path to data folder.
3. When trying to run L36 with createMergedResultsFile(), the console indicates

Connecting using SQLite driver

but then I see the error copied here:

Error in vroom_(file, delim = delim %||% col_types$delim, col_names = col_names,  :                                                                      
  bad value

5. There is a generated .sqlite file in 'scratchDiagnostics' folder which is empty with 0B.

Expected behavior
It is expected that the merge argument would result in sqlite file to be produced to be able to run launchDiagnosticsExplorer.

Screenshots

Environment

• MacOS (M1) Ventura 13.6
• RStudio Version 2023.12.0
• renv is not used and the CohortDiagnostics package is v3.2.4, DatabaseConnector is v6.2.3

Additional context
This problem was reproduced in two additional scenarios:

1. When the CD zip files from different data sources are stored together in a single file.
2. When I remove the CohortDiagnostics package to reinstall the v3.2.2, I still get the same error.

[ZorzArg]

@siirsu,

The issue is due to running the function above in a Mac environment as mentioned here and here.

What version of the vroom package do you have installed?

If it is v1.6.4, run this function remotes::install_github("tidyverse/vroom", ref = "v1.6.3") and try running CohortDiagnostics::createMergedResultsFile again.