Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[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.
Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

2 Replies
Anonymous
Not applicable
Author

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)
Anonymous
Not applicable
Author

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