Unexpected SMATDB behavior

Homepage Clovertech Forums Cloverleaf Unexpected SMATDB behavior

  • Creator
    Topic
  • #121195
    Jeff Dinsmore
    Participant

    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

Viewing 2 reply threads
  • Author
    Replies
    • #121196
      Peter Heggie
      Participant

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

      Peter Heggie

      • #121241
        Jeff Dinsmore
        Participant

        Yes.

        Jeff Dinsmore
        Chesapeake Regional Healthcare

    • #121237
      Rob Lindsey
      Participant

      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

      • #121242
        Jeff Dinsmore
        Participant

        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

    • #121248
      Rob Lindsey
      Participant

      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

Viewing 2 reply threads
  • You must be logged in to reply to this topic.

Forum Statistics

Registered Users
5,129
Forums
28
Topics
9,301
Replies
34,447
Topic Tags
288
Empty Topic Tags
10