Welcome Guest! Log in

Topic-icon Solved FTPGet does not retrieve files

More
21 Sep 2015 17:01 #1 by TAOUILI
FTPGet does not retrieve files was created by TAOUILI
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.
Attachments:

Please Log in or Create an account to join the conversation.

More
22 Sep 2015 10:24 #2 by NORAUTO_LESQUIN
Replied by NORAUTO_LESQUIN on topic FTPGet does not retrieve files
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.

Please Log in or Create an account to join the conversation.

More
22 Sep 2015 11:15 #3 by TAOUILI
Replied by TAOUILI on topic FTPGet does not retrieve files
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
Attachments:

Please Log in or Create an account to join the conversation.

More
22 Sep 2015 11:58 #4 by Thomas BLETON
Replied by Thomas BLETON on topic FTPGet does not retrieve files
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.

Please Log in or Create an account to join the conversation.

More
22 Sep 2015 12:42 #5 by TAOUILI
Replied by TAOUILI on topic FTPGet does not retrieve files
Hello,

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



Attachments:

Please Log in or Create an account to join the conversation.

More
22 Sep 2015 14:36 #6 by Thomas BLETON
Replied by Thomas BLETON on topic FTPGet does not retrieve files
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 ?

Please Log in or Create an account to join the conversation.

More
22 Sep 2015 14:49 #7 by TAOUILI
Replied by TAOUILI on topic FTPGet does not retrieve 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

Please Log in or Create an account to join the conversation.

More
22 Sep 2015 15:39 #8 by Cyril Dussud
Replied by Cyril Dussud on topic FTPGet does not retrieve files
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 :
Attachments:

Please Log in or Create an account to join the conversation.

More
22 Sep 2015 18:06 #9 by TAOUILI
Replied by TAOUILI on topic FTPGet does not retrieve files
Thanks for your answers Thomas and Cyril.

Please Log in or Create an account to join the conversation.