search

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

OMOP.episode (103.sql) : SQL Error: ORA-00942 table or view does not exist #60

Closed scossin closed 3 years ago

scossin commented 3 years ago

The errors occurs here:

https://github.com/ohdsi-studies/PioneerWatchfulWaiting/blob/ca047952645cd576ab9bd1137bff0a3af3627511/inst/sql/sql_server/103.sql#L565

My sql is translated like this: 

--adding episode
    UNION all
  select ep.person_id, ep.episode_id, ep.episode_start_datetime, ep.episode_end_datetime,ep.episode_object_concept_id,null
  FROM OMOP.episode ep

The episode table is an OMOP extension: https://ohdsi.github.io/CommonDataModel/oncology.html The SQL code seems to check if the table exists or not: https://github.com/ohdsi-studies/PioneerWatchfulWaiting/blob/ca047952645cd576ab9bd1137bff0a3af3627511/inst/sql/sql_server/103.sql#L563 But for some reason it failed to detect that I don't have this table.

scossin commented 3 years ago

As a temporary fix, I hardcoded episodetable=FALSE in CohortConstruction.R and it worked: https://github.com/scossin/PioneerWatchfulWaiting/commit/9359fb865a3d3da0cf27dda0030fd46454d365d1

keesvanbochove commented 3 years ago

This is fixed with #63.