[HoedjeRo]

Hi Jim,

Could you mail me an example xlate.
I am trying to do the similar/same thing for ORM messages but an example would be helpful.

1 ORM has multiple OBR’s and I need to send 1 message for each OBR.

 

Thnaks,

Roland

[HoedjeRo]

@John-Mercogliano,
I tried removing the everything left of the colon including the colon but for this particular site it will then result in:
Error while trying to write Benefit.csv.
Detailed error:Upload failed: No such file or directory (2/-31)
Curl errCode:78 Curl error: Remote file not found

I have set the curl option.

If I add the username including the colon it works for this site.
For another site I have the same as in your screenshots and that works fine.
Just to let you know as some sites are a little weird it seems.

 

Thanks for your help.

Roland
HCA Healthcare UK

Attachments:

You must be logged in to view attached files.

[HoedjeRo]

@John Mercogliano,

That is very helpful. I have tried something like this in the past but it seems that I must have missed something.
I have no successfully managed to test 2 different SFTP servers and managed to write to them.
As you can see in screenshots attached the directories in CL SFTP set up needs to match what is in WinSCP.

Many thanks,

Roland
HCA Healthcare UK

Attachments:

You must be logged in to view attached files.

[HoedjeRo]

What is the Secure Messenger license option called in the license file?

How can I check if I have this option?

[HoedjeRo]

I tried but that’s even worse. I have a thread feeding the SFTP connection but when I add a local binding address it fails (quicker).

