[GH-ISSUE #70] SQL Server: Truncation error with multiple mappings to same concept #40

New issue

Closed

opened 2026-03-23 20:28:41 +00:00 by mirror · 0 comments

mirror commented

2026-03-23 20:28:41 +00:00

Owner

Originally created by @Ben-Goethuys on GitHub (Jun 10, 2024).
Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/70

Originally assigned to: @pjlammertyn on GitHub.

Mapping multiple source_values to the same omop concept_id could result in data truncation error in SQL Server.

e.g.:

Mapping multiple measurements to same concept results in error:
"String or binary data would be truncated in table 'FHIN.work.measurement', column 'measurement_source_value'."

The column ('measurement_source_value') in "work-zone" table is filled with "STRING_AGG(t.measurement_source_value, ', ')". Column size of 'measurement_source_value' is limited and aggregating multiple source_values exceeds this limit.

Originally created by @Ben-Goethuys on GitHub (Jun 10, 2024). Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/70 Originally assigned to: @pjlammertyn on GitHub. Mapping multiple source_values to the same omop concept_id could result in data truncation error in SQL Server. e.g.: Mapping multiple measurements to same concept results in error: "String or binary data would be truncated in table 'FHIN.work.measurement', column 'measurement_source_value'." The column ('measurement_source_value') in "work-zone" table is filled with "STRING_AGG(t.measurement_source_value, ', ')". Column size of 'measurement_source_value' is limited and aggregating multiple source_values exceeds this limit.