We have an instance of ATLAS and get an error when generating a cohort (this is using SYNPUF5). Interestingly, or oddly, the table in the error message is pointing to the RESULTS schema when I was expecting it to point to the OHDSI schema, where the COHORT_INCLUSION table exists (but does not get populated). Obviously we have some wires crossed.
PreparedStatementCallback; bad SQL grammar [DELETE FROM RESULTS.cohort_inclusion WHERE cohort_definition_id = ?;];
nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
Any hints on how to debug this? Thanks, Jeff