[John Mercogliano]

Hi Jim,

The stage db is encrypted by default using the site name but I have successfully poked around.  In 20.1, I found that stageinit and stagegetkeys are not defined.  But if you use stageset it will create the stage database if it does not exist so the commands appear to be available with or with out a dtc connection in the site.  I’ve only found a need to use the DTC tcl api calls in my one project I’ve done so far.  Also, under the root tclprocs directory you will find a dtc.tcl that has the dtc api which are just wrappers for the stageget and set commands.  Once I figured it out, I did like how the dtc protocol worked.

• This reply was modified 1 month, 1 week ago by John Mercogliano.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

Infor does not let you load 3rd party tools in their environment or shell scripting the way it was discussed with us.  So, it’s not that it’s not allowed in the cloud, but not allowed in their instance of cloverleaf that they provide.   So, we stuck with the on prem version for that reason when we moved to azure.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

When you say cloverleaf cloud are you migrating to infor’s cloud version and not just moving your data center to the cloud platform?

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

Chris,

This statement would be a local rule someone is enforcing. We migrated to the azure cloud and have not had any issues using third party tools.  We are not using anything that requires compiling but I know that would not be an issue.  We are on redhat.  Not sure what hl7 package you are using but if it is something you are already using I would push back hard on it.

 

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

Rin,

Nothing looks out of place here.  I would recommend to resync the database schema to make sure nothing has changed.  Then try and create a schema using sql with some of the columns that won’t select using brackets. I’ve never had an issue like this so just reaching at this point.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

No, only for the unix command line tool.  You will still need to do enable load extension to use regexp in tcl.

As far as the rc file, that one line I listed above is the only statement in the file.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

Not that I found.  You have the ability to create a .sqliterc in the users home directory, I added
.load “sqlite3-regex.so”
To the file so its there when I need it from the command line.

• This reply was modified 11 months, 1 week ago by John Mercogliano.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

Hi Rick,

I found I needed to do this command. “db enable_load_extension 1” before calling the load extension. Hope this works for you.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

Excellent glad that worked.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

I would say it’s the dashes.  In sql you need to enclose a column name in brackets when there are special characters so the jdbc and/or the gui are probably having issues.

I’ve never had to do this, but you should be able to create a schema from sql and manually add the fields to the select statement with brackets.

I would tell you dba not to use dashes 😉

 

• This reply was modified 11 months, 2 weeks ago by John Mercogliano.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

Hi Lisa,

Keylget will not create the variable if the key does not exist, so this tells me that there was no response code in the userdata. If I’m understanding you correctly, they are sending two messages for each message you send.  One ack and one data message.  In that case, the data message would not have a response code and you will need to have additional logic to handle that.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

Hi Jim,

I had asked this same question to infor, here is the response I got.
<p style=”margin: 2.25pt 0in 0in 0in;”><b>Event Note: </b>So that warning message is more an FYI message. The entire json does load and function normally. All it means is that the json is too large to auto expand the number of nodes set in the GUI. You can change the default in the GUI -> Client -> Preferences -> Xlate Config tab. The JSON Auto-expansion Level is 5 by default. If you change that to 3 or less, the message will not be displayed.</p>
 

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

That error you are getting is an indication that the vendor has closed the connection before you sent back the reply.  This can be caused by two things possibly that I’m aware of, either you are waiting on the reply from a downstream system and it is taking to long to come back or the reply proc is not copying the driver ctrl from the data message to the reply so it’s not going back on the same port it came in on.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

Tim,
I based my connection off the ws_more_samples box(https://usspvlclovertch2.infor.com/forums/topic/cl-receive-post-api/). I used the path_trxid_server connection as my template. I only had to make cosmetic changes(port, context, tls)

For our company we use redshield to monitor all inbound traffic. Also we have setup an Azure application gateway as the gatekeeper in the dmz so we did not have to have our cloverleaf serve visiable to the world.

The application gateway has our public IP/DNS and routes traffic to our internal cloverleaf server by the context path we assigned. We currently have 3 vendors using this webserver.

For security we use whitelisting of the vendors IP and we act as the ca and provide the vendors with a client certificate for mTls auth. Both are handled by redshield but can also be handled by the application gateway.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

Tim, I’ve tried to post multiple times about our setup but the forum is giving me an error and not sure why.  If this posts, send me a request to jxmercog@sentara.com and I’ll send you info.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[Author]

Replies