topic Can't delete file after using tFileOutputExcel in Talend Studio

Can't delete file after using tFileOutputExcel

Fernandez — Tue, 10 Mar 2020 13:47:28 GMT

Hi,

Below a job very simple where :

- I read datas from an excel file

- I write transformed datas into another excel file

- I move final file to another folder.

But I get an issue that mentionned I can't delete the file into component "MoveOutputFile":

Exception in component tFileDelete_1 (BNPPF_Orders_ProcessCustomerFiles)
java.lang.RuntimeException: File C:\Users\afernandez\Documents\MySamples\BNPPF\Process\Resultat_RECALL_CTA_AUTRES2020_03_V20200306_132530.xlsx can not be deleted.

Thanks for your help

Re: Can't delete file after using tFileOutputExcel

manodwhb — Wed, 11 Mar 2020 03:26:09 GMT

@Fernandez , as part of testing create separate jobs. like I read datas from an excel file and I write transformed datas into another excel file one job and create one more job like calling the previous job using trun job and use on subjob ok from tRunjob and connect to tfiledelete component.

Re: Can't delete file after using tFileOutputExcel

Fernandez — Wed, 11 Mar 2020 10:09:37 GMT

Thanks, it's running fine !