OHDSI Home | Forums | Wiki | Github

***Column `variableField` doesn't exist*** when execute launchDiagnosticsExplorer in Cohort Diagnostics

Hi team,
Error message: Column variableField doesn’t exist occurred when I execute launchDiagnosticsExplorer in Cohort Diagnostics package. Below is error message. Need help.
Thanks!

launchDiagnosticsExplorer(sqliteDbPath = mysqliteDbPath)
Using DatabaseConnector jdbc driver.
Initalizing pooled connection
Connecting using SQLite driver

Listening on http://127.0.0.1:5065
Warning: Error in tidyr::pivot_wider: Can’t subset columns that don’t exist.
:heavy_multiplication_x: Column variableField doesn’t exist.
83:
82: signalCondition
81: signal_abort
80: cnd_signal
79: handlers[[1L]]
78:
77: signalCondition
76: signal_abort
75: abort
74: stop_subscript
73: stop_subscript_oob
72:
71: vctrs::vec_as_location
70: chr_as_locations
69: as_indices_impl
68: as_indices_sel_impl
67: vars_select_eval
63: eval_select_impl
62: tidyselect::eval_select
61: build_wider_spec
60: pivot_wider.data.frame
59: tidyr::pivot_wider
58: dplyr::mutate
57: dplyr::mutate
56: dplyr::mutate
55: dplyr::group_by
54: dplyr::arrange
53: dplyr::mutate
52: dplyr::filter
51: dplyr::select
50: %>%
49: getDatabaseMetadata
48: databaseInformationModule
47: module
42: callModule
41: shiny::moduleServer
40: OhdsiShinyModules::cohortDiagnosticsServer
39: server [C:\Users\g \AppData\Local\R\win-library\4.3\CohortDiagnostics\shiny\DiagnosticsExplorer/server.R#2]
2: shiny::runApp
1: launchDiagnosticsExplorer
Error in tidyr::pivot_wider(., id_cols = c(“startTime”, “databaseId”), :
Can’t subset columns that don’t exist.
:heavy_multiplication_x: Column variableField doesn’t exist.

t