OHDSI Home | Forums | Wiki | Github

DataQualityDashboard : Errors in executeDqChecks.Ro

General
#1

Hello, guys

We used OMOP-CDM v5.4 and downloaded DataQuality Dashboard(v2.0.0) from the site below to run this program.
(site :
However, when we ran it, there were some errors. We need help to solve this errors.

First, we looked up the log_DqDashboard and saw below the sentence(ERROR1):

  • ERROR1
    Dashboard 3 [Level : CONCEPT] [Check : plausibleGender] [CDM Table : NA] [CDM Field : CONDITION_CONCEPT_ID] ERROR executing SQL : org.postgresql.util.PSQLExecute

Secondly, we saw the error reports(ERROR2) :

  • ERROR2
    org.postgresql.util.PSQLException : error : syntax error, near “@”
    postion;322

Third, our dashboard score seems weird because verification are a few and validation scores are 0.
(I attached the image)

We considered that DataQualityDashboard did not recognize the CDM table name.
Anyone know any workarounds for these errors?

스크린샷 2023-01-05 오후 2.53.41
스크린샷 2023-01-05 오후 2.53.411125×464 52.8 KB

Thanks,
hyojung

#2

Hi there! Could you please share the script you ran to generate the DQD results (redacting anything you feel is sensitive)? This will help me assist you in debugging :slight_smile:

1 Like
#3

I appreciated ur reply:)

We tried to solve the errors and then we found typo error in OMOP_CDMv5.4_Concept_Level.csv.

We edited and ran it again, and then finally we got the results of DataQualityDashboard sucessfully:)

Thanks,
hyojung

1 Like
#4

i want to know how much time when did you run(excutedqhecks)?

#5

Sorry to find your question lately. I’m not sure how long it’s been run…
But you will probably see results in 2 hours or less.

t