topic Re: Upgrade to version 12 now EXECUTE Command Fails in QlikView

Upgrade to version 12 now EXECUTE Command Fails

Wed, 25 Nov 2020 16:16:04 GMT

I have a QlikView application that has an execute command that now longer will run in the QMC.

I have chagned AllowExecuteCommand=1 in C:\Windows\System32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch\settings.ini and restarted all the services but still it fails.

I have also tried to run it manually on the server and I changes the User Prefrerences Security and Checked Script(Allow Database Write and Execute Statements.

And I get this error when I try to run in manually:

General error

Execute QVSManagerBatch.exe clean -server=qlikview -caltype=named -days=30

Any ideas how to get this to run fine from the QMC?

Re: Upgrade to version 12 now EXECUTE Command Fails

yurigodoz — Tue, 19 Sep 2017 16:13:27 GMT

After searching across a community and finding no solution, decide to "tweak" the server.

I found a "Settings.ini" file in the path C:\Users\USER\AppData\Roaming\QlikTech\QlikViewBatch.

Yes, in the folder of the user running the service.

In my case solved the problem.

Re: Upgrade to version 12 now EXECUTE Command Fails

markodonovan — Mon, 16 Oct 2017 09:57:46 GMT

Hi Dana,

I had the same problem after upgrading to 12.10 SR8.

One solution I found was to execute the command using "cmd /c" :

EXECUTE "mkdir test" -- would give a general error.

EXECUTE cmd /c "mkdir test" -- would work ok.

Mark