Jim Van S.,
I know you are out of the office today, but do you have any comment on it?
-TM
On 4/7/2015 8:40 AM, GPC Informatics wrote:
#262: Q1 2015 QA at KUMC
-----------------------+----------------------------
Reporter: dconnolly | Owner: ngraham
Type: task | Status: new
Priority: major | Milestone: data-quality3
Component: kumc-site | Resolution:
Keywords: | Blocked By: 159, 238
Blocking: 232 |
-----------------------+----------------------------
Comment (by ngraham):
I attempted to run the rest of the queries (UTHSCSA branch, as noted in
comment:3) against production data. I'm using SQLDeveloper at the moment
and strangly the "obesity_enc_type" query always causes SQLDeveloper to
report "No more data to read from socket" error:
{{{
Error starting at line : 526 in command -
INSERT INTO Q1_2015_QA_RESULTS
with ptypes as (
select b.encounter_num,
...
union all select 'obesity_enc_type_per_UM', 100 - trunc(known.encs/(select
count from encs)*100, 2) result from known, unknown
Error at Command Line : 526 Column : 1
Error report -
SQL Error: No more data to read from socket
}}}
[https://botbot.me/freenode/gpc-dev/2015-04-06/?msg=35969900&page=1 It
took between 2 and 3 hours to run through the "Active Patients" section
(line 210 of 1213)]. I'm attempting to run the the rest of the queries
skipping the troublesome "obesity_enc_type" query for now.
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/262#comment:4>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
