Solved FTPGet does not retrieve files

Hi
I have the same problem,
I can a access to the server FTP with Filezilla, i can see the files, but i'm trying to get the files with Stambia, it doesn't work.

Hi,
if you get error "503 You must issue the PBSZ command prior to PROT", try to add parameter "FTP_PROTECTION_BUFFER_SIZE" with value 0.

Hi,

I get no error, just i didn't get my files.
I added the parameter but, always nothing.
I don't know if my process is good or not (where can i see the table ind_session_ftp_..?).

Thanks

Hello,
I moved this request to a new forum topic, because it was not the same as "Command FTP put on FTPS Server".
The "ind_session_xxx" tables are created in the schema that you drag'n'droped on the FTP action (in your case apparently DB_CHANEL_DEV4_work).
Something to check: what is the value of the Variable "FILE_NB" in the "Variable" view, after execution ? This var indicates how many files the action has detected. If it is 0 then you need to check that the files really exist on the server. Also check the following Variables : FTP_REMOTE_PATH, FTP_REMOTE_FILENAME, FTP_LOCAL_PATH.

Hello,

I don't find this table in my schema.
This my server FTP (FileZilla) and the capture of my variable view.

Thanks.
You are using the FTP Get action with "File Wait Mode" enabled, and an infinite expected number of files (FTP_NB_FILES=-1).
Quick note: if you do not set FTP_WAIT_TIMEOUT, your process will run infinitely.
There might be an issue with FTP_NB_FILES=-1. I am going to check with our developers.
Can you try setting FTP_NB_FILES to something like 10 to see if the action starts waiting for files ?

Thanks to you,

My process run for 6 sec.
When i changed the FTP_NB_FILES to 5, it works.

But i don't know how many file i can get, that's why i set FTP_NB_FILES to -1.

Thanks

Hi,
I see you are using "Ftp Wait Mode".
This mode is used to wait for files which may not be present at the moment of the execution, with setting a number of file to wait or a timeout. The action will then wait for files, which can appear on the fly during the execution, until the timeout or number of files is reached.

In the first screenshot you provide,showing the process, you were waiting an infinite number of file, but with no timeout. Like Thomas said, it can lead to a process running indefinitely.
It looks like you only needed to retrieve files which are already present and existing in the folder.
If it is correct you don't need to use the "Ftp Wait Mode" or "FTP_NB_FILES" parameters.

For example, this should work to retrieve all the .txt files of a folder :

Thanks for your answers Thomas and Cyril.