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

RunStudy Error #91

Open SofiaMp opened 3 years ago

SofiaMp commented 3 years ago

When trying to RunStudy at the 'Bulk characterisation of all cohorts for all time windows' step I get the error:

DBMS:
postgresql

Error:
org.postgresql.util.PSQLException: ERROR: syntax error at or near "SELECT"
  Position: 96

SQL:
CREATE TEMP TABLE cohort_subset

AS
WITH data  AS (

SELECT NA cohort_id
SELECT  cohort_id
          ) 
           SELECT
cohort_id

FROM
data

R version:
R version 4.1.1 (2021-08-10)

Platform:
x86_64-conda-linux-gnu
keesvanbochove commented 3 years ago

This would suggest that there are no target or strata cohorts with more than the minimum subject amount (140 subjects). Obviously, would be better if the package didn't raise and error and produced a more meaningful warning message, but a workaround could be to disable bulk characterization (supply useBulkCharacterization = FALSE as argument to runStudy).

keesvanbochove commented 2 years ago

Perhaps a better workaround will be to adjust the minimum subject count to be lower, for instance 20 subjects?