OHDSI / Atlas

ATLAS is an open source software tool for researchers to conduct scientific analyses on standardized observational data
http://atlas-demo.ohdsi.org/
Apache License 2.0
273 stars 137 forks source link

Invalid Object Source_to_concept_map #2738

Closed nzurawski closed 2 years ago

nzurawski commented 2 years ago

Expected behavior

Actual behavior

Hello, I'm a data engineer with the Maine Health Institute for Research. We have recently installed got Atlas setup here and our analyst is running into an issue with the Concept Sets tab. In the stdout log file for Apache the error appears to be related to a non existent table in our CDM called Source_to_concept_map. Can anyone tell me what this table is supposed to be? Is it user generated? Apologies if this is a dumb question. I'm not intimately familiar with Common Data Model.

Steps to reproduce behavior

Click on Concept Sets, choose 'Hyper Tension' and choose 'Included Source Codes source_to_concept_map_error.txt '

don-torok commented 2 years ago

Check the OMOP CDM table definitions here. The source_to_concept_map table will be empty, which is fine, but looks like it needs to exist.

nzurawski commented 2 years ago

Thanks Don! I guess it's just an unnecessary table that is still referenced in the executed SQL script. Interesting. I created the table from a script in that link and that seems to have solved the issue.