OHDSI Home | Forums | Wiki | Github

Error when running DataQualityDashboard

Hi, I’m Chin-Yao from Taiwan.

I tried to run the DQD for our data in SQL server.
I received so many ERROR records in our log (see below) and the checking are failed due to undefined the denominator and nominator.
Almost all the checks under cdmDatatype are failed but I already constructed our CDM followed the definition of datatype in each table.
log_DqDashboard_NHIRD.dbo.docx (84.7 KB)

Can anyone give me some idea about what I can do further?


2021-10-06 14:01:18 [Main thread] INFO DataQualityDashboard FUN Processing check description: cdmDatatype
2021-10-06 14:01:18 [Main thread] WARN SqlRender can only read in bytes in a non-UTF-8 MBCS locale
2021-10-06 14:01:19 [Main thread] ERROR DataQualityDashboard 3 [Level: FIELD] [Check: cdmDatatype] [CDM Table: PERSON] [CDM Field: PERSON_ID] invalid multibyte string, element 4
2021-10-06 14:01:19 [Main thread] WARN SqlRender can only read in bytes in a non-UTF-8 MBCS locale
2021-10-06 14:01:19 [Main thread] ERROR DataQualityDashboard 3 [Level: FIELD] [Check: cdmDatatype] [CDM Table: PERSON] [CDM Field: GENDER_CONCEPT_ID] invalid multibyte string, element 4
2021-10-06 14:01:19 [Main thread] WARN SqlRender can only read in bytes in a non-UTF-8 MBCS locale
2021-10-06 14:01:19 [Main thread] ERROR DataQualityDashboard 3 [Level: FIELD] [Check: cdmDatatype] [CDM Table: PERSON] [CDM Field: YEAR_OF_BIRTH] invalid multibyte string, element 4
2021-10-06 14:01:19 [Main thread] WARN SqlRender can only read in bytes in a non-UTF-8 MBCS locale
2021-10-06 14:01:19 [Main thread] ERROR DataQualityDashboard 3 [Level: FIELD] [Check: cdmDatatype] [CDM Table: PERSON] [CDM Field: MONTH_OF_BIRTH] invalid multibyte string, element 4
2021-10-06 14:01:19 [Main thread] WARN SqlRender can only read in bytes in a non-UTF-8 MBCS locale
2021-10-06 14:01:19 [Main thread] ERROR DataQualityDashboard 3 [Level: FIELD] [Check: cdmDatatype] [CDM Table: PERSON] [CDM Field: DAY_OF_BIRTH] invalid multibyte string, element 4
2021-10-06 14:01:19 [Main thread] WARN SqlRender can only read in bytes in a non-UTF-8 MBCS locale
2021-10-06 14:01:19 [Main thread] ERROR DataQualityDashboard 3 [Level: FIELD] [Check: cdmDatatype] [CDM Table: PERSON] [CDM Field: RACE_CONCEPT_ID] invalid multibyte string, element 4
2021-10-06 14:01:19 [Main thread] WARN SqlRender can only read in bytes in a non-UTF-8 MBCS locale
2021-10-06 14:01:19 [Main thread] ERROR DataQualityDashboard 3 [Level: FIELD] [Check: cdmDatatype] [CDM Table: PERSON] [CDM Field: ETHNICITY_CONCEPT_ID] invalid multibyte string, element 4
2021-10-06 14:01:19 [Main thread] WARN SqlRender can only read in bytes in a non-UTF-8 MBCS locale
2021-10-06 14:01:19 [Main thread] ERROR DataQualityDashboard 3 [Level: FIELD] [Check: cdmDatatype] [CDM Table: PERSON] [CDM Field: LOCATION_ID] invalid multibyte string, element 4

@Steven_Shen Could you check the data types of these columns? Aren’t their data-type string(or varchar) in the database?

t