Problem
Cohort generation returns 0 subjects in the cohort and an error saying that person_count column is missing from table achilles_result_concept_count appears in the WebAPI log.
Solution
The broadsea-atlasdb Docker container needs to be recreated using SQL generated from the WebAPI/ddl/achilles path in Atlas v2.13:
The above latest version of the SQL includes the missing two columns that are required in Atlas v2.13:
person_count
descendant_person_count
Manual Workaround
The generated SQL can be manually converted to the correct DBMS using the https://data.ohdsi.org/SqlDeveloper tool, using the dbms drop down list and entering the values for the results schema name and the vocab schema name (typically the same schema as the cdm schema). The SQL can be manually run in the results schema database, It is also then necessary to grant all on the table to the broadsea user and to analyze the table.
leeevans
commented
2 months ago
Problem Cohort generation returns 0 subjects in the cohort and an error saying that person_count column is missing from table achilles_result_concept_count appears in the WebAPI log.
Solution
The broadsea-atlasdb Docker container needs to be recreated using SQL generated from the WebAPI/ddl/achilles path in Atlas v2.13:
https://atlas-demo.ohdsi.org/WebAPI/ddl/achilles
The above latest version of the SQL includes the missing two columns that are required in Atlas v2.13: person_count descendant_person_count
Manual Workaround
The generated SQL can be manually converted to the correct DBMS using the https://data.ohdsi.org/SqlDeveloper tool, using the dbms drop down list and entering the values for the results schema name and the vocab schema name (typically the same schema as the cdm schema). The SQL can be manually run in the results schema database, It is also then necessary to grant all on the table to the broadsea user and to analyze the table.