If a patient has labs that have a NULL test date these labs were successfully filed when we were running Oscar 12. When we displayed the patients encounter in Oscar 12 we had no problem. Since moving to Oscar 15 we can no longer see any of the lab results for those patients in either the classic or the new interface. In the classic encounter we get ERROR:500 under the labs column and with the new interface we get a blank incoming box.
In Oscar 12 we were originally not able to file these lab results but this was fixed with "“#4044 NPE in Inbox for null obr_date”.
This is happening for about 15% of our patients - the doctor is not able to see any lab results for this set of patients.
It looks like the error is in EctDisplayLabAction2 when it attempts to format the service date.
I have attached a file with a copy of the log.
I am currently running build 467
To reproduce it you need to file a lab result with a NULL date and then display the patient's encounter. If using the Classic encounter you will see ERROR:500 under Labs.
that error in the log has to do with OLIS maybe not being setup properly on the system.
are you able to grab the hl7 from one of the failing files, deidentify, and send to me? I want to check to see if the date is in the hl7 and not being correctly read or if I just need to not try to format the date if it's not found.
thanks
These are not new results being pulled in from OLIS. These are existing lab results that were pulled in more than 1 year ago. Here is what I pulled from hl7TextInfo. I hope this is what you were looking for.
| 43 | 43 | F | 9999999999 | NULL | 2 | NULL | NULL | DR NAME MD 99999 | HIV | LAST| FIRST | F | ORDERID | NULL | NULL | NULL |
the error is from the OLIS code is all I mean.
Can you view the lab in OSCAR, then at the bottommost of the page in the browser, there is a hidden link and when you click it it will produce the lab in HL7 format. Just copy/paste that. The patient info is easy to change as it's human readable.
Marc, I cannot find the hidden link. To view the labs I have to go into INBOX and then SEARCH by patient name and that provides me with this list - see attached file. From the Inbox I can view the lab results by just clicking on the pateint name.
I have a test copy of the database and in there I used mysql to change the obr_date in hl7TextInfo from null to a valid date. As soon as I did that the Lab Results showed in the Classic Encounter - no more ERROR: 500
The new patient Summary now also shows the results under Incoming.
Currently running build 457. Have the same error described by creator of this ticket.
We have a lot fewer though, only about 26 rows out of a total of 395 in our hl7textinfo table with a type of OLIS_HL7.
No clear rhyme or reason for why this is the case. Marc, if you could provide a bit more details of how to extract the HL7 data via the hidden link you described, happy to track down this info and supply it.