topic Re: Unable to delete files in Talend Studio

Unable to delete files

kuwaryogi27 — Thu, 18 Jul 2019 08:34:02 GMT

Hello All,

I am trying to delete some json files after they are pushed into ActiveMQ in the below subjob but the files are not getting deleted.
Attached is the screenshot of the talend job please have a look.
Could you please guide me how to solve this.

Regards,
Yogesh.

Re: Unable to delete files

Anonymous — Thu, 18 Jul 2019 09:32:55 GMT

Hello,

Did you want to delete json files from your local machine after they are pushed into ActiveMQ or from MQ server?

Best regards

Sabrina

Re: Unable to delete files

kuwaryogi27 — Thu, 18 Jul 2019 09:49:05 GMT

Hello @xdshi ,

I want to delete this files from local machine.

Re: Unable to delete files

Anonymous — Thu, 18 Jul 2019 10:01:30 GMT

Hello,

Please make sure you tick on check box ("Delete File or Folder") in tFileDelete.

Best regards

Sabrina

Re: Unable to delete files

kuwaryogi27 — Thu, 18 Jul 2019 10:08:50 GMT

Hello @xdshi ,
This configuration has been done then also it's not deleting the files

Re: Unable to delete files

Anonymous — Thu, 18 Jul 2019 10:18:20 GMT

Hi Kuwaryogi27
Do you use an existing connection on tMomOutput component? If so, you should use tMomCommit to commit the change and close the connection before deleting the file. eg:
tfileList_1--onsubjobok--tMomCommit--onsubjobok-->tFileList_2--iterate--tFileDelete.

Please try and let me know if it works.

Regards
Shong

Re: Unable to delete files

kuwaryogi27 — Thu, 18 Jul 2019 10:53:01 GMT

Hello @shong ,

After doing the suggested changes still we are unable to delete the files.
Attached is the screenshot after modification.

18_7_19_1.PNG

Re: Unable to delete files

Anonymous — Thu, 18 Jul 2019 10:58:57 GMT

Hello,

Please let us know your tfilelist_2 and tfiledelete component setting screenshots.

Best regards

Sabrina

Re: Unable to delete files

kuwaryogi27 — Thu, 18 Jul 2019 12:31:49 GMT

Hello @xdshi ,
I have attached the screenshots please have a look.

tFileDelete_1.PNG
tFileList_2.PNG

Re: Unable to delete files

kuwaryogi27 — Thu, 18 Jul 2019 13:16:44 GMT

Hello @xdshi ,
If I check the Fail on error box then the job say's the file is being used you cannot delete the file.

Re: Unable to delete files

Anonymous — Fri, 19 Jul 2019 03:29:12 GMT

Hello @ykasture

Could you please try to do tfilelist-->tfiledelete in a child job and the main job calls the child job with option 'independent process' checked to see if it works?

Best regards

Sabrina

Re: Unable to delete files

kuwaryogi27 — Fri, 19 Jul 2019 12:38:35 GMT

Hello @xdshi ,
I tried the way suggested by you, but this option is still not working for me.
Below are the screenshots of the modified job.
Please have a look.

1.PNG
3.PNG

Re: Unable to delete files

kuwaryogi27 — Tue, 23 Jul 2019 04:59:54 GMT

Hello All,
Please let me know if anyone has a solution over this topic.
Regards,
Yogesh.

Re: Unable to delete files

Anonymous — Wed, 24 Jul 2019 09:27:26 GMT

Hi kuwaryogi27
Are you sure there is no other applications or program are accessing the file at the same time. In this job, only tfileinputRaw component is reading the file, for testing, remove tMOMOutput component from the job to see if tfiledelete can delete the file in the end.

Re: Unable to delete files

kuwaryogi27 — Thu, 25 Jul 2019 15:26:32 GMT

Hello @shong ,

Apologies for the late reply.
I tried the same suggested by you it did not work.
Let me explain the complete scenario:
1] JSON files are created in this particular job by reading an excel.
2] Those JSON files are fetched by tFileOutputRaw -> .. -> tMomOutput
3] Need to delete those JSON files

When the files are sent to tMomOutput the files are consumed by a JMS consumer in our application.

I have made a small configuration change in tFileDelete and selected the Fail on error checkbox.
It gave me the error that I have attached in the attachments, please have a look.

Quick questions:
1] So since the files are used by the JMS consumer is the reason to unable to delete those files.
2] I tried changing the directory from [C to D] because due to admin rights if it's not allowing to delete the files but this scenario also didn't worked.

Please guide me how can we achieve this task.

Thanks and Regards,
Yogesh.

25_7_19_1.PNG
25_7_19_2.PNG

Re: Unable to delete files

Anonymous — Mon, 29 Jul 2019 04:45:26 GMT

Hi Yogesh
"1] JSON files are created in this particular job by reading an excel."
I don't see where the json files are created in your job, maybe the problem occurs in this step, can you please show me the full screenshot of your job?

Regards
Shong

Re: Unable to delete files

kuwaryogi27 — Mon, 29 Jul 2019 12:38:52 GMT

Hi Shong,

in tJava Component the logic to read an excel and convert a row into a json file has been written.
After tJava ->onSubJobOk ->tfilelist->tfileinputraw fetches the JSON files created in a folder on the local system and pushes them to a queue.

Regards,
Yogesh.

29_7_19.PNG