[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)
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)