Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Delete Log Files Older than 20 Days

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.

Labels (1)
9 Replies
marcus_sommer

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

Not applicable
Author

Thanks for your reply,

but I have already checked that option it was not working

marcus_sommer

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

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

- Marcus

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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?

Not applicable
Author

Here is my attached Batch File

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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?

Not applicable
Author

Hi Peter,

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

marcus_sommer

You need a full-path.

- Marcus

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.