I’m reaching for some assistance with an issue we’re facing in our OHDSI Atlas setup that’s deployed using Broadsea. Our environment is structured with three PostgreSQL schemas (omop_diseaseArea1 to omop_diseaseArea3), each dedicated to a distinct disease area, and a fourth schema where our vocabulary is stored.
We’re encountering an error when attempting to execute “characterizations” in Atlas. The error message in WebAPI is:
ERROR: relation "omop_diseaseAreaX.concept" does not exist
This suggests that Atlas is trying to access a ‘concept’ table within a schema that doesn’t seem to be correctly specified.
It appears that during the “characterization” process, the system is either misinterpreting the schema names or not properly directing the query to the right schema where the ‘concept’ table resides.
Other features of Atlas, however, are working properly.
Has anyone else encountered a similar issue, or does anyone have suggestions on where else we might look to resolve this?
Thanks in advance for your help!