[Tom Rioux]

I’m not sure why you need the extra links if they are outside of the Cloverleaf root.   They are still visible in the smatDB GUI if they are located outside of the Cloverleaf root.   I think the links inside the process directory are redundant

[Tom Rioux]

Thanks for the info Peter.   It sounds like Infor is going to continue to let its customers be annoyed by an “enhancement” that many don’t want.

I’m being told that if we remove the symbolic link then the processes won’t start.  Can someone at Infor confirm this behavior? 

We too are ignoring them but the fact of the matter is we shouldn’t have to.  Infor needs to come up with a solution.

[Tom Rioux]

You may have await replies set but are you getting ACK’s back.   On that outbound thread, check the “Last Rd” time to see if it closely matches the time of the “Last Wt”.    If there is a significant time gap, the destination may not be returning ACK’s.

[Tom Rioux]

Thanks everyone.   To answer Jim’s question…since this is happening during a pre-xlate in the route, the only time we notice it downstream is when the route is a raw route.   When it hits a translation, it is fine.    To answer Charlie, yes this code is very old and pre-dates my time here.   It isn’t how I would have coded it either.  We will trim it off if needed on those raw routes.

I was just curious about the why the command is acting differently between the two platforms.

Thanks…

[Tom Rioux]

It is in the route as a pre-xlate.

[Tom Rioux]

Jim,

What you have listed is correct.  There is indeed null elements.   The funny thing is, that I can go to hcitcl on each platform and the outcome is exactly the same:  ECC^^    It is only when it is run through the engine that the difference shows up.

 

[Tom Rioux]

Here is the code snippet that sets utilizes the join command:

catch { set PV1_3list [ lreplace $PV1_3list 0 0 $newloc ] }        ;# Update Location
catch { set PV1_3list [ lreplace $PV1_3list 1 1 $newroom ] }    ;#   Room and Bed
catch { set PV1_3list [ join [ lreplace $PV1_3list 2 2 $newbed ] “^” ] }

This code has been in place since before I started working here and has been working like a champ.

Thanks…

Tom Rioux

[Tom Rioux]

Shane,

We have the same issue here.   Every time it re-connects to Interconnect, it throws a “read return error 0” message into our log file.    I’m assuming this is due to the pdl.  

Did you modify your pdl or use a different one?   I was wondering if there is a way to prevent the error from being logged.

Thanks…

Tom Rioux

[Tom Rioux]

Thanks for the reply Bill.  I’ve posted the code below.   I’ve attempted just about everything you have mentioned.   I’ve been working with Max Drown of Infor and Glen Goldsmith of Christus.   They have given me lots of good advice.   I’ve also tried from the command line but still get the encryption error.

Just some insight into my code.

The “SMATCHGdb” will be one of two locations where the smat files are located.   One location is a where the cycled files are archived.  The other is where some “live” smat files are copied to.  

The portion of code in the “else” statement is working correctly.  The one in the “if” statement is the one that isn’t working.  

I’m sure the code in the IF portion needs some tweaking.  I’ve tweaked it over and over and this was my last attempt to get it to work.   Since then I’ve been trying command line to see if my commands are working.

set SMATCHGdb [file join $smatdir $fn ]

sqlite3 DBCMD $SMATCHGdb

DBCMD timeout 5000

set decryptsmatdb $fn

if {[file exists $fn] && [string equal $smatdir $svdir]} {

      DBCMD eval {PRAGMA KEY=’$site’;

      ATTACH DATABASE $decryptsmatdb AS plaintext KEY ‘$site’;

      SELECT sqlcipher_export(“plaintext”);

      DETACH DATABASE $decryptsmatdb | sqlcipher $SMATCHGdb }

} else {

     # DBCMD eval {PRAGMA key=’$site’}

      set chgcnt [DBCMD eval {SELECT COUNT(*) FROM smat_msgs}]

      sqlite3 DBCMD $chgdb

      DBCMD eval {INSERT INTO CHGDATA (thread, count, grp, day) VALUES ($text, $chgcnt, $group, $date); }

}

[Tom Rioux]

With the old file based SMAT, you only had the .idx and the .msg.  Now you have 3 files in the process directory.  A .smatdb, a .smatdb-shm, and a .smatdb-wal.   When you have a process that includes imbedded PDF’s, all 3 of these files can be huge.

I love the new smatbd, don’t get me wrong.   It just takes some adjusting.

[Tom Rioux]

I have to submit a ticket to just get file size limitations?  Shouldn’t that be part of the documentation?

Thanks….

[Tom Rioux]

Greg,

We just upgraded to 6.1.2.   We use cron to cycle the smatdb files.  That option works best for us because we know each file will have messages from basically the same time period.    Cycling on size can produce varied results depending on the amount of data you push through at times.

As for weekly vs daily, with the implementation of the smatdb, we have moved most of our cycling to a weekly schedule.  So far, the only things still have on a daily schedule are those interfaces that handle device data (which pumps out thousands of messages per day) and those interfaces that include an embedded PDF (which are huge messages).

One question I do have for the INFOR staff…is there a size limitation to the smatdb files?  We encountered an issue with one of our weekly files that caused the process to crash.   The engine wasn’t able to write to the smatdb due to the file size.   At that point, cycling the smatdb file was impossible.  We had to move the .smtadb file manually.  Once that was moved out of the process directory,  the -shm and the -wal files returned to normal size.

Also,  when it crashed, I noticed that files were created with a -sec as part of the file extension.  How are those -sec file used?

Thanks…

Tom Rioux

[Tom Rioux]

Has anyone had any luck sending an alert via text through the Alert gui.  I sent one to a Verizion account and an ATT account.   The Verizon text never showed up and the ATT text was about 15 minutes delayed.

I guess it is more of a service provider issue than a Cloverleaf issue.  I’m just wondering if there is any tricks to use to get the service provider not to reject the sending email address.

Thanks…

Tom Rioux

[Tom Rioux]

Hi Kaley,

I would draw up some sort of sign-off document.   I would put in there what changes are being requested and who is doing the requesting.   Then I would get your manager, plus representatives from both the sending and receiving systems to sign off on the change.  I would make sure to note the patient safety concerns.

Without the signoff, I wouldn’t do it.    The signoff ensures you are not fall guy should incorrect information cross the interface.

Thanks…

Tom Rioux

[Tom Rioux]

I could be way off base here but red flags went up when I read what they are asking you to do.   Is there a reason that the source system cannot correct the issue?  

The red flag went off because they are relying on the interface engine to send the correct dose.   The interface engine can translate data but I feel it should never be used to change data.   All it takes is one patient receiving the incorrect dose and the fingers are going to be pointed at the interface engine.

Am I the only one sensing a patient safety issue here or as I stated before “way off base”?

Thanks…

Tom Rioux

[Author]

Replies