Yet Another Quest To Prevent Orphaned Messages

Question 1

Question

#HL7 #Interoperability #Ensemble #InterSystems IRIS for Health

Hey everyone.

As part of an ongoing mission to track down orphaned HL7 Messages in our integration engine, I have been digging into our environment to track down the causes.

Having looked at various posts here (including one of my own) there are a few scenarios that can create orphaned messages resulting in excessive disk space usage. These scenarios are generally:

Purging an environment with the option "Bodies Too" deselected
Code creating/saving a Message but then not sending it
BPL errors similar to 2, or a scenario where the response to a Call component is not set.

These are certainly big contributors, however there are other situations that can occur based on what I have been finding.

Quick History

A message is considered orphaned if the message exists but is missing from Ens.MessageHeader or if it is an ACK and is not referenced within Ens_Util.IOLogObj. The standard purge jobs will delete message bodies based on the Header for standard messages as well as the ACKs when clearing the IOLog.

Therefore, we can list these fairly easily with the following query:

SELECT HL7.ID,HL7.DocType,HL7.Envelope,HL7.Identifier,HL7.MessageTypeCategory,HL7.Name,HL7.OriginalDocId,HL7.ParentId, HL7.TimeCreated
FROM EnsLib_HL7.Message HL7
LEFT JOIN Ens.MessageHeader hdr
ON HL7.Id=hdr.MessageBodyId
LEFT JOIN Ens_Util.IOLogObj ack
ON HL7.Id = ack.InObjectId
WHERE hdr.MessageBodyId IS NULL AND ack.InObjectId IS NULL

Now, having run the above today, I began seeing results for messages created today, which tells me that orphaned messages are being actively generated. Not good!

Taking a look at a few examples, there are additional scenarios to those listed above that are creating these orphaned messages (specifically ACKs).

If an Operation receives an Negative ACK but the Operations Reply Action Codes are configured to process as Completed, this stores the ACK but does not create a Message Header or entry in the IOLog.
If the ACK received from an external system does not match to a schema, then this stores the ACK but does not create a Message Header or entry in the IOLog

The solution to 2 is to correct the schema for the ACK, however the solution to 1 does not seem so straight forward.

Has anyone else come across the scenario of 1 that could offer some insight?

1 new Comment

Discussion (1)2

Log in or sign up to continue

Question 2

Question

Yasir Elecctronics · 11 hr ago

#Other

Finding reliable and affordable home appliances in Pakistan can be challenging, especially with so many brands and models available. Yasir Electronics, a trusted e-commerce store for electronics and home appliances, makes this process simple by offering genuine products, fast delivery, and competitive prices. Whether you’re upgrading your kitchen, improving your home cooling system, or looking for energy-efficient appliances, here is a helpful guide to the best options available in Pakistan.

1. DC Inverter AC in Pakistan

Energy efficiency has become a top priority for every household. A Dc Inverter Ac in Pakistan is now the most popular choice because it consumes less electricity, provides faster cooling, and maintains a stable temperature. Yasir Electronics offers a variety of inverter AC brands that fit different room sizes and budgets. Whether you need a 1-ton or 1.5-ton model, you can find energy-saving options that help reduce electricity bills throughout the summer.

2. Samsung AC Price in Pakistan

Samsung is known for reliability and advanced cooling technology. If you’re looking for a premium option, checking the Samsung Ac Price in Pakistan
can help you find a model that suits your needs. Samsung ACs come with powerful compressors, smart control features, and long-term durability, making them a great investment for modern homes.

3. Fryer Price in Pakistan

Air fryers have become essential for kitchens because they offer healthier cooking with minimal oil. The Fryer Price in Pakistan
varies depending on size, features, and brand. Yasir Electronics provides a range of fryers—from compact models for small families to larger ones with multiple cooking modes. These fryers are perfect for anyone who wants fast, oil-free meals without compromising taste.

4. Samsung Refrigerator

A Samsung Refrigerator is one of the most reliable cooling appliances you can bring home. Known for strong cooling performance, modern design, and advanced features like digital inverter compressors and frost-free technology, Samsung refrigerators ensure long-lasting freshness for your food. They are available in single-door, double-door, and side-by-side options.

5. Samsung Washing Machine

Samsung is also a leader in laundry technology. A Samsung Washing Machine offers powerful washing performance, energy efficiency, and gentle fabric care. With features like eco-bubble technology, quick wash modes, and smart sensors, these machines make laundry faster and more convenient.

6. Samsung Microwave Oven

A Samsung Microwave Oven is perfect for quick cooking, reheating, and defrosting. With multiple built-in cooking programs and even heating, Samsung microwaves provide both convenience and consistency. They are ideal for busy families and modern kitchens.

7. Hitachi Refrigerator Price in Pakistan

If you prefer premium Japanese technology, checking the Hitachi Refrigerator Price in Pakistan can help you find high-end models with advanced cooling systems. Hitachi refrigerators are known for their durability, powerful compressors, and large storage capacity. They are a great choice for families who want long-lasting performance.

Discussion (0)1

Log in or sign up to continue

Find

[Video] Smarter Table Statistics

Atualizações do VS Code - Novembro de 2025