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 |
