topic Re: Want to Execute .Bat in load Script in Qlik sense in Integration, Extension & APIs

Want to Execute .Bat in load Script in Qlik sense

Anonymous — Thu, 16 Mar 2017 10:01:23 GMT

I have made changes in System.ini

[Settings 7]

StandardReload=0

OverrideScriptSecurity=1

and restarted server .

But Still it is not working it gives following error : EXECUTE statement not available in this script mode

Thanks

Re: Want to Execute .Bat in load Script in Qlik sense

arockiyaselvana — Thu, 16 Mar 2017 10:49:45 GMT

Hi Neeraj,

Can you pls care to elaborate what kind of operation you are trying to perform here?

If everything done as the this link, Execute command should work.

The command I used in the script is:

EXECUTE <full path to bat file.bat>

e.g: EXECUTE C:\Users\G\Documents\Qlik\Sense\Apps\Backup.bat;

Re: Want to Execute .Bat in load Script in Qlik sense

Anonymous — Thu, 16 Mar 2017 11:28:48 GMT

Hi ,

We have followed same same link

Please not that ,i am not using Qlik sense desktop ,i am using Qlik sense hub

I Have tested in desktop it is working fine ,but it is not working in HUB

Please find the below snapshots .

Thanks for your reply

Re: Want to Execute .Bat in load Script in Qlik sense

arockiyaselvana — Thu, 16 Mar 2017 11:29:52 GMT

For Qlik Sense Server, Pls refer the following link:

Disabling standard mode

To be honest, you have to be extreme careful to do this. And Please dont forget all the Caution messages in Qlik Help site.

Re: Want to Execute .Bat in load Script in Qlik sense

Anonymous — Thu, 16 Mar 2017 11:36:05 GMT

Have you tried to execute .bat file on Qlik Sense Server.

Re: Want to Execute .Bat in load Script in Qlik sense

arockiyaselvana — Thu, 16 Mar 2017 11:42:30 GMT

Nope. I have tried this in Desktop only. So I cant comment any results in Server.

Re: Want to Execute .Bat in load Script in Qlik sense

Anonymous — Thu, 16 Mar 2017 11:43:02 GMT

Thanks ,i have done by changing in QMC Engines

Re: Want to Execute .Bat in load Script in Qlik sense

Thu, 25 May 2017 16:24:31 GMT

Hello Neeraj,

Can you please provide the change details that you made in the QMC Engines.

Because i am having the same problem but not able to find the solution.

Thanks,

Prerak shah

Re: Want to Execute .Bat in load Script in Qlik sense

konrad_mattheis — Fri, 26 May 2017 12:31:32 GMT

Hi,

you can use that connector. The compiled version will be soon on qlik market.But you can compile your own version.

GitHub - konne/qlik-connector-psexecute: Qlik Connector to Execute PS Scripts

bye Konrad

Re: Want to Execute .Bat in load Script in Qlik sense

dvdbly01 — Tue, 19 Sep 2017 14:18:48 GMT

Hi Prerak,

It seems you have to go to the QMC, in the "CONFIGURE SYSTEM" pane, "Engines" section:

There, you open the Engine needed and untick the "Standard Mode" box:

All the attempts I made to comply with instructions going through the Settings.ini file failed!

Incidently, we are running Qliksenseserver11.11.2.

Regards,

David