topic Re: raise and catch 'File Not Found' Exception in Talend Studio

raise and catch 'File Not Found' Exception

Anonymous — Tue, 03 Jul 2012 05:13:45 GMT

HI,
My job looks similar to the below.
tfilelist --(Iterate) -->tfileinputdelimited --(main)--> tmap --(main)--> staging_tbl (subjob1)
| \ ^
| (subjobok) \ (reject) | (lookup)
| \ dim1
| reject table
v
(subjob2)
|
|
v
other subjobs
:
:
I would like to raise and catch the 'File Not Found' exception if the expected file is not available in the directory, but I am not getting any error . Please advice.
Thank you.

Re: raise and catch 'File Not Found' Exception

Anonymous — Tue, 03 Jul 2012 06:43:57 GMT

Hi
Which version of TOS do you use?
I'm using TOS 5.1.1 and the component tFileList can generate error when no file found.
Regards,
Pedro

Re: raise and catch 'File Not Found' Exception

Anonymous — Tue, 03 Jul 2012 07:17:57 GMT

Hi,
The 'File name' is coming from a database table which in turn assigned to a context variable.
The directory name is coming from the context variable.
We are using TOS 4.1.2

connecting to socket on port 3895
connected
Exception in component tFileInputDelimited_2
java.io.FileNotFoundException:

Getting the above error if my job starts with tfileinputdelimited instead of tfilelist.
Thank you.

Re: raise and catch 'File Not Found' Exception

Anonymous — Tue, 03 Jul 2012 07:31:52 GMT

Hi
Maybe I know the reason now.
What do you mean "the expected file is not available in the directory"?
The option "Generate error if no file found" indicates that only the file doesn't exist in this directory. It will generate error.
Well. If the file exists in this directory and it cannot be accessed, the error won't occur.
Maybe you get a wrong understanding about this option?
Or. You might try to update your TOS version. TOS 4.1.2 is relatively old...
Regards,
Pedro

Re: raise and catch 'File Not Found' Exception

Anonymous — Tue, 03 Jul 2012 07:41:33 GMT

Hi Pedro,
I have created the job to process the file 'TAL_TEST.TXT'. As stated before the file name is assigned to a context variable from the database table. The directory name is coming from the context variable.
In case the file 'TAL_TEST.TXT' is not available in the directory, I presume the job should abend and an exception should be raised. Everything works perfectly well if my job starts with tfileinputdelimited.
When I use the tfilelist --(Iterate) -->tfileinputdelimited the job is not producing any error OR is that how the tfilelist component works, if the file is not available it will continue processing. In our case the filemask will be the actual file name from the context, thus we are processing the whole job just for one file.
Hope I am clear with my issue.
Thank you.

Re: raise and catch 'File Not Found' Exception

Anonymous — Tue, 03 Jul 2012 07:48:12 GMT

Hi
Finally, got you...
The usages of tFileInputDelimited and tFileList are apparently different.
Why don't you select the option "generate error when no file found" on tFileList?
It would show you the following exception when no file found.
java.lang.RuntimeException: No file found in directory F:/TOS_DI-r84309-V5.1.1/workspace
Regards,
Pedro

Re: raise and catch 'File Not Found' Exception

Anonymous — Tue, 03 Jul 2012 07:54:55 GMT

Thanks Pedro,
I just noticed the check box Generate Error if no file found. However, can't the exception be caught and handled with custom message.

Re: raise and catch 'File Not Found' Exception

Anonymous — Tue, 03 Jul 2012 08:04:48 GMT

Hi
Sorry. You can't use the custom message here.
Regards,
Pedro

Re: raise and catch 'File Not Found' Exception

Anonymous — Tue, 03 Jul 2012 08:29:39 GMT

Thanks for the clarification Pedro.

Re: raise and catch 'File Not Found' Exception

_AnonymousUser — Tue, 10 Sep 2013 10:14:39 GMT

hi,

I want all details about a job start time,processing status,error message and reason for execution failure stop time ,total execution time,job completion status ,like this all information relating to a job to be written from tool to a database. Is it possible ? If yes ,give the sample job to achieve this scenario.

with regards,
banu

Re: raise and catch 'File Not Found' Exception

Anonymous — Tue, 10 Sep 2013 12:39:35 GMT

Hi!
Here is the link on the tutorial that may help you to receive all the information you want.
http://www.talendforge.org/tutorials/tutorial.php?idTuto=31
Please send feedback if this is what you're looking for.
tnx
Best regards!
LadyButterfly

Re: raise and catch 'File Not Found' Exception

_AnonymousUser — Tue, 10 Sep 2013 13:11:22 GMT

hi,

It was useful , but what i want is does tool have variable that give details about job execution ,the stack trace which prints on console should be given in variable so we can keep a record of what has happened to job in database.

Re: raise and catch 'File Not Found' Exception

Anonymous — Tue, 10 Sep 2013 13:33:06 GMT

Hi!
I looked up for list of global variables in tJava component (ctrl+space) which have all Talend Jobs, but there is nothing useful
If you find the way to see all the job details, let me now the procedure to achieve it.
TNX
Best regards,
Lady Butterfly

Re: raise and catch 'File Not Found' Exception

_AnonymousUser — Wed, 11 Sep 2013 07:13:18 GMT

hi

Refer this link
http://www.dataprix.net/en/blogs/respinosamilla/product-dimension-etl-load-more-examples-talend-using-logs-metrics-and-statisti
check whether its usefull