ARTEMIS getConDF() fails on PostgreSQL with "syntax error at or near numeri"

Developers
1

Hi everyone,

I’m testing the package on PostgreSQL. I’m trying to run the userScript.R, but I run into an error when executing the getConDF()

1/1- Generating cohort: examplecohort (id = 1)
|===================================================================| 100%
Executing SQL took 41.5 secs
Generating cohort set took 41.6 secs
Error caught: org.postgresql.util.PSQLException: ERROR: syntax error at or near “numeri”
Position: 496

Environment

  • Database: PostgreSQL 14
  • R version: 4.5.1

I verified that CohortGenerator works fine in the same environment (using Eunomia CDM → no errors). I think the error appears after generateCohortSet() finishes, during the next step in getConDF()

Has anyone run ARTEMIS successfully on PostgreSQL?

2

@a.licona the error is telling you the you have no patient in your cohort. We have to clarify the wording of the error.
What is your input cohort?

3

@agolozar, thanks for the clarification. I was testing with the loadCohort() example, but my data has mostly breast cancer patients