Unexpected SMATDB behavior

[Jeff Dinsmore]

Has anyone seen unpredictable results displaying messages from SMATDB?

I have a test interface that’s storing ADT in one DB and corresponding ACKs in another.

When I display all messages (in time saved order) with both DBs selected, I expect to see each message displayed followed by its corresponding ACK.

But – sometimes – I’ll see several hundred messages listed with no corresponding ACKs.  Those several hundred messages might span 10-15 minutes.

I’m certain that I’m sending ACKs for each received ADT message, so this behavior is confusing and concerning at the same time.

We’re currently running 19.1 on RHEL.

Jeff Dinsmore
Chesapeake Regional Healthcare

Topic

[Peter Heggie]

I’ve never seen or heard of this. Do you have Use Recovery Database enabled?

Peter Heggie

[Jeff Dinsmore]

Yes.

Jeff Dinsmore
Chesapeake Regional Healthcare

[Rob Lindsey]

I have not seen this before.

I assume you are using the SMATDB IDE/GUI tool.

I have my own tool that I wrote to do that type of thing.

Rob

[Jeff Dinsmore]

Me too, but I’m trying establish whether or not SQLite SMATDBs are kept up-to-date – and whether it’s a viable tool for storing SMAT.

If it’s just a delay in the display of data, that’s one thing, but if it’s actually not storing messages in SMATDB real-time, that’s another thing entirely.

There’s certainly value to being able to query across multiple SMAT DBs directly in the GUI.  If it can be done effectively without writing any code, that would be a good thing.

In the past, using SMAT files, we had no choice but to write code to search through multiple files.

We have a substantial amount of automation that does direct SMAT file lookup, so I want to be sure SMATDB is solid before I invest the time to convert our SMAT file code to handle SMATDB.

 

Jeff Dinsmore
Chesapeake Regional Healthcare

[Rob Lindsey]

Jeff,

We have found that SMATDB is a useful way to store data for inbound and outbound saves on threads. There are WAL and SHM files that might have the data but doing a SMATDB search via the IDE/GUI should pull that information in.  I have not found where the data messages are missing.  The hardest part is matching messages when outside of the IDE/GUI.  It is faster and smaller footprint than the IDX files.  I have not found in the IDE/GUI where it does not put them into the proper order when I sort them by time when I do it.  I usually use our tools though.

Rob

[Author]

Replies