All, We have noticed that sometimes after our monthly i2b2 refresh past user queries don't run anymore - instead, the webclient displays "ERROR: ERROR". Sometimes (but not always) this error message is because concepts that used to be in the concept dimension are now missing. At KUMC, our monthly refresh can change parts of the concept hierarchy from month to month.
During the Hackathon, Eric Larose showed me that you can see which concepts were missing in a particular query by looking in the QT tables - see below (I verified with him that it's ok to forward to GPC-dev). Thanks Eric! -- Nathan From: Larose, Eric R [mailto:larose.e...@mcrf.mfldclin.edu] Sent: Wednesday, January 18, 2017 8:26 AM To: Nathan Graham Subject: Missing concept codes in QT tables Importance: High Let me know if this isn't what you were talking about last night. This is what I ran into when I restructured some of our ontology paths. SELECT TOP 1000 [RESULT_INSTANCE_ID] ,[QUERY_INSTANCE_ID] ,[RESULT_TYPE_ID] ,[SET_SIZE] ,[START_DATE] ,[END_DATE] ,[STATUS_TYPE_ID] ,[delete_flag] ,[message] -- Contains Text when concept is missing from the ontology ,[description] ,[REAL_SET_SIZE] ,[OBFUSC_METHOD] FROM [vdw_i2b2data_2].[dbo].[QT_QUERY_RESULT_INSTANCE] WHERE DATALENGTH(message) <> 0 -- This is a text datatype and not varchar so I can't just compare to <> '' EXAMPLE VALUE: Missing Concept in Ontology Cell : [\\i2b2\i2b2\LP29693-6\LP29697-7\LP71800-4\54050-0\54051-8\24321-2\2160-0\] panel#-1 [\\i2b2\i2b2\Cohort\Phenotype\T2 Diabetes\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A12973319\A8340125\A8358103\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A12973319\A8341296\443.9\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\430\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\431\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345436\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345439\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\60-69\65\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\60-69\66\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\60-69\67\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\60-69\68\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\60-69\69\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\70-79\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\80-89\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\>89\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340910\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340911\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8359116\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340912\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340913\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340914\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340915\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340916\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8343926\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8343927\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8341282\A8352272\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8341282\A8352270\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8341282\A8358497\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8341283\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\436\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.0\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.1\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.3\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.4\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.5\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.6\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.7\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.8\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.9\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345450\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8360933\A8339687\A8377811\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8360933\A8339687\A8377603\] panel#-1 [\\i2b2\i2b2\Vital Signs\TOBACCO\SMOKING\YES\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\0-9\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\10-19\10\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\10-19\11\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\10-19\12\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\10-19\13\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\10-19\14\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\10-19\15\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\10-19\16\] panel#-1 [\\i2b2\i2b2\Demographics\Age Static\10-19\17\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A8360925\A8352460\578.9\] panel#-1 [\\i2b2\i2b2\Demographics\Vital Status\Deceased\] panel#-1 [\\i2b2\i2b2\3149154\3257551\3257552\1579227\] panel#-1 [\\i2b2\i2b2\3149154\3257551\3257552\1579228\] panel#-1 [\\i2b2\i2b2\3149154\3257551\3257552\3502247\] panel#-1 [\\i2b2\i2b2\3149154\3257551\3257552\3744385\] panel#-1 [\\i2b2\i2b2\3149154\3257551\3257552\5042890\] panel#-1 [\\i2b2\i2b2\3149154\3257551\3257555\3749712\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8339819\A8345671\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8339819\A8345677\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8339819\A8345683\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8339819\A8345689\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8352379\A8345696\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8352379\A8345702\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8352379\A8345708\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8352379\A8345714\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.0\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.1\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.2\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.3\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.4\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\A19383974\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.6\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.7\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.9\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8362390\A8345721\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8362390\A8345727\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8362390\A8345733\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8362390\A8345739\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8345746\A8345747\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8345746\A8345753\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8345746\A8345759\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8345746\A8345765\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8341434\530.7\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8359020\A8341316\456.0\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8359020\A8341316\A8345503\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8341434\A8341440\530.82\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A8360926\A8345881\569.3\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A8360925\A8352460\578.0\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A8360925\A8352460\578.9\] panel#-1 [\\i2b2\i2b2\Allergies\Aspirin\] panel#-1 [\\i2b2\i2b2\Visit Details\Other Details\Pregnant\] panel#-1 [\\i2b2\i2b2\3149154\3257551\3257555\2979279\855812\] panel#-1 [\\i2b2\i2b2\3149154\3257551\3257555\2979279\855818\] panel#-1 [\\i2b2\i2b2\3149154\3257551\3257555\2979279\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A18090759\A8362297\A8365778\A8378078\V45.82\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A18090759\A8362297\A8365778\A8378078\V45.81\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352547\A8345341\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92920)\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92921)\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92924)Prq Trluml Coronary Angio/Atherect One Art/Brnch\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92925)Prq Trluml Coronary Angio/Atherec Addl Art/Brnch\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92928)\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92929)\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92933)\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92934)\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92937)\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92938)\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92941)\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92943)\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92944)\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92980)Tcat Plmt Intracoronary Stent Prq 1 Vessel\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92981)Tcat Plmt Intracoronary Stent Prq Ea Vessel\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92982)Prq Trluml Coronary Balloon Angioplasty 1 Vsl\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92984)Prq Trluml Coronary Balloon Angioplasty Ea Vsl\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92995)Prq Trluml Coron Atherect W/Wo Angiop 1 Vessel\] panel#-1 [\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92996)Prq Trluml Coron Atherect W/Wo Angiop Ea Vessel\] panel#-1 [\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9600\] panel#-1 [\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9601\] panel#-1 [\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9602\] panel#-1 [\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9603\] panel#-1 [\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9604\] panel#-1 [\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9605\] panel#-1 [\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9606\] panel#-1 [\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9607\] panel#-1 [\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9608\] panel#-1 [\\i2b2\i2b2\Procedures\CPT\A13475665\A13299386\G0290\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33510)Coronary Artery Bypass 1 Coronary Venous Graft\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33511)Coronary Artery Bypass 2 Coronary Venous Grafts\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33512)Coronary Artery Bypass 3 Coronary Venous Grafts\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33513)Coronary Artery Bypass 4 Coronary Venous Grafts\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33514)Coronary Artery Bypass 5 Coronary Venous Grafts\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33516)Coronary Artery Bypass 6/+ Coronary Venous Graft\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33517)Coronary Artery Byp W Vein & Artery Graft 1 Vei\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33518)Coronary Artery Byp W Vein & Artery Graft 2 Vei\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33519)Coronary Artery Byp W Vein & Artery Graft 3 Vei\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33521)Coronary Artery Byp W Vein & Artery Graft 4 Vei\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33522)Coronary Artery Byp W Vein & Artery Graft 5 Vei\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33523)Coronary Artery Byp W Vein &Artery Graft 6 Vei\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33533)Cabg W/Arterial Graft Single Arterial Graft\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33534)Cabg W/Arterial Graft Two Arterial Grafts\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33535)Cabg W/Arterial Graft Three Arterial Grafts\] panel#-1 [\\i2b2\i2b2\Procedures\Surgery Cardiovascular System (33010-395\(33536)Cabg W/Arterial Graft Four/>Arterial Grafts\] panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352547\412\] panel#-1 [\\i2b2\i2b2\Procedures\PRC\ICD9 (Inpatient)\(35-39) Operations on cardiovascular system\(p36) Operations on vessels of he~\(p36-1) Bypass anastomosis for he~\(p3\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257565\2062801\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257565\2062859\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257565\2062801\308297\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257565\2062859\432638\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257563\1579690\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257565\1579687\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257565\1579689\] panel#-1 [\\i2b2\i2b2\3149154\3257818\3257827\1579692\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257565\1575581\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257563\1579694\] panel#-1 [\\i2b2\i2b2\3149154\3257818\3257827\1939210\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257563\1575907\] panel#-1 [\\i2b2\i2b2\3149154\3257551\3257555\1576856\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257565\1577710\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257565\1575580\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257565\1575906\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257565\6337484\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257565\6346118\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257565\6349829\] panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257565\1575577\] panel#-1 [\\i2b2\i2b2\Visit Details\Encounter Type\AV\] panel#-1 [\\i2b2\i2b2\Visit Details\Encounter Type\IP\] panel#-1 Thanks, Eric LaRose x93591 ________________________________ The contents of this message may contain private, protected and/or privileged information. If you received this message in error, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained within. Please contact the sender and advise of the erroneous delivery by return e-mail or telephone. Thank you for your cooperation. ________________________________ The contents of this message may contain private, protected and/or privileged information. If you received this message in error, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained within. Please contact the sender and advise of the erroneous delivery by return e-mail or telephone. Thank you for your cooperation.
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
