Error Cohort 47 when using runStudy function

ohdsi-studies / PioneerWatchfulWaiting

This study is part of the joint PIONEER - EHDEN - OHDSI studyathon in March 2021, and aims to advance understanding of clinical management and outcomes of watchful waiting in prostate cancer.

Apache License 2.0

7 stars 18 forks source link

Error Cohort 47 when using runStudy function #25

Closed rfherrerac closed 3 years ago

rfherrerac commented 3 years ago

errorReportSQL:

DBMS: redshift

Error: java.sql.SQLException: Amazon Invalid operation: syntax error at or near "@" Position: 13;

SQL: delete from @results_database_schema.cohort_inclusion_result where cohort_definition_id = 47 and mode_id = 0

R version: R version 4.0.3 (2020-10-10)

Platform: x86_64-pc-linux-gnu

Attached base packages:

stats
graphics
grDevices
utils
datasets
methods
base

Other attached packages:

PioneerWatchfulWaiting (0.3.2)
DatabaseConnector (4.0.0)

rfherrerac commented 3 years ago

Is it related to #23?

MaximMoinat commented 3 years ago

@rfherrerac Yes, that is indeed the same issue. I have to check with @Tsemharb to see how we can best fix this. Please use release 0.3.2 to be able to run the study.

keesvanbochove commented 3 years ago

@rfherrerac is this with released version 0.3.2 or with the master branch?

keesvanbochove commented 3 years ago

Closed by reverting latest commits to v0.3.2