FileNotFoundException when using tOutputDelimited after a tFixedFlowInput

Deewens — Sat, 16 Nov 2024 02:15:20 GMT

Hello,

I want to get data from a db and then store them into an xlsx file with one file per "COD_CMP" as described in my tFlowIterate component.

First problem : storing data into xls or xlsx file take realy too long. I got almost 138 000 rows from my DB and it'll take between 9 and 10 hour to store all data into an xls or xlsx file. Because the storing is doing one by one or idk why.

So, I tried to store it into a csv file which is much faster. And then after I want to re-store everyting into an xls (which will be quick because it won't be line by line). That's the only way I found to have enough performance for my job.

But, I got a problem as described in screenshots. When I'm store data into the csv file, at some point, the job stop and I got an Exception FileNotFoundException which tell me that my file is already used by another process. But it's not. I searched all the day to solve that, but I can't find any solution.

So, i'm looking for a solution for my second problem, or by miracle, my first if you have a best solution.

Thanks by advance.

(sorry for english)

topic FileNotFoundException when using tOutputDelimited after a tFixedFlowInput in Talend Studio

FileNotFoundException when using tOutputDelimited after a tFixedFlowInput