[Keith McLeod]

Can you share the link to get the downloads?  I found the release notes I think, just not the actual software.

[Keith McLeod]

I ran into an issue with the dblookup on the 2022.09.02 version.  The recommendation on mine was to upgrade the SQL server DB.  2014 I believe is marginal on what the current JDBC drivers support.  I have one system for pathology that has put off upgrading their version of SQL from 2008 R2. Luckily, they are upgrading that over the next several weeks. The current versions of SQL for other apps seems to work fine…  Something you might want to check…

• This reply was modified 7 months, 3 weeks ago by Keith McLeod.

[Keith McLeod]

I believe the error log is a sqlite db exec/databases/elog.elogdb.

[hci@dc1vtclover01 data]$ sqlite3 elog.elogdb
SQLCipher version 3.15.2 2016-11-28 19:13:37
Enter “.help” for instructions
Enter SQL statements terminated with a “;”
sqlite> .schema
CREATE TABLE elog_info (“Version” INTEGER, “ECD” VARCHAR);
CREATE TABLE elog_msgs(
“MessageContent” BLOB,
“DataLen” INTEGER,
“DestConn” VARCHAR,
“OrigDestConn” VARCHAR,
“DataFmt” VARCHAR,
“SepChars” VARCHAR,
“DriverCtl” VARCHAR,
“UserData” VARCHAR,
“MidDomain” INTEGER,
“MidHub” INTEGER,
“MidNum” INTEGER,
“SrcMidDomain” INTEGER,
“SrcMidHub” INTEGER,
“SrcMidNum” INTEGER,
“Type” INTEGER,
“SourceConn” VARCHAR,
“OrigSourceConn” VARCHAR,
“Priority” INTEGER,
“Class” INTEGER,
“Flags” INTEGER,
“EdbState” INTEGER,
“GroupMidDomain” INTEGER,
“GroupMidHub” INTEGER,
“GroupMidNum” INTEGER,
“XltThread” VARCHAR,
“OwnerThread” VARCHAR,
“Retries” INTEGER,
“MidsAreNull” INTEGER,
“SkipXlt” INTEGER,
“GroupID” INTEGER,
“TimeIn” INTEGER,
“TimeXlt” INTEGER,
“TimeOut” INTEGER,
“TimeQCur” INTEGER,
“TimeQTot” INTEGER,
“TimeRec” INTEGER,
“ErrorString” VARCHAR,
“RdbState” INTEGER,
primary key (MidNum,MidHub,MidDomain));
sqlite>

Is this what you are looking for? My guess is that you can access in a similar way to SMATDB files and access the metadata.

[Keith McLeod]

Not sure… I tried a post twice yesterday and it appeared to cut out half of what I posted….Tried editting, but once I submitted lines were still missing or appeared to be missing….

[Keith McLeod]

hcitcl>set xlateInVals 20240402120000
20240402120000

hcitcl>regsub — {(\d{8})(\d{4,6})} [lindex $xlateInVals 0] {\1 \2} dt
1

hcitcl>echo $dt
20240402 120000

hcitcl>set xlateOutVals

-format “%m/%d/%Y %H:%M:%S”]]
{04/02/2024 12:00:00}

• This reply was modified 8 months, 3 weeks ago by Keith McLeod.

[Keith McLeod]

Try this:

regsub — {(\d{8})(\d{4,6})} [lindex $xlateInVals 0] {\1 \2} dt

set xlateOutVals

-format “%m/%d/%Y %H:%M:%S”]]

Example:

hcitcl>set xlateInVals 20240402120000
20240402120000
hcitcl>regsub — {(\d{8})(\d{4,6})} [lindex $xlateInVals 0] {\1 \2} dt
1
hcitcl>echo $dt
20240402 120000
set xlateOutVals

-format “%m/%d/%Y %H:%M:%S”]]
{04/02/2024 12:00:00}

Hope this helps…

• This reply was modified 8 months, 3 weeks ago by Keith McLeod.
• This reply was modified 8 months, 3 weeks ago by Keith McLeod.

[Keith McLeod]

I have a new install on Red Hat Enterprise Linux release 8.5 (Ootpa).  I have worked through several issues regarding LD_LIBRARY_PATH by modifying the environment in .profile.local.end for commands such as scp, sftp, rsync and now mail.  I received the following error prior to the modification: mail: symbol lookup error: mail: undefined symbol: SSLv3_client_method, version OPENSSL_1_1_0.

I added to .profile.local.end and this seemed to resolve from the command line.:

function mail {
if [[ -n “$HCIROOT” && -n “$CL_INSTALL_DIR” ]]; then
clinstalldir=$CL_INSTALL_DIR
hcisite=$HCISITE
hciroot=$HCIROOT
setroot -clear
/usr/bin/mail “$@”
export CL_INSTALL_DIR=$clinstalldir
setroot $hciroot $hcisite
else
/usr/bin/mail “$@”
fi
}

