topic Re: Delete Log Files Older than 20 Days in QlikView

Delete Log Files Older than 20 Days

Tue, 07 Oct 2014 08:50:33 GMT

Hi,

I am not able to delete the log files when run the execute command from the Script editor window.I think so this due to some security problem???

But when i run the batch file manually,it is working fine.

marcus_sommer — Tue, 07 Oct 2014 10:45:02 GMT

Within the user properties is the tab security with several options by accessing external files. I think you will need enable the third option.

- Marcus

Tue, 07 Oct 2014 11:01:33 GMT

Thanks for your reply,

but I have already checked that option it was not working

marcus_sommer — Tue, 07 Oct 2014 11:10:57 GMT

Maybe your execute-statement isn't proper - it should looks like these example:

Execute cmd.exe /C "D:\YOURPATH\ftpDownloadCurrentMonth.bat";

- Marcus

Peter_Cammaert — Tue, 07 Oct 2014 11:12:18 GMT

Do you get an error or is it simply doing nothing when launch the EXECUTE statement?

How do you execute this command in your script?

Tue, 07 Oct 2014 11:15:29 GMT

Here is my attached Batch File

Peter_Cammaert — Tue, 07 Oct 2014 11:30:41 GMT

Is this second batch file also failing to work when launched from inside a QV script, but ok when launched from the command line?

What is the syntax of your EXECUTE script statement?

Tue, 07 Oct 2014 11:32:53 GMT

Hi Peter,

Execute Cmd.exe /C "DeletingLogs.bat";

marcus_sommer — Tue, 07 Oct 2014 11:38:32 GMT

You need a full-path.

- Marcus

Peter_Cammaert — Tue, 07 Oct 2014 11:40:29 GMT

If this last EXECUTE fails to work, it's probably because of the nested double quotes in the batch file.

..."cmd /c IF @isdir == False xcopy @path ".\Logs1" /D /E /C /R /I /K /Y"

FORFILES has a technique to translate these into their hexadecimal representation.