topic [resolved] multiple tFileOutputExcel in single job in Talend Studio

[resolved] multiple tFileOutputExcel in single job

Anonymous — Sat, 16 Nov 2024 13:37:46 GMT

I currently have 2 tFileOutputExcel methods in my job working with the same file, I believe the second is failing due to a lock on the file by the first process, is this likely? if so, is there a way to work with multiple worksheets without building two different excel files?
My full error message (useless likely) (also translated by me so not entirely proper error descriptions)

Exception in component tFileInputDelimited_1
java.io.FileNotFoundException: null (The system can not find the file specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at org.talend.fileprocess.TOSDelimitedReader.<init>(TOSDelimitedReader.java:86)
at org.talend.fileprocess.FileInputDelimited.<init>(FileInputDelimited.java:166)
at test_project.import_bestelboek_csv_0_1.import_bestelboek_csv.tFileInputDelimited_1Process(import_bestelboek_csv.java:2992)
at test_project.import_bestelboek_csv_0_1.import_bestelboek_csv.runJobInTOS(import_bestelboek_csv.java:13546)
at test_project.import_bestelboek_csv_0_1.import_bestelboek_csv.main(import_bestelboek_csv.java:13433)

Thank you in advance for any assistance.

Re: [resolved] multiple tFileOutputExcel in single job

Anonymous — Mon, 28 Dec 2009 09:46:53 GMT

I'm now trying with 2 different excel files and getting the same error, here is my job.
error message incase it is slightly different:
Exception in component tFileOutputExcel_1
java.lang.NullPointerException
at test_project.import_bestelboek_csv_0_1.import_bestelboek_csv.tFileInputDelimited_2Process(import_bestelboek_csv.java:7859)
at test_project.import_bestelboek_csv_0_1.import_bestelboek_csv.tFileInputDelimited_1Process(import_bestelboek_csv.java:4298)
at test_project.import_bestelboek_csv_0_1.import_bestelboek_csv.runJobInTOS(import_bestelboek_csv.java:13206)
at test_project.import_bestelboek_csv_0_1.import_bestelboek_csv.runJob(import_bestelboek_csv.java:13107)
at test_project.kreko_0_1.Kreko.tRunJob_3Process(Kreko.java:903)
at test_project.kreko_0_1.Kreko.tFileList_1Process(Kreko.java:712)
at test_project.kreko_0_1.Kreko.tRunJob_1Process(Kreko.java:492)
at test_project.kreko_0_1.Kreko.runJobInTOS(Kreko.java:2243)
at test_project.kreko_0_1.Kreko.main(Kreko.java:2133)

Re: [resolved] multiple tFileOutputExcel in single job

Anonymous — Mon, 28 Dec 2009 14:39:28 GMT

problem is now solved after a recent crash it seems to work again!