Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
neerajkumar
Not applicable

Want to Execute .Bat in load Script in Qlik sense

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

9 Replies
arockiyaselvana
Not applicable

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

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;

execute ss.PNG

neerajkumar
Not applicable

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

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

arockiyaselvana
Not applicable

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

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.

neerajkumar
Not applicable

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

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

arockiyaselvana
Not applicable

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

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

neerajkumar
Not applicable

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

Thanks  ,i have done by changing in QMC Engines

Not applicable

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

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

konrad_mattheis
Not applicable

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

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

dvdbly01
Not applicable

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

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