search

OHDSI / ClinicalCharacteristics

[under development] table shell approach to OMOP characterization
Apache License 2.0
0 stars 0 forks source link

Error in makeClinChar #16

Closed rfherrerac closed 2 months ago

rfherrerac commented 5 months ago

When doing analysisSettings <- makeClinChar(targetCohortIds = 1:5, dbms = con@dbms, targetCohortNames = executionSettings$databaseName, cdmDatabaseSchema = executionSettings$cdmDatabaseSchema, workDatabaseSchema = executionSettings$workDatabaseSchema, cohortTable = executionSettings$cohortTable)

Got an error

Error in (function (cl, name, valueClass) : assignment of an object of class “NULL” is not valid for @‘tempEmulationSchema’ in an object of class “executionSettings”; is(value, "character") is not TRUE

ClinicalCharacteristics version 0.2.9

alondhe commented 5 months ago

I think currently, the tempEmulationSchema is needed in your executionSettings for this to work. This tempEmulationSchema would be a place to store tables as if they're temp tables -- useful for db platforms that don't support actual temp tables

mdlavallee92 commented 5 months ago

it works on snowflake....i didnt test on redshift where I think this issue is coming from

mdlavallee92 commented 5 months ago

tested on redshift when tempEmulationSchema is NULL should be good. Please give your example another try, let me know if it errors out again.