search

eurekaclinical / aiw-i2b2-etl

Protempa i2b2 tools
Apache License 2.0
0 stars 5 forks source link

Failed reading the ontology #43

Closed arpost closed 8 years ago

arpost commented 8 years ago

With a QA (and lower powered) Oracle instance, the following query causes ORA-01652: unable to extend temp segment by 128 in tablespace TEMP:

SELECT A1.C_NAME, A1.VALUETYPE_CD, A1.EK_UNIQUE_ID, A3.EK_UNIQUE_ID, (SELECT EK_UNIQUE_ID FROM NCATS_MEDS WHERE C_FULLNAME = CASE WHEN SUBSTR(A1.M_APPLIED_PATH, LENGTH(A1.M_APPLIED_PATH), 1) = '%' THEN SUBSTR(A1.M_APPLIED_PATH, 1, LENGTH(A1.M_APPLIED_PATH) - 1) ELSE A1.M_APPLIED_PATH END AND C_SYNONYM_CD ='N' AND M_APPLIED_PATH ='@'), A1.C_METADATAXML FROM NCATS_MEDS A3 JOIN EK_TEMP_UNIQUE_IDS A4 ON (A3.EK_UNIQUE_ID=A4.UNIQUE_ID) AND A3.C_SYNONYM_CD  ='N' AND A3.M_APPLIED_PATH='@' JOIN NCATS_MEDS A1 ON (A3.C_FULLNAME LIKE A1.M_APPLIED_PATH AND A1.C_SYNONYM_CD ='N' AND A1.M_APPLIED_PATH<>'@' AND A1.C_BASECODE IS NOT NULL)