topic Re: tfiledelete Strange behaviour in Talend Studio

tfiledelete Strange behaviour

abhi90 — Wed, 04 Apr 2018 17:45:22 GMT

Hi All,

I want to delete some zip files after my Job completition process. I am taking a Path like "C:/Users/aghosh46/Desktop/SRCFILES" in the context Variable of Parent Job. and Now Passing that Value to ChildJob for File Deletions in tpostjob. Here in tfilelist giving Directory Name as context.FilePath+"/". In tfiledelete using filelist's Global Variable Current Filepath. Strange Part is when tpostjob starting that FileDeletion Child Job is failing saying Filename.zip can not be deleted. Whereas In a testJob without any contexts The Job is deleting the Zip Files.Dont know where I am missing something.

Re: tfiledelete Strange behaviour

abhi90 — Wed, 04 Apr 2018 17:46:24 GMT

@rhall, @TRF, @vboppudi

Re: tfiledelete Strange behaviour

Anonymous — Wed, 04 Apr 2018 18:08:12 GMT

I cannot reproduce the issue. Maybe remove the +"/" ?

Re: tfiledelete Strange behaviour

abhi90 — Wed, 04 Apr 2018 18:08:33 GMT

getting error some thing like in attached.One More thing in tfilelist I gave context.filepath+"/" in my testJob. In there also it is working perfectly fine. @shong

tfiledelete.JPG

Re: tfiledelete Strange behaviour

Anonymous — Wed, 04 Apr 2018 18:13:07 GMT

Also, if your parent job is passing the directory, it would more than likely pass it using "\" instead of "/." Under advanced settings in the tFileList, check "Format file path to slash(/) style"

Re: tfiledelete Strange behaviour

abhi90 — Wed, 04 Apr 2018 18:19:56 GMT

Hi @yilengli,

From My Parent job Directory passing like Value "C:/Users/aghosh46/Desktop/SRCFILES" which is in context.filepath. Now This will be a user given Path.One More thing In the FileWatcher Component tWaitforFile I am using FilePath as context.filepath+"/" which is working absolutely fine. I have tried using that settings also which U mentioned.I also removed "/" in the tfilelist Directory. Not working still. still that same error is coming

Exception in component tFileDelete_1 (J_CON_NADL_BRAND_EXTRACT_FILEDELETE)
java.lang.RuntimeException: File C:\Users\aghosh46\Desktop\SRCFILES\AVEENO_EMAIL_CAMP_SEND_OPENS_11012017_TO_12312017.zip can not be deleted.

Re: tfiledelete Strange behaviour

abhi90 — Wed, 04 Apr 2018 19:39:13 GMT

@manodwhb

Re: tfiledelete Strange behaviour

abhi90 — Wed, 04 Apr 2018 20:31:26 GMT

One thing i am not able to understand here is the Job is not taking the slash /. It is always picking the opposite one.

Re: tfiledelete Strange behaviour

vboppudi — Wed, 04 Apr 2018 20:40:51 GMT

Hi,

Please provide your job screen if possible.

Regards,

Re: tfiledelete Strange behaviour

Anonymous — Wed, 04 Apr 2018 20:46:37 GMT

It is taking the slash /, but its printing the actual path recognized by the operating system. The "/" is just a java preference because "\" is an escape character.

Re: tfiledelete Strange behaviour

manodwhb — Thu, 05 Apr 2018 05:38:01 GMT

@abhi90, you need to verify the the folder/file does have right permessionsto delete from Talend and also can you check that zip folder has not corrupted. just for your information,you need to configure below way.

Re: tfiledelete Strange behaviour

abhi90 — Thu, 05 Apr 2018 08:14:05 GMT

Hi @manodwhb, @yilengli, @vboppudi, @rhall,

I have attached my settings in this comment.Still the problem persists.

Directory.jpg
Parent_Job_FilePathContextValue.JPG
Passing_Value_to_ChildJob.JPG
tfiledelete_settings.JPG
tfilelist_settings.JPG

Re: tfiledelete Strange behaviour

Anonymous — Thu, 05 Apr 2018 09:07:07 GMT

This *could* be related to the timing of the call. Does this work if not connected to a tPostJob?

Re: tfiledelete Strange behaviour

abhi90 — Thu, 05 Apr 2018 09:15:36 GMT

Hi @rhall,

Yes when I am testing in my test job there it's perfectly working fine. Even I tried the same context settings and everything.There it is perfectly working fine.

Re: tfiledelete Strange behaviour

Anonymous — Thu, 05 Apr 2018 09:16:41 GMT

Connect it to a tPostJob in your test job and see if it fails. If it does, then you have found a bug.

Re: tfiledelete Strange behaviour

abhi90 — Thu, 05 Apr 2018 09:38:54 GMT

Hi @rhall,

Yes You are right. This is a Bug. when I connected it to my tpostjob of my TestJob It failed again. Where as FilePath is printing.

Hi @shong, @xdshi, @agershenson

Please let me know How to open this Issue in Bugtracker. I have attached settings,JobLog with this Comments.One More thing I tried tfiledelete in my SubJobs of main Job. There also it is not working.

JobErrorLog.txt
testjob_context.JPG
TestJob_contextPassing.JPG
TestJobPrint_tfilelist.JPG

Re: tfiledelete Strange behaviour

abhi90 — Thu, 05 Apr 2018 12:03:48 GMT

One More thing add over here.

When I am using tfilelist and tfiledelete in my Parent without creating a ChildJob then after 35 File Deletion same issue is coming in tfiledelete. which should not be the case.

Re: tfiledelete Strange behaviour

abhi90 — Thu, 05 Apr 2018 12:43:30 GMT

Hi All,

@shong, @xdshi, @agershenson can u let me know how to open a bug?

Re: tfiledelete Strange behaviour

abhi90 — Thu, 05 Apr 2018 13:45:13 GMT

One thing to update over here is,

My Delete Job is working deactivating other Child Jobs keeping old files. But when I am activating the SubJobs the .zip files Talend is creating in runtime tfiledelete is failing only that time.

@rhall

Re: tfiledelete Strange behaviour

abhi90 — Thu, 05 Apr 2018 14:22:32 GMT

it is happening in Talend 6.4