topic Re: Detecting file not found with tFTPGet in Talend Studio

Detecting file not found with tFTPGet

rviard — Mon, 16 Apr 2018 18:33:25 GMT

Hi,

I have a job that tries to pick up a file from our sftp site every morning. I would like to detect if the file is missing.

The tFTPGet onSubJobOK connects to a fileInputDelimited component. As long as the file is there, it works fine.

I connected a tSendMail component that is connected to the OnComponentError of the tFTPGet and should send the error via email using ((String)globalMap.get("tFTPGet_1_ERROR_MESSAGE"))

Unfortunately, when I run the job and the file is missing, it always seems to return OK not error (even though I can see the job returning "the system can't file the file specified".)

Any idea what I'm doing wrong?

TIA.

Re: Detecting file not found with tFTPGet

Anonymous — Mon, 16 Apr 2018 20:00:49 GMT

"OnComponentError" will only trigger if the component itself fails (e.g. the connection to the ftp site gets closed, or something along those lines). Even though that file was not found, the component still executed successfully. If you're looking to see if a specific file name was processed, you could use the tFTPFileExist component, then check the global var ((Boolean)globalMap.get("tFTPFileExist_1_EXISTS"))

Re: Detecting file not found with tFTPGet

rviard — Mon, 16 Apr 2018 20:02:43 GMT

Ah, OK. That makes sense. Thank you I'll try your suggestion.

Re: Detecting file not found with tFTPGet

cterenzi — Mon, 23 Apr 2018 16:59:06 GMT

Alternately, you can create a conditional (Run If) link from tFTPGet with a condition like:
((Integer)globalMap.get("tFTPGet_1_NB_FILE")) == 0

Re: Detecting file not found with tFTPGet

rviard — Mon, 23 Apr 2018 17:31:59 GMT

Thanks, the first solution got the job done, but I'll keep that in mind.

Re: Detecting file not found with tFTPGet

abhi90 — Mon, 23 Apr 2018 20:02:40 GMT

Please mark the solution as accepted whichever helped u