Talend community forum / Error finding excel files

fszeborg · 2009-02-18 16:10:42

Tags: [database, error management, excel, java, mssql, tis]

I'm having issues with excel files. I can no longer read ecel files used for lookups. I can edit the file's metadata but when I run the job I am getting error messages such as:

Exception in component tFileInputExcel_1
java.io.FileNotFoundException: S:\NWH\Completed_data\Low_Volume\Employment_orig.xls (The system cannot find the path specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at nwh_consolidation.c_find_rejects_0_1.c_Find_Rejects.tFileInputExcel_1Process(c_Find_Rejects.java:49500)
at nwh_consolidation.c_find_rejects_0_1.c_Find_Rejects.tMSSqlInput_1Process(c_Find_Rejects.java:2963)
at nwh_consolidation.c_find_rejects_0_1.c_Find_Rejects.runJobInTOS(c_Find_Rejects.java:62874)
at nwh_consolidation.c_find_rejects_0_1.c_Find_Rejects.main(c_Find_Rejects.java:62716)
[statistics] disconnected

The odd thing is that this job has worked before.

I am also getting a similar message when I try to create an excel file using tFileOutputExcel.

I am using the Tis Version: 3.0.2, MS SQLServer 2005.

Can anyone make any suggestions?

cantoine · 2009-02-18 23:22:50

Hi,

Can you use slash "/" character to specify the filePath separator le "S:/NWH/Completed_data/Low_Volume/Employment_orig.xls" instead of "S:\NWH\Completed_data\Low_Volume\Employment_orig.xls"

If you use the folder explorer it will produce directly a right path, if you copy it from windows it will wrong.

Best regards;

fszeborg · 2009-02-18 23:36:23

I did use the explorer window and it did produce the desired slash "/".

I have gotten this to work however I need to run it as localhost instead of my desired server. Are excel files relative to the local machine and therefore jobs involving excel files required to run as localhost?

Announcement

Unanswered posts

#1 2009-02-18 16:10:42

Error finding excel files

#2 2009-02-18 23:22:50

Re: Error finding excel files

#3 2009-02-18 23:36:23

Re: Error finding excel files

Board footer