[GH-ISSUE #106] riab -dq error #63

New issue

Closed

opened 2026-03-23 20:28:48 +00:00 by mirror · 3 comments

mirror commented

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

Owner

Originally created by @loreV-edenceHealth on GitHub (Oct 10, 2024).
Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/106

Originally assigned to: @pjlammertyn on GitHub.

sqlalchemy.exc.ProgrammingError: (pymssql.exceptions.ProgrammingError) (208, b"Invalid object name '[omop.dbo].[cdm_source'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
[SQL: select * from omop].[dbo.[cdm_source];]

running select * from omop].[dbo.[cdm_source]; gives an error,
replacing it by select * from [omop].[dbo].[cdm_source]; works so I think the extra brackets need to be removed from the code.

Originally created by @loreV-edenceHealth on GitHub (Oct 10, 2024). Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/106 Originally assigned to: @pjlammertyn on GitHub. sqlalchemy.exc.ProgrammingError: (pymssql.exceptions.ProgrammingError) (208, b"Invalid object name '[omop.dbo].[cdm_source'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n") [SQL: select * from [[omop].[dbo]].[cdm_source];] running select * from [[omop].[dbo]].[cdm_source]; gives an error, replacing it by select * from [omop].[dbo].[cdm_source]; works so I think the extra brackets need to be removed from the code.

mirror

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

closed this issue
added the
question
label

mirror commented

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

Author

Owner

@pjlammertyn commented on GitHub (Oct 11, 2024):

Can you give more detail where the error occurs.

@pjlammertyn commented on GitHub (Oct 11, 2024): Can you give more detail where the error occurs.

mirror commented

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

Author

Owner

@pjlammertyn commented on GitHub (Oct 11, 2024):

More info on the square brackets: Delimited identifiers

@pjlammertyn commented on GitHub (Oct 11, 2024): More info on the square brackets: [Delimited identifiers](https://learn.microsoft.com/en-us/sql/relational-databases/databases/database-identifiers?view=sql-server-ver15#classes-of-identifiers)

mirror commented

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

Author

Owner

@loreV-edenceHealth commented on GitHub (Oct 14, 2024):

https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/blob/main/src/riab/etl/sql_server/data_quality.py#L79
I think the problem is that the brackets are around the combination of schema.table which makes it think the dot is part of the table name.

@loreV-edenceHealth commented on GitHub (Oct 14, 2024): https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/blob/main/src/riab/etl/sql_server/data_quality.py#L79 I think the problem is that the brackets are around the combination of schema.table which makes it think the dot is part of the table name.