[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 3 months, 2 weeks 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 3 months, 3 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

[John Mercogliano]

Hi Jim,

The field address section is editable so once you select your fields you can cut and paste to rearrange the order.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

Remove everything to the left of the colon including the colon.  You should only have /Outbox

I’ve attached a screen shot

It looks like it is adding the user name to the path which I’ve never seen before but winscp has a lot of configuration options.

The rest looks fine, at least similar configurations work for me.  If you have not set curl verbose to 1 you should do that to help troubleshoot.

 

 

 

Attachments:

You must be logged in to view attached files.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

Posted to the wrong article originally.

Since infor switched to using curl as it’s engine, you cannot use the dot operator to indicate the home directory.
When you log into winscp and drill down to the drop off directory, whatever directory you see in the current path bar is what you need to use in the directory entry in cloverleaf.  Otherwise you will get the “Detailed error:Upload failed: No such file or directory ” error.

The value you need to use will depend on the configuration of the server you are logging into.  Here is a more detailed explanation https://unix.stackexchange.com/questions/293756/set-startup-folder-for-sftp-to-be-other-than-home-username-is-throwing-me-permi

But I always use winscp to check that actual working directory value.

Hope this helps.

• This reply was modified 1 year, 5 months ago by John Mercogliano.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[John Mercogliano]

Since infor switched to using curl as it’s engine, you cannot use the dot operator to indicate the home directory.
When you log into winscp and drill down to the drop off directory, whatever directory you see in the current path bar is what you need to use in the directory entry in cloverleaf.  Otherwise you will get the “Detailed error:Upload failed: No such file or directory ” error.

The value you need to use will depend on the configuration of the server you are logging into.  Here is a more detailed explanation https://unix.stackexchange.com/questions/293756/set-startup-folder-for-sftp-to-be-other-than-home-username-is-throwing-me-permi

But I always use winscp to check that actual working directory value.

Also are you using CURLOPT_VERBOSE set to 1 in the cURL options?  It doesn’t look like in your later errors you are actually authenticating.  The timeout usually is either authentication, whitelisting, or firewall issues that I have encountered.

For the binding address definitely not 127.  When connecting to a public sftp server I have never had to set a binding address as they are seeing the public addresses of the firewall.

Hope this helps.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[Author]

Replies