It fails to save the patient race into the database with error: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = bytea
The request message is:
MSH|^~\&|EHR_EMDS|EMDS|OpenPIXPDQ|MOSS|20110106163106-0600||ADT^A04^ADT_A01|20110106163106|P|2.3.1|||AL|NE
EVN|A04|20110106163106-0600||||20110106163106-0600
PID|1||FARSTE0001^^EMEH&1.3.6.1.4.1.21367.13.20.5155&ISO||FARNSWORTH^STEVE^^^^L||19781208|M||2106-
3^White^HL70005|820 JORIE BLVD^^CHICAGO^IL^60523^USA^H
PV1|1|O
To replicate the problem, you can use any PIX Feed message. What's important here is just to populate the PID-10 field with a value 2106-3^White^HL70005.
Bug
Closed
Major
Race does not work
I'm not sure about that, but the "White" here wants to be a race information? In the OpenEMPI database schema Race, Gender, Nationality, Language are all strongly typed information (not simple strings). If someone tries to feed some strange data (in my case it was artificially corrupted data) into the database, so for example you have a String race field saying "Whit", the code won't be able to find the corresponding strongly typed instance for that string, and will fail eventually. And this can result in such an exception which does not indicate the error clearly. I wonder if this is the case here.