[msg :Msg :DBUG/0:FTP_PERQUISITE:02/23/2023 09:01:01] msgFree 0x0x7fc9dd740d50 refCnt 1
[pd :pdtd:INFO/0:FTP_PERQUISITE:02/23/2023 09:01:01] [0.0.38559] Writing message to Protocol Driver fileset-ftp
[fset:init:DBUG/0:FTP_PERQUISITE:02/23/2023 09:01:01] fcDoNetworkStuff: mode=5
[pd :pdtd:INFO/1:FTP_PERQUISITE:02/23/2023 09:01:01] Set driver status to PD_STATUS_UP
* Trying 62.32.120.35…
* TCP_NODELAY set
* Name ‘uksalqapcl01’ family 2 resolved to ‘127.0.0.1’ family 2
* Local port: 0
* Immediate connect fail for 62.32.120.35: Invalid argument
* Closing connection 0
[fset:wrte:ERR /0:FTP_PERQUISITE:02/23/2023 09:01:01] Error while trying to write 2023-02-23Benefit.csv.
[fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Detailed error:
[fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Curl errCode:7 Curl error: Couldn’t connect to server

 

Or:

[msg :Msg :DBUG/0:FTP_PERQUISITE:02/23/2023 09:09:08] msgFree 0x0x7f907d98ed50 refCnt 1
[pd :pdtd:INFO/0:FTP_PERQUISITE:02/23/2023 09:09:08] [0.0.38559] Writing message to Protocol Driver fileset-ftp
[fset:init:DBUG/0:FTP_PERQUISITE:02/23/2023 09:09:08] fcDoNetworkStuff: mode=5
[pd :pdtd:INFO/1:FTP_PERQUISITE:02/23/2023 09:09:08] Set driver status to PD_STATUS_UP
* Trying 62.32.120.35…
* TCP_NODELAY set
* Name ‘10.96.244.30’ family 2 resolved to ‘10.96.244.30’ family 2
* Local port: 0
* Connected to 62.32.120.35 (62.32.120.35) port 22 (#0)
< SSH-2.0-VShell_4_3_2_1566 VShell
* server response timeout
* Closing connection 0
[fset:wrte:ERR /0:FTP_PERQUISITE:02/23/2023 09:09:38] Error while trying to write 2023-02-23Benefit.csv.
[fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Detailed error:server response timeout
[fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Curl errCode:28 Curl error: Timeout was reached
[pd :pdtd:INFO/1:FTP_PERQUISITE:02/23/2023 09:09:38] Set driver status to PD_STATUS_OPENING
[pd :pdtd:INFO/1:FTP_PERQUISITE:02/23/2023 09:09:40] Set driver status to PD_STATUS_ERROR
[pd :pdtd:INFO/1:FTP_PERQUISITE:02/23/2023 09:09:40] [0.0.38559] Writing message failed

• This reply was modified 2 years, 8 months ago by HoedjeRo.

[HoedjeRo]

I have made the changes as suggested (not with a local binding address) and no joy.

Active mode disabled. Directory and template adjusted accordingly. Removed the SFTP option and left the drop down empty and made sure we’re still connecting to port 22.

[msg :Msg :DBUG/0:FTP_PERQUISITE:02/22/2023 15:38:52] msgFree 0x0x7f8eafda8f50 refCnt 1
[pd :pdtd:INFO/0:FTP_PERQUISITE:02/22/2023 15:38:52] [0.0.38559] Writing message to Protocol Driver fileset-ftp
[fset:init:DBUG/0:FTP_PERQUISITE:02/22/2023 15:38:52] fcDoNetworkStuff: mode=5
[pd :pdtd:INFO/1:FTP_PERQUISITE:02/22/2023 15:38:52] Set driver status to PD_STATUS_UP
* Trying 62.32.120.35…
* TCP_NODELAY set
* Connected to 62.32.120.35 (62.32.120.35) port 22 (#0)
< SSH-2.0-VShell_4_3_2_1566 VShell
* server response timeout
* Closing connection 0
[fset:wrte:ERR /0:FTP_PERQUISITE:02/22/2023 15:39:22] Error while trying to write 2023-02-22Benefit.csv.
[fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Detailed error:server response timeout
[fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Curl errCode:28 Curl error: Timeout was reached
[pd :pdtd:INFO/1:FTP_PERQUISITE:02/22/2023 15:39:22] Set driver status to PD_STATUS_OPENING
[pd :pdtd:INFO/1:FTP_PERQUISITE:02/22/2023 15:39:24] Set driver status to PD_STATUS_ERROR
[pd :pdtd:INFO/1:FTP_PERQUISITE:02/22/2023 15:39:24] [0.0.38559] Writing message failed

 

 

I’m trying to find out if I can authenticate with private and public key instead of username and password.

Jammer maar helaas.

[HoedjeRo]

When I have a putty session open to my RHEL CL server and there start stp user@<dest-ip> I get prompted for the password.
Enter password connect is established.

do command:
put HCAEmployeeSpecificBenefit14022023.csv Outbox/
And the file is transported without issue.

Still the GUI doesn’t give me the same result. I get:

[pd :pdtd:INFO/0:FTP_PERQUISITE:02/16/2023 09:57:45] [0.0.38518] Writing message to Protocol Driver fileset-ftp
[fset:init:INFO/1:FTP_PERQUISITE:02/16/2023 09:57:45] set ACTIVE mode
[fset:init:DBUG/0:FTP_PERQUISITE:02/16/2023 09:57:45] fcDoNetworkStuff: mode=5
* Trying 62.32.120.35…
* TCP_NODELAY set
* Connected to 62.32.120.35 (62.32.120.35) port 22 (#0)
< SSH-2.0-VShell_4_3_2_1566 VShell
* server response timeout
* Closing connection 0
[fset:wrte:ERR /0:FTP_PERQUISITE:02/16/2023 09:57:55] Error while trying to write Outbox/2023-02-16Benifit.csv.
[fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Detailed error:server response timeout
[fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Curl errCode:28 Curl error: Timeout was reached
[pd :pdtd:INFO/1:FTP_PERQUISITE:02/16/2023 09:57:55] Set driver status to PD_STATUS_OPENING
[pd :pdtd:INFO/1:FTP_PERQUISITE:02/16/2023 09:57:57] Set driver status to PD_STATUS_ERROR
[pd :pdtd:INFO/1:FTP_PERQUISITE:02/16/2023 09:57:57] [0.0.38518] Writing message failed

Attachments:

You must be logged in to view attached files.

[HoedjeRo]

Also when I use manual commend from a putty session I can log in on SFTP and put any file in the destination location.
I may need to do this with tcl as I can’t make the GUI to do the correct function and put the file there

[HoedjeRo]

I’m still getting the error:

===========

Error while trying to write /Outbox/2023-02-15Benifit.csv.
Detailed error:Upload failed: No such file or directory (2/-31)
Curl errCode:78 Curl error: Remote file not found

 

I’m also using “/Outbox/%SYS.DATE%Benifit.csv” as the file template and “/Outbox/Benifit.csv” as the file config.
Nothing in the directories item.

Confused as I can easily do this using the same credentials with WinSCP

[HoedjeRo]

That has worked nicely. Thank you

[Author]

Replies