topic Re: [resolved] Exception in component tFileInputExcel_1 in Talend Studio

[resolved] Exception in component tFileInputExcel_1

Anonymous — Wed, 10 Aug 2016 22:41:03 GMT

Hello Guys,
I am trying to load the data from the XLS files inside sub directories to MYSQL.
Basically there is a parent directory and inside that there are many sub directories in which XLS files are stored.
i am getting below error.
Starting job Mult_file at 02:52 11/08/2016.
connecting to socket on port 4054
connected
Exception in component tFileInputExcel_1
java.io.FileNotFoundException: C:\Users\Dinesh\Desktop\Investment\Input Files\XLS\Dec_15 (Access is denied)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at test1.mult_file_0_1.Mult_file.tFileList_1Process(Mult_file.java:1619)
at test1.mult_file_0_1.Mult_file.runJobInTOS(Mult_file.java:2788)
at test1.mult_file_0_1.Mult_file.main(Mult_file.java:2645)
disconnected
Job Mult_file ended at 02:52 11/08/2016.

In tFILELIST_1 the directory path is set to "C:/Users/Dinesh/Desktop/Investment/Input Files/XLS"
Please note that i am able to load all the excels from a directory if sub directories are not there. ie , if i define directory path as C:\Users\Dinesh\Desktop\Investment\Input Files\XLS\Dec_15 in tFileLIST_1.
Please help.
System : Windows 7 64 Bit
Thank,
Vanijyagyan

Re: [resolved] Exception in component tFileInputExcel_1

Anonymous — Thu, 11 Aug 2016 08:27:07 GMT

Hi,
Did you have "administrator" role for your system C disk? Could you please show us your whole job design?
Did you design you job like tfilelist-->tfileinputexcel?
Best regards
Sabrina

Re: [resolved] Exception in component tFileInputExcel_1

Anonymous — Thu, 11 Aug 2016 21:31:23 GMT

Hi,
Did you have "administrator" role for your system C disk? Could you please show us your whole job design?
Did you design you job like tfilelist-->tfileinputexcel?
Best regards
Sabrina

Thanks xdshi!!
I have Administrator access , ie i am able to add/delete files in the directory. As i mentioned i am able to load the files from when there are no sub-directories.
Yes, i have designed the job like tFileList --> tFileInputExcel.
I am attaching the screen shots.
Thanks again,
VG

Re: [resolved] Exception in component tFileInputExcel_1

Anonymous — Fri, 12 Aug 2016 10:05:16 GMT

Hi,
We can't see the screenshot on our side. Could you attach it on the forum, please? That would be great.
Best regards
Sabrina

Re: [resolved] Exception in component tFileInputExcel_1

Anonymous — Sat, 13 Aug 2016 22:36:14 GMT

Attached.

Re: [resolved] Exception in component tFileInputExcel_1

Anonymous — Sat, 13 Aug 2016 22:39:05 GMT

getting this mssg when i try to upload screenshots.
It seems your post consisted of empty BBCodes only. It is possible that this happened because e.g. the innermost quote was discarded because of the maximum quote depth level.

Re: [resolved] Exception in component tFileInputExcel_1

TRF — Sun, 14 Aug 2016 09:10:04 GMT

Hi,
Dis you forgot the last / (or \) just before the filename?
Regards,
TRF

Re: [resolved] Exception in component tFileInputExcel_1

Anonymous — Sun, 14 Aug 2016 13:34:51 GMT

Thanks TRF for your response.
I think path is defined correctly.
In tFileList_1 component,
Directory : "C:/Users/Dinesh/Desktop/Investment/Input Files/XLS/"
include subdirectory checkbox is checked.
In tFileInputExcel_1
Filename/Stream : ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))
somehow i am not able to upload the images. I am using chrome browser
Thanks,
VG.

Re: [resolved] Exception in component tFileInputExcel_1

TRF — Sun, 14 Aug 2016 14:32:55 GMT

Are you sure to have read permission for all directories and files in C:/Users/Dinesh/Desktop/Investment/Input Files/XLS (including hidden elements)?
Does the error occur when launching the job into TOS or as an autonomous job?
Try to launch it when admin grants (right click then run as...)

Re: [resolved] Exception in component tFileInputExcel_1

Anonymous — Sun, 14 Aug 2016 23:32:52 GMT

Hi TRF,
Thanks, really appreciate for your help.
Yes, i have all rights. I even run the job as admin, still getting the same error.
from the below log error, i understand that exception is thrown from the tFileInputExcel_1 component.
Exception in component tFileInputExcel_1
java.io.FileNotFoundException: C:\Users\Dinesh\Desktop\Investment\Input Files\XLS\Dec-15 (Access is denied)
it seems like tFileInputExcel_1 is expecting an excel file but a directory is sent to it??? just a guess...
Thanks,
VG

Re: [resolved] Exception in component tFileInputExcel_1

cterenzi — Mon, 15 Aug 2016 15:17:45 GMT

Are you setting a file mask in tFileList? If not, it is probably returning every file in the directory tree. Limiting it to *.xls and/or *.xlsx might do the trick.

Re: [resolved] Exception in component tFileInputExcel_1

Anonymous — Mon, 15 Aug 2016 21:20:38 GMT

Thanks cterenzi. I tried the approach you suggested but it didnt work.
However i am able to resolve this issue by setting Filelits Type to "Files". Earlier it was set to "Both"
Thanks,
VG

Re: [resolved] Exception in component tFileInputExcel_1

Anonymous — Tue, 16 Aug 2016 08:04:06 GMT

Hi,

If the issue is closed, could you please click the "Set this topic as resolved" link which is right underneath your initial post? This way, other users will be informed that this thread has been resolved.

Best regards

Sabrina