Skip to main content
  • EN

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

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?

 

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 @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

 

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

 

 

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

30,459
Posts
115,668
Replies
38,278
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.