I’m running ATLAS 2.6.0 and WedAPI 2.6.0 against with SynPUF data in SQL Server 2016 loaded from the backup provided in the quick start.
Cohort generation is failing do to references to column mode_id . Is this a version mismatch? Any suggestions? Here’s a snippet from the logs:
FROM
(select count(event_id) as total from #best_events) PC,
(select sum(sr.person_count) as total
from ohdsi.cohort_inclusion_result sr
CROSS JOIN (select count(*) as total_rules from ohdsi.cohort_inclusion where cohort_definition_id = 1) RuleTotal
where sr.mode_id = 1 and sr.cohort_definition_id = 1 and sr.inclusion_rule_mask = POWER(cast(2 as bigint),RuleTotal.total_rules)-1
) FC
; TRUNCATE TABLE #best_events; DROP TABLE #best_events; TRUNCATE TABLE #cohort_rows; DROP TABLE #cohort_rows; TRUNCATE TABLE #final_cohort; DROP TABLE #final_cohort; TRUNCATE TABLE #inclusion_events; DROP TABLE #inclusion_events; TRUNCATE TABLE #qualified_events; DROP TABLE #qualified_events; TRUNCATE TABLE #included_events; DROP TABLE #included_events; TRUNCATE TABLE #Codesets; DROP TABLE #Codesets]; nested exception is java.sql.BatchUpdateException: Invalid column name ‘mode_id’.
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419)
at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:600)
at org.ohdsi.webapi.cohortdefinition.GenerateCohortTasklet.lambda$doTask$132(GenerateCohortTasklet.java:141)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
… 3 more
Caused by: java.sql.BatchUpdateException: Invalid column name ‘mode_id’.
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeBatch(SQLServerStatement.java:1740)
at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:561)
at org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:548)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)
… 6 more