Skip to main content
Older versions of Internet Explorer will not support certain site features. Chrome, Safari, Firefox, and Edge will provide the best experience.
Spok

Common HL7 Feed Errors And How to Correct Them

Overview

The HL7 interface allows for transfer of patient information into the Smart Center database.  This information is never changed as it is entered into the Smart Center database.  Smart Center displays the information exactly as it's received.  If information is missing or incorrectly formatted, it is generally not a problem with Smart Center, but instead with the data that is being sent over.

There are two errors with the HL7 feed that are seen most often:

1) ORACLE ERROR 1400 (ORA-1400) - This is an attempt to enter a NULL value into a database field that does not allow a NULL value.  There are only two fields that meet this criteria, PATIENT_ID, and VISIT_SUFFIX.   Anytime error 1400 is generated, one of these two fields will be blank.  The customer's interface team will need to correct the data that is being sent.

2) ORACLE ERROR 12899 (ORA-12899) - This error indicates that one of the data fields being sent over from the customer's system exceeds the max size of the database field.  This is most commonly seen in the Patient Name field (maximum of 48 characters). 

example:

ORA-12899 - Spok

 

 

Resolution/Topic

Inform the customer of which field is being sent that is incorrect and request that their interface team correct the data.  It is important to remember that patient data never comes from Smart Center.  We have nothing to do with entering the data itself, we merely take what we are given and display it within Smart Suite.

Related Defects:

N/A

 


KB36246