Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BouwerVa
New Contributor II

EXCECUTE .BAT FILE

Hi

I am trying to execute a .bat file but keep getting an error. Please Help.

Script:

Execute cmd.exe /C C:\QlikSense Storage\6_BAT Files\Offsite Receive.bat

Error:

The following error occurred:
EXECUTE statement not available in this script mode
 
The error occurred here:
Execute cmd.exe /C C:\QlikSense Storage\6_BAT Files\Offsite Receive.bat
 
Settings.ini:
 
[Settings 7]
EnableIPv6Support=0
OverrideScriptSecurity=1
StandardReload=0
 
I did restart the "Qlik Sense Engine Service" 
Not sure what I am missing?
 
8 Replies
Partner
Partner

Re: EXCECUTE .BAT FILE

Have you tried to change the path to a LIB: reference instead of a c:/ reference?

 

It support both, but you never know...

???
Celebrating my 300 accepted solution in the Qlik Community
???
Partner
Partner

Re: EXCECUTE .BAT FILE

By the message you get it looks like you're not entered into Legacy Mode.

Check if it is active by trying to load a simple excel/csv file referring to an absolute path like c:/Test.csv
???
Celebrating my 300 accepted solution in the Qlik Community
???
BouwerQlik
New Contributor

Re: EXCECUTE .BAT FILE

Hi

I tried opening an excel file and LIB as reference but getting the error. Any other suggestions where I might have gone wrong?

BouwerQlik
New Contributor

Re: EXCECUTE .BAT FILE

Just to make sure, how would the correct “EXECUTE” script look like for LIB and Absolute Path

BouwerQlik
New Contributor

Re: EXCECUTE .BAT FILE

Partner
Partner

Re: EXCECUTE .BAT FILE

In the bottom of this page, https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu... , you will find two examples on how to call using LIB and absolute path.
???
Celebrating my 300 accepted solution in the Qlik Community
???
Highlighted
BouwerVa
New Contributor II

Re: EXCECUTE .BAT FILE

Hi

I’ve got a new problem. The script in running now but nothing happens. Even if i try to open excel it just turns and never stops but excel doesn’t open. 

BouwerVa
New Contributor II

Re: EXCECUTE .BAT FILE

On another post, that i cant find now, they talked about a tick that had to be ticked to allow external programs.

In a second post they talked about overriding the security within system.ini file which i did as seen in my first post. Where in Qlik Sense Hub or QMC to you disable the security because I think that is what is keeping my script from working