OHDSI Home | Forums | Wiki | Github

Error seen in DbDiagnostics

I’m seeing the error below running the code shown below.

Full output file and error file are attached:
log_achilles.txt (585.2 KB)
errorReportR.txt (1.5 KB)

Code:

  DbDiagnostics::executeDbProfile (
    connectionDetails = connectionDetails,
    cdmDatabaseSchema = cdmDatabaseSchema,
    resultsDatabaseSchema = resultsDatabaseSchema,
    writeTo = writeTo,
    vocabDatabaseSchema = vocabDatabaseSchema,
    cdmSourceName = cdmSourceName,
    outputFolder = outputFolder,
    cdmVersion = cdmVersion,
    appendAchilles = appendAchilles,
    roundTo = roundTo,
    excludedConcepts = excludedConcepts,
    addDQD = addDQD
  )

Error:

Analysis 2125 (Number of device_exposure records by device_source_concept_id) -- START
  |====================================================================================================================================| 100%
Executing SQL took 3.02 secs
[Main Analysis] [COMPLETE] 2125 (3.020800 secs)
[Main Analysis] [COMPLETE] 2125 (3.020800 secs)
An error report has been created at  D:\_YES_2023-05-28\workspace\SosExamples\_COVID\02-data-diagnostics\output/errorReportR.txt
Error in scan(file = file, what = what, sep = sep, quote = quote, dec = dec,  : 
  line 998 did not have 6 elements

It looks like this was caused by some bad data in the Achilles output tables.

I re-ran Achilles and this problem went away :slight_smile: :slight_smile: :slight_smile:

t