Question

Deleting files from FTP not working with FTPCaller

M
Badge

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
Rank
Userlevel 3
Badge +17
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
Badge

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
Rank
Userlevel 3
Badge +17

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
Badge
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
Rank
Userlevel 3
Badge +17
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


Community Stats

28,725
Posts
109,520
Replies
36,565
Members
Terms & ConditionsCookie 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.