Hi,

regarding: <<I just ran a query with age and an ICD9 code. I got:
             UNMC Prod Spoke "Dem, DX status by site@11:20:34"  - An 
unanticipated problem encountered.>>>


SUMMARY


UNMC is able to process ICD9 queries on the SHRINE Spoke, but ...

currently has a performance issue that causes some queries to time out 
resulting in "unanticipated problem" report.


We are working in performance improvement.


Example -- I ran a age and ICD9 query twice -- failed first and succeeded on 
second try.


DETAILS


I just attempted a Age 45-54 query with ICD9 for Chronic Bronchitis


It failed with "unanticipated error" on the first execution.


A second execution of the query succeeded.


I believe the issue relates to the query execution time.

The first time it did not complete within the timeout period and the second 
time it did.


We are working on improving the performance of the query processing on our

SNOW SHRINE spoke, so that things like this stop happening.



Jay Pedersen, M.A.
Department of Pathology/Microbiology
University of Nebraska Medical Center
985900 Nebraska Medical Center
Omaha NE  68198-5900
402-559-9487<tel:402-559-9593> (office)
402-739-3496<tel:402-350-7851> (mobile)
________________________________
From: GPC Informatics <d...@madmode.com>
Sent: Monday, April 9, 2018 11:30:33 AM
To: Narayana, Yeshwanth R; m...@wisc.edu; dconno...@kumc.edu
Cc: Campbell, James R; McClay, James C; Pedersen, Jay G
Subject: Re: [gpc-informatics] #676: SNOW SHRINE- UNMC production

Non-UNMC email




#676: SNOW SHRINE- UNMC production
--------------------------+----------------------------
 Reporter:  ynarayana     |       Owner:  mish
     Type:  problem       |      Status:  assigned
 Priority:  major         |   Milestone:  snow-shrine-2
Component:  data-sharing  |  Resolution:
 Keywords:                |  Blocked By:
 Blocking:                |
--------------------------+----------------------------
Changes (by dconnolly):

 * cc: campbell, jmcclay, jay.pedersen, mish, yeshwanth.narayana@… (added)


Comment:

 I just ran a query with age and an ICD9 code. I got:

 UNMC Prod Spoke "Dem, DX status by site@11:20:34"
  - An unanticipated problem encountered.

 Is there any news from UNMC on this?

--
Ticket URL: 
<http://informatics.gpcnetwork.org/trac/Project/ticket/676#comment:2>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics

The information in this e-mail may be privileged and confidential, intended 
only for the use of the addressee(s) above. Any unauthorized use or disclosure 
of this information is prohibited. If you have received this e-mail by mistake, 
please delete it and immediately contact the sender.
_______________________________________________
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Reply via email to