Skip to main content

Hi,

I'm trying to use a FME Server Subscription (SFTP) to send the excel spreadsheet to the server outside.

The port 22 has been open for that sftp, the customer can see me connecting to their server, there is no file being transfered though.

I have a simple workspace what is generting excel table and sending an email with that table as an attachement. That workspace is published on the FME Server, the process is scheduled to run once a week, I want to use that worspace to also upload that table to the sftp.

I decided to create a topic Success_for_SFTP and us it for 'post to topic that topic on success' for the Job Submitter when I published that workscpace

The table is written to: $(FME_SHAREDRESOURCE_DATA)/folder/table.xlsx

The SFTP Subscription screenshot below.

I want the Subscription to take the file from the $(FME_SHAREDRESOURCE_DATA) and upload it to the /ftp/files on the customer server

The workspace:

 

The workspace runs succesfuly, it is sending an email, it is making a connection to the server but not uploading a file

Would anybody give me some idea how upload the file using SFTP.

I've tried also the Publication - directory watcher, it doesn't seems to work either.

Regards,

Kamila

Hi @sliwkak,

I would consider using a FTPCaller in the workspace to do the upload instead of the subscription.

Itay


Hi @sliwkak,

I would consider using a FTPCaller in the workspace to do the upload instead of the subscription.

Itay

Hi itay,

Thank you for your suggestion.

I've tried that as well

I run that workspace on FME Server (as the port is open between the taht server and the clients server) it faild

FTPCaller(FTPFactory): HTTP/FTP transfer error: 'Couldn't connect to server'The below feature caused the translation to be terminated

 

Regards,

Kamila


Hi itay,

Thank you for your suggestion.

I've tried that as well

I run that workspace on FME Server (as the port is open between the taht server and the clients server) it faild

FTPCaller(FTPFactory): HTTP/FTP transfer error: 'Couldn't connect to server'The below feature caused the translation to be terminated

 

Regards,

Kamila

Hi Kamila,

Try adding the file name in the FTPCaller URL parameter.


Hi Kamila,

Try adding the file name in the FTPCaller URL parameter.

Hi,

I've tried it, still the same error.

Kamila


Hi,

I've tried it, still the same error.

Kamila

Hi,

Can it be because you are not using any authentication in the FTPCaller? Can you connect to the FTP with another application?


Try looking at the FME Server logs to see what the SFTP subscription is saying. You should see some information there.

 

 

i would also consider the FTP Caller as @itay has suggested. One tip I have to help with this is to temporarily turn on DEBUG logging in the workspace. I've found that with the FTP Caller it can be helpful in figuring out whats going on and where specifically things are not working.

 

 

Good luck!

Try looking at the FME Server logs to see what the SFTP subscription is saying. You should see some information there.

 

 

i would also consider the FTP Caller as @itay has suggested. One tip I have to help with this is to temporarily turn on DEBUG logging in the workspace. I've found that with the FTP Caller it can be helpful in figuring out whats going on and where specifically things are not working.

 

 

Good luck!

Hi,

I decided to focus on the HTTPCaller know. The subscriber is not picking up and transferring file over to the customer.

I've turned on the debug, republished the workspace with just creator and the FTPCaller

I'm getting the error:

FTPCaller(FTPFactory): HTTP/FTP transfer error: 'Remote file not found'

Currently the workspace looks like below, it is published on the FME server, that server has the port 22 open to comunitate through sftp.

The .xlsx file is in the /ftp/files on the customer server and also in the FME_SHAREDRESOURCES_DATA/../... .xlsx within our FME Server

The log with the error below.

Would you be able to advice?


Reply