File used by another process

[jensej]

Hi sometimes (not always) when I run my job I get this error.

I don't have the file open so what could be the problem and how can i solve it?

[Anonymous]

Regarding to the error log, the problem is that there are 2 processes opening the file at the same time​.

one possible solution is to check the 'Append existing file' button for tFileOutputExcel component as the below

[jensej]

Hi @Aiming Chen​ 

I have exactly those settings already 😕

[jensej]

Is the problem that the job don't have time to close and reopen the file? How does it work when the job works/catches error/works. Should the job open and close the file for each step? I saw this component tsleep. Could this be a solution to set somewhere so that the job has time to close the file correctly?