Getting back to ‘creating a thread’… are you intending to use a new, separate thread to insert these values into a table?
I’d like to create a cross-reference table that has rows of msgid, MRN and Visit number, to be used to track all transactions for a patient visit. I’m not interested in looking at message data; I want to have visibility into the ADT, order and results messages going back and forth between the various systems, especially to track down problems of ‘missing messages’. I would use a process like the one above to store a row in such a table. I would store enough data to show ‘where’ a message was – the location would probably be a combination of thread name and destination name (I guess it depends on how a system is configured).
I am new to Cloverleaf, so I’m wondering if the information I can get is useful enough for this effort.
But I’m also concerned about performance and reliability – in the above proc, if there was a way, an API, to send a separate ‘audit’ message to a new thread dedicated to processing these ‘audit’ messages (performing the insert), then it would make the insert process asynchronous from the business process and reduce the performance penalty. And the audit messages would be reliably stored in a queue before being picked up by the new thread proc. And possibly the audit thread could have a long-running connection to the database and just execute an insert for each incoming message; that would reduce the database connection overhead. I see from previous postings that sometimes there are problems with too many database connections.
Is there a way for a proc to send a message directly to another thread, from the application IB Proc to the audit IB proc, without having to go through the application Translation thread? (Maybe this would be an enhancement to the base product or to the Global Monitor product, to provide transaction tracking. It would be a TCL extension that would be called with a table name and keyed list of column names and column values. It would put an ‘audit message’ into a queue of an audit thread).
One more question – to make this audit capability more useful, I’d like to indicate if a transaction / message was delivered successfully. Is there any way to capture this event and record it? According to some training documentation, the RecoveryDbState of 14 means that the outbound message was delivered, but I probably won’t ever see this status in the output of an HCIDBDUMP command (by the way, what does a state of 16 mean?)
Thanks for reading.
.
