Question

SFTP Sender


Badge +4

Has anyone got SFTP sender to work in Apps9

I have the reader working but if I set up the sender with the same details there appears to be no network traffic at all and just an error message:-

 

 

Is there something missing from the documentation ?

Regards,

Alan

 


30 replies

Badge +4

It looks OK. Check to ensure no trailing spaces and the sftp_knownhosts file was created with the host, username and password as entered on this screen. Opened in notepad is should start with the destination then the encryption method (i think) followed by lots of what is I assume an encrypted string containing something - possible 200-400 characters (
repository.jehall.co.uk ssh-rsa AAAAB3NzaC1yc2EAAAADA).

I presume that putting these details into something like filezilla connects with no trouble.

Userlevel 1
Badge +6

Routing address screenshot

sftp connect screenshot

 

Badge +4

Unfortunately this seems to be a generic error message for anything wrong. It did this to me when I left a space on the end of the hostname on the connect setup screen :(

Could you supply screenshots of routing address, sftp connect details and your knownhosts file. 

Userlevel 1
Badge +6
error
address data configuration
​​​​​​

after I applied and retested your solution I still get the same error message.
What am I doing wrong?

 

 

Badge +4

What just happened to my screen shots ?

 

Online documentation

Misunderstood as the file being output instead of the file on the destination

Entered on Routing screen

Should have been

 

Badge +4

Fixed at last - it was all down to the routing address screen

 

Online documentation

 

 

Misunderstood as the file being output instead of the file on the destination

 

 

Entered on Routing screen

 

 

Should have been

 

 

Userlevel 1
Badge +6

we have the same issue (IFS App 9)

Badge +4

Thanks for your suggestion Andy. I have implemented both but still no luck.

Wire shark still does not show any outgoing packets, not even a query on the host name - Apps 9 is behaving like a petulant child, it is saying it can’t connect without even trying :(

Userlevel 3
Badge +8

I also gave the know_hosts file a file extension so it doesn’t get misinterpreted as folder.

Userlevel 3
Badge +8

Hi Alan

As it happens, I’ve had to set-up a new SFTP Sender and we were getting exactly the same problem as you were   (Apps 9 Update 12)

When I dug a little deeper, the problem was to do with the file and path names. Not sure it this is the same issue but I had to prefix the folder path.

 

Andy

Badge +4

Hello Mike,

 

We are currently on Upd14 waiting for IFS to fix some WIP problems before we move to Upd17 ready for the new version of Oracle.

 

The parameter screen was mainly copy & paste between the reader & writer

 

SFTP_READER1    Integration    SERVERAUTH_KNOWNHOSTS    TypeText    C:\IFS\sftp_knownhosts    
SFTP_TEST    Integration    SERVERAUTH_KNOWNHOSTS    TypeText    C:\IFS\sftp_knownhosts    

Userlevel 4
Badge +7

Just to make sure, but the path to the knownhosts is the same on your reader? 

 - I’m trying to make sure you are referecing the same file

 

Please run this and post the result:

 

select instance_name,area_name,parameter_name,parameter_type,parameter_value,value_list from fndcn_config_param_tab where instance_name in ('SFTP_SENDER1','SFTP_READER1') AND parameter_name = 'SERVERAUTH_KNOWNHOSTS'

--you might be using different connector names, so please ensure you adjust to reflect your test connectors.

What update version are you on? I beleive Upd16 is available for Apps9.

Badge +4

Mike,

 

I assume that the knownhosts file must be correct as the SFTP_Reader works fine.

 

I honestly think this is a bug, although IFS won’t admit it, because there is absolutely no network traffic before the error message - I would expect at least a DNS query.

Userlevel 4
Badge +7

Alan,

 

Have you configured the knownhosts file as per the instructions in the IFS help?

 

It needs to contain the thumbprint of the sftp server you are trying to authenticate with.

Userlevel 7
Badge +15

Hi @Alan Gillespie ,

 

Yes, there ‘s a high possibility of this error correlated to the SFTP sender error, and hopefully someone from IFS Technology will provide a proper explanation or you could log a case to IFS support.

 Have you tested SFTP sender with a integration scenario than the Routing Address Test option? Maybe it works after all? If not, interesting to check the error message in the application message.

 

Regards,

Damith

Badge +4

Thanks Damith

 

Like the SFTP Reader the java code ran and connected as expected. However the ManagedServer Log in J2EE has an interesting error when trying to run the IFS SFTP Sender -

. [Error GUID:084152be-54cb-4737-8725-cd474908ab47]
2020-04-20 11:36:35,419  66 WARNING [Integration] ifs.fnd.tc.framework.xml.XMLUtil.getEncoding(): [B@562416b7
ifs.fnd.base.SystemException: Route Address Tester not exist in Foundation configuration
    at ifs.fnd.tc.framework.config.Config.<init>(Config.java:105)
    at ifs.fnd.tc.framework.Instance.<init>(Instance.java:38)
    at ifs.fnd.tc.framework.ConnectFramework.getReader(ConnectFramework.java:285)

 

Would I be correct in assuming that IFS have not installed all the relevant code or is this a hidden chargeable extra ?

Full extract of log attached

 

Userlevel 7
Badge +15

I can connect using SFTP_Reader and FileZilla works both directions. Wireshark does not show any activity so nothing in the SFTP server logs. There is nothing in the connectserver logs - from the documentation I gather that the connectserver is for incoming.

 

yes, you are correct. connectserver logs is for incoming. You should look in the j2ee for sender logs.

Check ifsapplog-*.log and ifsalert-*.log to see if you ind any interesting information there.

 

I once got stuck with the SFTP sender setup and created attached java code to simulate the IFS sftp sender connection. Hope it could guide you also to solve the issue.

 

Change the SFTP parameters in getClient() to your sftp details, compile and run from the application server machine. at least it will give the ‘real’ error message which then can investigate further.

 

below is how to compile and run the java code 

 

Cheers!

Damith

Userlevel 3
Badge +8

:frowning2:

 

 

Badge +4

Thanks for your help.

 

It’s taken IFS 3 months to come to the same conclusion and now they want to charge us to look at it :(

 

Userlevel 3
Badge +8

Well  I’m fresh out of ideas then - Sorry.

Badge +4

yes, it works in sftp_reader

 

Userlevel 3
Badge +8

and sftp_knowhosts is set-up?

Badge +4

I have created routing rule and address and a test file. I run the test from the routing address screen.

Userlevel 3
Badge +8

Have you created the Routing Rules to Generate the output?

Badge +4

I can connect using SFTP_Reader and FileZilla works both directions. Wireshark does not show any activity so nothing in the SFTP server logs. There is nothing in the connectserver logs - from the documentation I gather that the connectserver is for incoming.

Reply