[Keith McLeod]

It might be helpful to have a visual of the data and what you are trying to accomplish.

[Keith McLeod]

Not sure the snippet copied. Hate when it obliterates your code…  See Attached

Attachments:

You must be logged in to view attached files.

[Keith McLeod]

You can override the URL or the Path in the userdata.  I do this using tables and a preproc in the Xlate.

I determine my key based on a value in my HL7 data to get which URL I am going to use.  I store it in @URL.

I send the path straight from the field, like PID:3.1

And if I require some Authorization for the Header, again I use the source and a table and store it in @SOME_AUTHORIZATION

I copy In my source:

@URL
1(0).0(0).0(0).PID(0).#3(0).[0]
@SOME_AUTHORIZATION

Use this preproc snippet

keylset userData httpRequestInfo.requestURL

/[lindex $xlateInVals 1]] httpRequestHeaders.SOME-AUTHORIZATION

]
xpmmetaset $xlateId USERDATA $userData

and my destination is @null since I am purely formulating the msg metadata USERDATA to override any settings ws-rawclient.

Works pretty well.  Only have to update my table values for the most part with the URL and Authorization Header info.  You can update PATH only, but once you do the URL, PATH is no longer used.

Hope this helps….

[Keith McLeod]

Have you looked in Tables and used the Database Options?

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

[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 1 year, 9 months 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 1 year, 10 months 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 1 year, 10 months ago by Keith McLeod.
• This reply was modified 1 year, 10 months 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 2 years 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.

[Author]

Replies