FileNotFoundException when using tOutputDelimited after a tFixedFlowInput
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.