[John Mercogliano]

Peter, the fact that the log file hit 2GB and you are on AIX would lead me to believe that this is the reason the messages stopped processing.  I would check the cycle settings for that process in the netconfig to ensure they are checked as you definitely don’t want your logs getting to 2GB.

John Mercogliano
Semi Retired, contractor
Hampton Roads, VA

[John Mercogliano]

Hi Peter,

A 2GB log file is pretty big, do you have auto cycling for logs and smat turned on for the process?  I remember on aix we had issues with the interface hanging when any file got to 2GB because of AIX cloverleaf being 32bit.

John Mercogliano
Semi Retired, contractor
Hampton Roads, VA

[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 9 months, 1 week ago by John Mercogliano.

John Mercogliano
Semi Retired, contractor
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
Semi Retired, contractor
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
Semi Retired, contractor
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
Semi Retired, contractor
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
Semi Retired, contractor
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
Semi Retired, contractor
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 1 year, 7 months ago by John Mercogliano.

John Mercogliano
Semi Retired, contractor
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
Semi Retired, contractor
Hampton Roads, VA

[John Mercogliano]

Excellent glad that worked.

John Mercogliano
Semi Retired, contractor
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 1 year, 7 months ago by John Mercogliano.

John Mercogliano
Semi Retired, contractor
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
Semi Retired, contractor
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
Semi Retired, contractor
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
Semi Retired, contractor
Hampton Roads, VA

[Author]

Replies