OHDSI Home | Forums | Wiki | Github

DQD Error: 'DT' must be installed for this functionality

I’m getting the error

Error: ‘DT’ must be installed for this functionality

displayed in the console output. The verboseMode makes no difference. No errors are included in the errors folder or the log file. The results table results.dqdashboard_results does have data in.

This is the console output

$Overview$countPassedConformance
[1] 677
$Overview$countPassedCompleteness
[1] 338
$outputFile
[1] “xxxxx-20210518091347.json”
Error: ‘DT’ must be installed for this functionality.
Error in readBin(3L, raw(0), 32768L) :
can only read from a binary connection
Calls: … parse_and_simplify → parseJSON → parse_con → readBin

And this is the log file
|2021-05-18 09:08:02|[Main thread]|INFO|DataQualityDashboard|executeDqChecks|CDM Tables skipped: COST, SPECIMEN, DOSE_ERA, |
|—|—|—|—|—|—|
|2021-05-18 09:08:03|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: measurePersonCompleteness|
|2021-05-18 09:08:05|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: cdmField|
|2021-05-18 09:08:25|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: isRequired|
|2021-05-18 09:08:33|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: cdmDatatype|
|2021-05-18 09:08:47|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: isPrimaryKey|
|2021-05-18 09:08:49|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: isForeignKey|
|2021-05-18 09:09:03|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: fkDomain|
|2021-05-18 09:09:06|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: fkClass|
|2021-05-18 09:09:06|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: isStandardValidConcept|
|2021-05-18 09:09:11|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: measureValueCompleteness|
|2021-05-18 09:09:35|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: standardConceptRecordCompleteness|
|2021-05-18 09:09:39|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: sourceConceptRecordCompleteness|
|2021-05-18 09:09:40|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: sourceValueCompleteness|
|2021-05-18 09:09:43|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: plausibleValueLow|
|2021-05-18 09:09:48|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: plausibleValueHigh|
|2021-05-18 09:09:52|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: plausibleTemporalAfter|
|2021-05-18 09:09:56|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: plausibleDuringLife|
|2021-05-18 09:09:58|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: plausibleValueLow|
|2021-05-18 09:11:16|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: plausibleValueHigh|
|2021-05-18 09:12:34|[Main thread]|INFO|DataQualityDashboard|FUN|Processing check description: plausibleGender|
|2021-05-18 09:13:48|[Main thread]|INFO|DataQualityDashboard|.summarizeResults|Writing results to file: OutputDQD/xxxx-20210518091347.json|
|2021-05-18 09:13:48|[Main thread]|INFO|DataQualityDashboard|executeDqChecks|Execution Complete|
|2021-05-18 09:13:48|[Main thread]|INFO|DataQualityDashboard|.writeResultsToTable|Writing results to table xxxxxx.results.dqdashboard_results|
|2021-05-18 09:13:50|[Main thread]|INFO|DataQualityDashboard|.writeResultsToTable|Finished writing table|

Any ideas of I’m missing / what “DT” is?

Any pointers very much appreciated

Answering my own question again.

DT is an R interface to the DataTables library (DT: An R interface to the DataTables library)

Adding this script as part of the install fixes this error

install.packages(‘DT’)

But raises another error
Loading required package: shiny
Error in file(fileName, open = “r”) : cannot open the connection
Calls: … eval → eval → …stacktraceon… → readLog → file
Error in readBin(3L, raw(0), 32768L) :
can only read from a binary connection
Calls: … parse_and_simplify → parseJSON → parse_con → readBin

Which was because I’d left the “(OPTIONAL) if you want to write the JSON file to the results table separately” bit of the script in (Getting Started • DataQualityDashboard). I’d not spotted that it needed a file name

t