· Oct 9, 2023

How to get ORU messages Base64 content without Truncate from IRIS DB

I have run the query and got ORU^R03 message from SQL Editor and reprocessed the message, But pdf not opened and the base64 content looks truncated.

Is there a way to get full content from the message from query? Why the content is not visible in DB that I can see in Message Viewer?

Thank you so much for your time to read this,

Product version: IRIS 2020.1
$ZV: IRIS for Windows (x86-64) 2020.1 (Build 215U) Mon Mar 30 2020 20:14:33 EDT [HealthConnect:2.1.0]
Discussion (2)2
Log in or sign up to continue

If the content of the field that contains the base64-encoded PDF is greater than the maximum string size in IRIS, it will be stored as a stream.

I've written a custom function that will extract the full content of a message containing such a value; it was originally created to support fetching large HL7 messages in HL7 Spy. You can download it here: I've been asked to add it to the OEX repository, but I just haven't gotten around to that yet ...

I'm not sure how the SQL Editor in the management console will handle a query that uses that function, though. It will likely cause some interesting behavior 😉

The specific SQL function in that class is HICG.GetBigMsg(<messagebodyid>).