Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sherwingranado
Contributor II
Contributor II

EXECUTE Command Failed.

Hi Community,

I have a code for executing cmd.exe to delete all existing qvd files !. There is no problem when I run it manually.

code : "EXECUTE cmd.exe /C del *.qvd;"

But whenever I run it in server, the error traced in Document Logfile

2016-05-05 11:06:01 0013 EXECUTE cmd.exe /C del *.qvd

2016-05-05 11:06:01      ERROR - EXECUTE Command Failed. AllowExecuteCommand setting violation detected.  Document: C:\Qlikview\Development\Test\Test.qvw

2016-05-05 11:06:01      Error: Script line error:

2016-05-05 11:06:01      General Script Error

2016-05-05 11:06:01      Execution Failed

This error encountered when we upgrade our server to Qlikview v12. We have no problem when running it from our previous server version Qlikview v11.

Is there any other additional or new code/syntax for deleting qvd files?

Thanks in advance.....

Labels (1)
1 Solution

Accepted Solutions
swuehl
MVP
MVP

There was a change in how QV handles the execute statement authorization. I think you  need to check the .ini setting for AllowExecuteCommand and set it to 1.

It's explained in detail in one of Rob's blog post:

Authorizing the Script EXECUTE Statement | Qlikview Cookbook

View solution in original post

4 Replies
Gysbert_Wassenaar

AllowExecuteCommand setting violation detected.

Did you enable the Can Execute External Programs option on the Settings tab in the Script Editor?


talk is cheap, supply exceeds demand
swuehl
MVP
MVP

There was a change in how QV handles the execute statement authorization. I think you  need to check the .ini setting for AllowExecuteCommand and set it to 1.

It's explained in detail in one of Rob's blog post:

Authorizing the Script EXECUTE Statement | Qlikview Cookbook

sherwingranado
Contributor II
Contributor II
Author

Yes I did enabled that option.

sherwingranado
Contributor II
Contributor II
Author

It successfully run sir.. Thank you for the help..