This works for using mail at the command line, however inside many of my notification tcl scripts I have code like:

set sm [open “| mail -s \”${client} – [string toupper $HciSite]: [string toupper $thdName] Not showing a Connection for [expr $downtime / 60] minutes.\” -c ie_mail,${systemName}_mail -r $fromAddress $mailAddress” w]
puts $sm $assign_to
puts $sm $priority
puts $sm $contact
puts $sm ${client_id}
puts $sm $description

close $sm

This brings me back to the symbol lookup error.  Any thoughts on this???

 

[Keith McLeod]

Yes it can be used and does not require ming.le.  I have just completed a configuration, however have a few questions outstanding.

1) Is there an administrator exception like there is in LDAP?

2) Does it “autoCreateCertsEnabled=true” like it does using LDAP?

Still experimenting.  Hope to be able to answer soon or hoping someone before me can share their solution.

[Keith McLeod]

Have you tried hcilicstatus?  It gives threads by HCIROOT and right at the end of the Threads listing is:

Currently there are 366 thread(s) running under HCIROOT(/hci/cis19.1/integrator).

Not limited, but it also provides licensing information as well.

• This reply was modified 11 months, 2 weeks ago by Keith McLeod.

[Keith McLeod]

I use the prexlt queue depth and set a threshhold of 4000 msgs where I pause the reply with a HOLD.  I hold until I have processed down to 3000 msgs and then I release the hold of the Replies.  This in effect throttles those psky high volumes of messages allowing down stream processsing to occur.  Normal the prexlt queue is negligent in volume under normal operations.  You can use lower threshholds to suit your purposes.

We were dealing with 500K+ messages at a time when a script was inadvertantly run on the EMR.

Hope this helps.

[Keith McLeod]

Is Cloverleaf 2022.09.02, the latest release?  I saw a reference to 2023.06 being related to 20.1.  I am going to upgrade, would like to be as current as possible.

[Keith McLeod]

I generally pull the threadname form the %A variable on the alert usually via regexp…

[Keith McLeod]

Have you tried the netconfig get commands?

usage: netconfig action args

action args:
———————————-
get connection count
get connection data <connection>
get connection list
get group connections <group>
get group count
get group list
get process connections <process>
get process count
get process data <process>
get process list
get destination data <dest>
get destination list
get version
ingroup <group> <connection>
inprocess <process> <connection>
load ?file?
modified

Example:

set conn_data [netconfig get connection data epic_adt1_out]

keylget conn_data PROTOCOL.HOST host

keylget conn_data PROTOCOL.PORT port

And much more information than you can imagine…. In TCL.  Yes there is no $ in front of conn_data….

Hope this helps

[Keith McLeod]

If you were to run the testing tool using HL7 Test with the variant used in the XLate, how would it display the paths you would like to delete?  Also if you delete a required segment in a group like {OBX [{NTE}]} deleting the OBX and an NTE exists, the outbound variant will enforce the need to have the OBX segment even if it is blank or a stub.  Are there other Segments with your FT1 segment?  The pathcopy is very powerful in that pathcopy @null –> 1 will delete all segments where the path begins with 1.

Can you consider only building the FT1 group based on a condition? Are you only deleting the second instance?

There are several ways to get rid of the FT1 stub, however not sure I would recommend just deleting the FT1 segment if other segments are associated with it.

Hope this helps some….

 

[Keith McLeod]

I believe you can make use of hcismatdb options for resending messages from smatdb.  The 6.1 version I believe only used lowercase site name for the pw.  I beleive this has an option for a different password.  I generally set a raw route from current environment to new environment and let it build similar smatdb’s on both.  For those interfaces that have multiple sources, I will separate out by source  so as to give me a good comparison in order of the source….and in the same order on the output.  Otherwise, different delays can change the output order of the messages.

May have to look through the forum for hcismatdb.

I use pspad for my compares.  Sometimes ultraedit++, or other edit tools with compare capabilities.

I usually save a copy of my NetConfig and then run a script that chnages all of my output threads to file /dev/null with no reply wait or saveOB message.  Of course I skip any type of jump threads and only change those going to external hosts.

In my last upgrade from 6.X to 19.1.1.0, the one thing I came across is that copying fields that might contain an ampersand, 6.X would parse and only copy that prior to the &.

6.X

copy Vitamin A & D would result in Vitamin A

and in 19.1

Would result in Vitamin A & D….

I took it as a fix and confirmed with downstreams.  Some wanted it escaped….\T\

Hope this helps some….

[Author]

Replies