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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Deewens
Contributor II
Contributor II

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.

Thanks by advance.

(sorry for english)

0683p000009MZnZ.png

 

0683p000009MZdB.png

 

0683p000009MZne.png

 

Labels (2)
0 Replies