Skip to main content
Question

Deleting files from FTP not working with FTPCaller

M
Forum|alt.badge.img

My case is similar with this case ‘’ Deleting files from FTP - no errors in WorkSpace but files not deleted‘’ but a suggested solution didn’t work for me.

I have problem with FTPCaller when I try to delete oldest files on an FTP server.

The URL is the Full path and point to the specified files (remote file). See the transformer setting parameters screen shoot bellow.

But after a run of the workbench, the translation log on FME show that these files has been deleted and everything seems good, as you can see bellow (URLs paths here are schematized based on my real data URLs configuration, Sorry, Confidentiality!!!!) , but the files are not physically deleted on my FTP server.

The same user name works well when I manually delete the file using Filezilla and WinSCP

I have tried various parameters setting, no solution fund yet.

Translation Log (extract)

12:32:41| 5.4| 0.0|INFORM|FTPCaller_OldFilesDeleter(FTPFactory): FTP: Deleted file 'https://myftpsite/_TestForDataFolders/ProductFolder/ProductName_WKww_yy.iso', total time: '0.531 seconds'

5.5| 0.0|INFORM|FTPCaller_OldFilesDeleter(FTPFactory): FTP: Deleted file 'https://myftpsite/_TestForDataFolders/ProductFolder/ProductName_WKww_yy.iso.sha1', 'total time: '0.015 seconds'

 

Any Suggestions ?

Thanks In advance for your help

5 replies

debbiatsafe
Safer
Forum|alt.badge.img+20
Hi @mhadysow

 

What version of FME are you using? From your log snippet, it looks like you are using a https URL. Is that correct?

 

M
Forum|alt.badge.img
  • mhadysow
  • Author
  • May 10, 2018

Hi @DebbiAtSafe , I’m using FME Desktop 2017.1.2.1.

Yes I’m using https in the URL of my destination-FTP-folder. A same path is working for the new files Upload part on FTP sever (same destination folder) with other separate FTPCaller (named FTPCallerNewFilesUpload). This part works well with a same destination path (https://files.XXXXXXX.com(myftpsite)/_TestForDataTeam/ProductFolder/ProductName_WKww_yy.iso

& https://files.XXXXXXX.com(myftpsite)/_TestForDataTeam/ProductFolder/ProductName_WKww_yy.iso.sha1) and the new files are uploaded to the destination folder after process run.

I don't know why my second FTPCaller for Previous-Files-deleter is not working (Files are not deleted after process but the log show that it’s successful).

I am continuing looking for an alternative solution like Using Python caller with python code for FTP connection and removing oldest files (or /files older of N-days). Normally I already have a PowerShell script for that, unfortunately, I don’t Know if there is a transformer for calling PowerShell-scripts in FME 2017.1.2.1

Thank you in advance for your interest and support.

debbiatsafe
Safer
Forum|alt.badge.img+20
mhadysow wrote:

Hi @DebbiAtSafe , I’m using FME Desktop 2017.1.2.1.

Yes I’m using https in the URL of my destination-FTP-folder. A same path is working for the new files Upload part on FTP sever (same destination folder) with other separate FTPCaller (named FTPCallerNewFilesUpload). This part works well with a same destination path (https://files.XXXXXXX.com(myftpsite)/_TestForDataTeam/ProductFolder/ProductName_WKww_yy.iso

& https://files.XXXXXXX.com(myftpsite)/_TestForDataTeam/ProductFolder/ProductName_WKww_yy.iso.sha1) and the new files are uploaded to the destination folder after process run.

I don't know why my second FTPCaller for Previous-Files-deleter is not working (Files are not deleted after process but the log show that it’s successful).

I am continuing looking for an alternative solution like Using Python caller with python code for FTP connection and removing oldest files (or /files older of N-days). Normally I already have a PowerShell script for that, unfortunately, I don’t Know if there is a transformer for calling PowerShell-scripts in FME 2017.1.2.1

Thank you in advance for your interest and support.

Hi @mhadysow

 

This may be related to a bug with deleting files from SFTP server that was fixed in FME 2018. Would it be possible for you to try FME 2018?

 

Alternatively, since you have mentioned you have a PowerShell script already, you may be able to use the SystemCaller transformer to run your Powershell script by calling PowerShell.exe. This documentation may be useful if you wish to go down this route: https://docs.microsoft.com/en-us/powershell/scripting/core-powershell/console/powershell.exe-command-line-help?view=powershell-6

 

M
Forum|alt.badge.img
  • mhadysow
  • Author
  • May 15, 2018
debbiatsafe wrote:
Hi @mhadysow

 

This may be related to a bug with deleting files from SFTP server that was fixed in FME 2018. Would it be possible for you to try FME 2018?

 

Alternatively, since you have mentioned you have a PowerShell script already, you may be able to use the SystemCaller transformer to run your Powershell script by calling PowerShell.exe. This documentation may be useful if you wish to go down this route: https://docs.microsoft.com/en-us/powershell/scripting/core-powershell/console/powershell.exe-command-line-help?view=powershell-6

 

Hi, @DebbiAtSafe ,

 

Thank you for your suggestion, but FTPCaller files deleting still Not working also in FME 2018 . I'm continuing looking for alternative solution. Il will try a SystemCaller transformer for powerShell scripts and revert once I got new information.

 

Thank for your support

 

 

debbiatsafe
Safer
Forum|alt.badge.img+20
mhadysow wrote:
Hi, @DebbiAtSafe ,

 

Thank you for your suggestion, but FTPCaller files deleting still Not working also in FME 2018 . I'm continuing looking for alternative solution. Il will try a SystemCaller transformer for powerShell scripts and revert once I got new information.

 

Thank for your support

 

 

Hi @mhadysow

 

That's too bad FME 2018 did not work for you.

 

We would like to investigate this behaviour further as it is obviously incorrect. Would you mind filing a support case at safe.com/support?

 

Reply


Helpful Members This Week

Community Stats

31,201
Posts
118,273
Replies
38,804
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.