# Bugs
**URL:** https://odm.discourse.group/c/bugs/15.md
[Latest](https://odm.discourse.group/latest.md) · [Categories](https://odm.discourse.group/categories.md) · [Tags](https://odm.discourse.group/tags.md)
---
## [About the Bugs category](https://odm.discourse.group/t/about-the-bugs-category/90)
**Author:** [@dmanuel](https://odm.discourse.group/u/dmanuel)\
**Replies:** 0
Report bugs here. A bug for ODM means something is broken or incorrect. The bugs include problems with the dictionary, such as an incorrect part description or attribute. Bugs also include problems with any ODM applicati…
---
## [Order colmns in table part](https://odm.discourse.group/t/order-colmns-in-table-part/202)
**Author:** [@wastewater\_belgium](https://odm.discourse.group/u/wastewater_belgium)\
**Replies:** 7\
**Last updated:** [September 17, 2026, 6:18pm UTC](https://odm.discourse.group/t/order-colmns-in-table-part/202 "2026-09-17T18:18:25Z")
Hi, There are NA values in columns like addressesOrder in parts table. However these columns are “int” in the ERD. Int cannot store NA value. The same also happens for minValue, maxValue, minLength, maxLength in part t…
---
## [Table sites relationship](https://odm.discourse.group/t/table-sites-relationship/206)
**Author:** [@wastewater\_belgium](https://odm.discourse.group/u/wastewater_belgium)\
**Replies:** 2\
**Last updated:** [August 18, 2026, 1:21pm UTC](https://odm.discourse.group/t/table-sites-relationship/206 "2026-08-18T13:21:47Z")
Hi, Shouldn’t the relation between parSiteID ans siteID be in the opposite direction?
---
## [Country ISO code vs Missingness Indicator](https://odm.discourse.group/t/country-iso-code-vs-missingness-indicator/201)
**Author:** [@matthomson](https://odm.discourse.group/u/matthomson)\
**Replies:** 7\
**Last updated:** [August 15, 2026, 8:43pm UTC](https://odm.discourse.group/t/country-iso-code-vs-missingness-indicator/201 "2026-08-15T20:43:42Z")
So a flag that recently turned up in validation is that “NA” is a categorical missingness values in the parts list, and “NA” is also Namibia’s ISO code in the zones and countries reference tables. This, in theory, shou…
---
## [Discrepancies of variable name between dictionnary and ERD](https://odm.discourse.group/t/discrepancies-of-variable-name-between-dictionnary-and-erd/203)
**Author:** [@wastewater\_belgium](https://odm.discourse.group/u/wastewater_belgium)\
**Replies:** 3\
**Last updated:** [August 10, 2026, 5:19pm UTC](https://odm.discourse.group/t/discrepancies-of-variable-name-between-dictionnary-and-erd/203 "2026-08-10T17:19:59Z")
Hi, In the dictionary (sheet parts) the second variable is partLabel while it is label in the ERD (table parts and translations). aggregationScales in ERD vs aggregationScale in dictionnary dataTypes in ERD vs dataTyp…
---
## [Minor issue in dictionnary file](https://odm.discourse.group/t/minor-issue-in-dictionnary-file/204)
**Author:** [@wastewater\_belgium](https://odm.discourse.group/u/wastewater_belgium)\
**Replies:** 1\
**Last updated:** [August 10, 2026, 4:38pm UTC](https://odm.discourse.group/t/minor-issue-in-dictionnary-file/204 "2026-08-10T16:38:30Z")
Hi, I see in the dictionnary (sheet countries) file that numCode for Belgium is 56 while strictly speaking it should be 056. The same applies for countries with one or 2 digits. geoWKT minLength and maxlength should be…
---
## [pipelineID primary key x foreign key issues](https://odm.discourse.group/t/pipelineid-primary-key-x-foreign-key-issues/200)
**Author:** [@matthomson](https://odm.discourse.group/u/matthomson)\
**Replies:** 1\
**Last updated:** [August 10, 2026, 4:14pm UTC](https://odm.discourse.group/t/pipelineid-primary-key-x-foreign-key-issues/200 "2026-08-10T16:14:03Z")
In reviewing the SQL schemas for version 3, it came to my attention that we have an issue with the structure of the table in terms of keys, because pipelineID is set as a primary key, but within the calculations table is…
---
## [Table sets impossible foreign key for setID](https://odm.discourse.group/t/table-sets-impossible-foreign-key-for-setid/198)
**Author:** [@wastewater\_belgium](https://odm.discourse.group/u/wastewater_belgium)\
**Replies:** 4\
**Last updated:** [July 27, 2026, 8:39pm UTC](https://odm.discourse.group/t/table-sets-impossible-foreign-key-for-setid/198 "2026-07-27T20:39:05Z")
Hi, According to my colleague which takes care of our databases there is an issue in the ERD (v3.0.0) concerning the relation between setID in sets table with specimenSet, compartmentSet, mmSet, unitSet, aggregationSet,…
---
## [ERD variable type error](https://odm.discourse.group/t/erd-variable-type-error/199)
**Author:** [@wastewater\_belgium](https://odm.discourse.group/u/wastewater_belgium)\
**Replies:** 1\
**Last updated:** [July 27, 2026, 4:15pm UTC](https://odm.discourse.group/t/erd-variable-type-error/199 "2026-07-27T16:15:37Z")
Hi, Variables firstReleased and lastRealeased should be varchar in tables translations, languages, sets and parts based on dictionnary excel file content.
---
## [ERD v3.0.0 possible issues](https://odm.discourse.group/t/erd-v3-0-0-possible-issues/197)
**Author:** [@wastewater\_belgium](https://odm.discourse.group/u/wastewater_belgium)\
**Replies:** 1\
**Last updated:** [July 7, 2026, 4:19pm UTC](https://odm.discourse.group/t/erd-v3-0-0-possible-issues/197 "2026-07-07T16:19:59Z")
Hello, I identified three possible issues while reviewing version 3.0.0 of the ERD : organisationID should be FK in sample purposeID should be purpose in sample table firstRelased should be firstReleased in languages …
---
## [Clarifying alias-using foreign keys](https://odm.discourse.group/t/clarifying-alias-using-foreign-keys/194)
**Author:** [@matthomson](https://odm.discourse.group/u/matthomson)\
**Replies:** 0\
**Last updated:** [June 10, 2026, 9:26pm UTC](https://odm.discourse.group/t/clarifying-alias-using-foreign-keys/194 "2026-06-10T21:26:44Z")
In a conversation with @martinwellman, who is developing out the LinkML schema (essentially a flattened YAML version) for the ODM, we realized we don’t make it very machine readable and actionable to see which primary ke…
---
## [Groups missing in the documentation](https://odm.discourse.group/t/groups-missing-in-the-documentation/166)
**Author:** [@wastewater\_belgium](https://odm.discourse.group/u/wastewater_belgium)\
**Replies:** 1\
**Last updated:** [September 19, 2024, 7:28pm UTC](https://odm.discourse.group/t/groups-missing-in-the-documentation/166 "2024-09-19T19:28:24Z")
Hello, I noticed that most of the groups are missing from the documentation (Public Health Environmental Surveillance Open Data Model (PHES-ODM) Documentation - Sets) compared to the dictionary. The same happens for mea…
---
## [Specimen in measures table](https://odm.discourse.group/t/specimen-in-measures-table/163)
**Author:** [@wastewater\_belgium](https://odm.discourse.group/u/wastewater_belgium)\
**Replies:** 1\
**Last updated:** [September 19, 2024, 4:31pm UTC](https://odm.discourse.group/t/specimen-in-measures-table/163 "2024-09-19T16:31:36Z")
Hi, I think there is a mistake in table measures in the ERD. Attribute specimenID is referenced in the ERD while it should be specimen. Thanks
---
## [orgSectorSet option](https://odm.discourse.group/t/orgsectorset-option/160)
**Author:** [@wastewater\_belgium](https://odm.discourse.group/u/wastewater_belgium)\
**Replies:** 5\
**Last updated:** [July 24, 2024, 9:41pm UTC](https://odm.discourse.group/t/orgsectorset-option/160 "2024-07-24T21:41:41Z")
Hello, I noticed the list of the set is not complete in the dictionary compared to the documentation. Besides I think some options should be added for wastewater treatment agency, wastewater treatment plant operator, pu…
---
## [Cycles in the code generated by Lucid](https://odm.discourse.group/t/cycles-in-the-code-generated-by-lucid/135)
**Author:** [@Sorin](https://odm.discourse.group/u/Sorin)\
**Replies:** 5\
**Last updated:** [October 5, 2023, 9:36pm UTC](https://odm.discourse.group/t/cycles-in-the-code-generated-by-lucid/135 "2023-10-05T21:36:10Z")
the sets.setID - parts.partID relationship is the one that generated cycles in the model, so I deleted it. There is actually no need for it. I set the sets.setID, translations.lang, sampleRelationships.sampleRelID colum…
---
## [partID severity](https://odm.discourse.group/t/partid-severity/124)
**Author:** [@wastewater\_belgium](https://odm.discourse.group/u/wastewater_belgium)\
**Replies:** 1\
**Last updated:** [May 10, 2023, 9:53pm UTC](https://odm.discourse.group/t/partid-severity/124 "2023-05-10T21:53:58Z")
Hi, I think there is a type issue with partID severity (table qualityreports) in the lucidchart diagram (v2.0 and 2.1). Data type is int while it should be varchar. Thank you.
---
## [Datetime format](https://odm.discourse.group/t/datetime-format/114)
**Author:** [@wastewater\_belgium](https://odm.discourse.group/u/wastewater_belgium)\
**Replies:** 2\
**Last updated:** [May 7, 2023, 10:57pm UTC](https://odm.discourse.group/t/datetime-format/114 "2023-05-07T22:57:12Z")
I have two remarks about datetime: In the documentation, in sample template description: Columns O to S, U: These are Date fields that are related to various dates associated with your Sample. These dates will be in …
---
## [Pooled partID type](https://odm.discourse.group/t/pooled-partid-type/116)
**Author:** [@wastewater\_belgium](https://odm.discourse.group/u/wastewater_belgium)\
**Replies:** 1\
**Last updated:** [April 24, 2023, 5:01pm UTC](https://odm.discourse.group/t/pooled-partid-type/116 "2023-04-24T17:01:45Z")
if you use true false as boolean should not be pooled a varchar variable like reportable? Currently it is bool in lucidchart
---
## [langID varchar instead of int](https://odm.discourse.group/t/langid-varchar-instead-of-int/109)
**Author:** [@wastewater\_belgium](https://odm.discourse.group/u/wastewater_belgium)\
**Replies:** 1\
**Last updated:** [March 1, 2023, 1:58am UTC](https://odm.discourse.group/t/langid-varchar-instead-of-int/109 "2023-03-01T01:58:02Z")
langID type from table datasets and languages is int instead of varchar in the lucidchart map.