[CYPRESS-492] NumberFormatException in lab result value Created: 12/19/14  Updated: 05/06/18  Resolved: 01/23/15

Status: Closed
Project: CYPRESS Issue Tracker
Component/s: None

Type: Question Priority: Minor
Reporter: John G. Kroubalkian Assignee: Jean Colbert (Inactive)
Resolution: Delivered Votes: 0
Labels: None

Attachments: XML File 0_Cecil_Castillo.xml     XML File 0_Sherry_Carlson.xml     XML File 30_Gordon_Smith.xml     XML File 3_Joseph_Wallace.xml     XML File 3_Tommy_Payne.xml    
Previous Issue Type: Logic affecting more than 1 eCQM

 Description   

Unable to ingest a Category 1 file (0_Sherry_Carlson.xml) which was produced by Cypress 2.5.1 (using Meaningful Use Stage 2 Quality Bundle - 2.5.0) - due to a number format exception caused by a rogue space character in a value element appended to the value attribute:

<value xsi:type="PQ" value="150 " unit="cells/ml"/>

NOTE: there is a space character trailing the 150 in the prior line.

Suggestion: make sure that all numeric data elements output from Cypress are first trimmed (to remove leading and trailing spaces)

The data was produced by selecting all tests for EP and downloading the Cat 1 xml files.

 Comments   
Comment by John G. Kroubalkian [ 06/23/15 ]

and here (3_Joseph_Wallace.xml):

<value xsi:type="PQ" value="150 " unit="mmHg"/>

in

<entry>
<!-- Physical Exam Finding -->
<observation classCode="OBS" moodCode="EVN">
<!-- Result observation template -->
<templateId root="2.16.840.1.113883.10.20.22.4.2"/>
<!-- Physical Exam, Finding template -->
<templateId root="2.16.840.1.113883.10.20.24.3.57"/>
<id root="1.3.6.1.4.1.115" extension="55898066637970062c5e0000"/>
<code code="8480-6" codeSystem="2.16.840.1.113883.6.1" sdtc:valueSet="2.16.840.1.113883.3.526.3.1032"><originalText>Physical Exam, Finding: Systolic Blood Pressure</originalText></code>
<text>Physical Exam, Finding: Systolic Blood Pressure</text>
<statusCode code="completed"/>

<effectiveTime>
<low value='20130301170500'/>
<high value='20130301170500'/>
</effectiveTime>
<value xsi:type="PQ" value="150 " unit="mmHg"/>

</observation>
</entry>

Comment by John G. Kroubalkian [ 06/23/15 ]

<value xsi:type="PQ" value="150 " unit="mmHg"/>

in

<observation classCode="OBS" moodCode="EVN">
<!-- Result observation template -->
<templateId root="2.16.840.1.113883.10.20.22.4.2"/>
<!-- Physical Exam, Finding template -->
<templateId root="2.16.840.1.113883.10.20.24.3.57"/>
<id root="1.3.6.1.4.1.115" extension="55898066637970062cc30000"/>
<code code="8480-6" codeSystem="2.16.840.1.113883.6.1" sdtc:valueSet="2.16.840.1.113883.3.526.3.1032"><originalText>Physical Exam, Finding: Systolic Blood Pressure</originalText></code>
<text>Physical Exam, Finding: Systolic Blood Pressure</text>
<statusCode code="completed"/>

<effectiveTime>
<low value='20130308021104'/>
<high value='20130308021104'/>
</effectiveTime>
<value xsi:type="PQ" value="150 " unit="mmHg"/>

</observation>

Comment by John G. Kroubalkian [ 06/23/15 ]

Here is another (0_Cecil_Castillo.xml on CMS65 v4):

<value xsi:type="PQ" value="150 " unit="mmHg"/>

Notice the trailing space after 150.

Comment by David Czulada [ 01/26/15 ]

John-

Thanks for pointing out this issue (once again). We did not catch these trailing spaces on “Heart Adult B” and “Newborn B” when authoring the 2.6.0 bundle. Unfortunately, until these patients are fixed, this will require post processing after you receive the Cat I files from Cypress. There are various ways to accommodate this in your system (Depending on the language you are using). For instance, in Java and C# you could use the string “trim” method to remove the trailing spaces (and then convert the string into an integer). Post processing of these Cat I files will allow you to work around this particular issue, as well as, make your system more resilient when importing Cat I files from other sources.

-Dave Czulada

Comment by John G. Kroubalkian [ 01/26/15 ]

Incidentally, we are using Cypress Version: 2.6.0

Bundle Version:Meaningful Use Stage 2 Quality Bundle - 2.6.0

Comment by John G. Kroubalkian [ 01/26/15 ]

Here is another entry in the 30_Gordon_Smith.xml:

<value xsi:type="PQ" value="60 " unit="mmHg"/>

Comment by John G. Kroubalkian [ 01/26/15 ]

We have installed Cypress 2.6 and still getting the rogue trailing space in the value field:

<value xsi:type="PQ" value="150 " unit="mmHg"/>

In the above there is a space to the right of the 150 before the double quotation mark.

Comment by David Czulada [ 01/23/15 ]

This has been addressed with Cypress 2.6

Comment by David Czulada [ 01/05/15 ]

John

Thanks again. We will be making sure that these trailing spaces don't occur in any of the patients/

-Dave Czulada

Comment by John G. Kroubalkian [ 01/04/15 ]

This from CMS165v3/0018 has blood pressure measures in invalid form:

<value xsi:type="PQ" value="60 " unit="mmHg"/>

and

<value xsi:type="PQ" value="150 " unit="mmHg"/>

Looking closely you will see a trailing space in the value attribute. This will break/invalidate/IllegalValueException on some xml parsers/validators including mdht.

Comment by David Czulada [ 12/19/14 ]

John

Thanks for pointing this out. We hope to be able to provide this fix with the next release.

-Dave

Generated at Fri Apr 26 14:52:53 EDT 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.