Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
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
???
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