One Star

[resolved] multiple tFileOutputExcel in single job

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.
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

Re: [resolved] multiple tFileOutputExcel in single job

problem is now solved after a recent crash it seems to work again!
2 REPLIES
One Star

Re: [resolved] multiple tFileOutputExcel in single job

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)
One Star

Re: [resolved] multiple tFileOutputExcel in single job

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