topic Re: Execute Command in script will finish but not execute in App Development

Execute Command in script will finish but not execute

eventasm — Sat, 16 Nov 2024 17:40:21 GMT

Hi everyone,

Due to project needs I need a qliksense app to execute something like:

execute cmd.exe /c start msedge www.awebpageigottoopen.com;

This is the syntax I've followed and I've also tried with /C (caps)

I'm running a qliksense server installation and I've disabled standard mode on the QMC already, and my settings.ini looks like this:

Note: I've also tried without the StandardReload line and it won't work either.

My main problem is that when I execute my app it goes like it shows bellow:

It's in Spanish (sorry about that) but it basically says load was sucessfully finished but it hasn't opened that msedge window. I'm using the server machine so it should open it at my windows session but it won't.

Any ideas of what's going on? I really need help on this

Re: Execute Command in script will finish but not execute

Anil_Babu_Samineni — Fri, 25 Dec 2020 20:20:21 GMT

First try in command prompt if that working or not and also, These parameters you are passing not in Legacy mode since Qlik Sense is difficult to execute such external. You have to use middle tools to design such a way like Powershell..

Re: Execute Command in script will finish but not execute

eventasm — Mon, 28 Dec 2020 16:55:34 GMT

Hi Anil,

First of, thanks for your reply. I've tried creating a .bat file to call it from in the execute command but it isn't working. I've also tried just calling something like "C:\thePathInMyMachine\msedge.exe" which is one of the examples I've found on the internet and won't work either. Any other ideas?

Thanks in advance.

Re: Execute Command in script will finish but not execute

Anil_Babu_Samineni — Mon, 28 Dec 2020 19:52:02 GMT

Try this way and see, Go to Setting.ini and add this parameter AllowExecuteCommand=1

Then, Write something like this and execute? Execute "C:\thePathInMyMachine\msedge.exe";

Re: Execute Command in script will finish but not execute

eventasm — Tue, 29 Dec 2020 09:36:07 GMT

Hi again Anil,

I've done as you said and now at least we have something new to face.

After adding the new line to my Settings.ini (and restarting the services and so on) now when I launch the script it will stay "thinking" forever.

I've faced this before in another qliksense server deployment I used for testing the execute command but i thought may be it was because the machine wasn't powerfull enough to run the execute order. This new machine im using now is using 8GB RAM memo and two i7 8th gen CPUs at 1.80GHz which i guess should be enough.

Any thoughts?

Again, thank you for your help.

Re: Execute Command in script will finish but not execute

Anil_Babu_Samineni — Tue, 29 Dec 2020 10:34:08 GMT

Can you please explain what is this about, Execute "C:\thePathInMyMachine\msedge.exe"

So that i can investigate further in my environment.

Re: Execute Command in script will finish but not execute

eventasm — Tue, 29 Dec 2020 10:44:15 GMT

As I explained in the original post, the aim of this is to lauch a web browser with an url. So basically the steps i need to follow are:

1. Be able to enable the usage of execute command.

2. Be able to launch a web browser with execute command.

3. Be able to launch a web browser with an url.

I'm still stuck at step 1-2 where i can't happen to use the execute command properly.

As you can see in my last post, right now im just calling my internet explorer .exe file. So I'm doing as it follows:

Execute "C:\Program Files\Internet Explorer\iexplore.exe";

This way, I should be calling the .exe file which should open the Internet Explorer app/program.

Once I achieve this i will be able to proceed to step 3.

Hope I've explained myself properly.

As always, thanks a lot.

Re: Execute Command in script will finish but not execute

Anil_Babu_Samineni — Tue, 29 Dec 2020 11:04:55 GMT

In future, You planned to not use Qlik Sense or ?Because, we can enable this functionality by help of button to simply giving the URL. In case if you need this, I will check the possibility and come back..

Re: Execute Command in script will finish but not execute

Anil_Babu_Samineni — Tue, 29 Dec 2020 11:16:17 GMT

Additionally, I just tried this in my environment after enabled OverrideScriptSecurity=1 in settings.ini and it is working for me

EXECUTE "C:\Program Files\Internet Explorer\iexplore.exe" http://www.awebpageigottoopen.com/

What this is doing, Once QS reload from this execution

- Opened the IE browser

- Opened this URL

- Closed this browser and script reloaded

Sorry, If i still mis understading the question

Re: Execute Command in script will finish but not execute

eventasm — Tue, 29 Dec 2020 11:20:52 GMT

Yes, all other possibilities have been considered and discarded due to project needs (I'm sorry, as you may understand i can't go deeper into this) but the following have been considered and discarted:

1. Creating a windows task which would open the web with the windows task scheduler.

2. Using a button for navigation wouldn't meet project needs.

3. The only option left we thought of was execute command.

About your next message, that's exactly what it is intended to do but it isn't working in my deployment.

Is it ok if i take a look at your settings.ini? Are you using qliksense server or desktop? if you're using server, what version are you using?

Thanks.

Re: Execute Command in script will finish but not execute

eventasm — Tue, 29 Dec 2020 11:23:09 GMT

Also, did you write something else like exit script or something? or just

EXECUTE "C:\Program Files\Internet Explorer\iexplore.exe" http://www.awebpageigottoopen.com/

Re: Execute Command in script will finish but not execute

Anil_Babu_Samineni — Tue, 29 Dec 2020 11:25:26 GMT

Make sense, I have settings like in this folder.

C:\ProgramData\Qlik\Sense\Engine\Settings.ini

And paramenters like below

[Settings 7]

key = value

OverrideScriptSecurity=1

.... // There are certain for my project to executre Non SQL DB's, ..

And, I am using Windows server 2016 + QS Server Sep 2020 SR0

Re: Execute Command in script will finish but not execute

Anil_Babu_Samineni — Tue, 29 Dec 2020 11:26:16 GMT

Nothing for now in test application

Re: Execute Command in script will finish but not execute

eventasm — Tue, 29 Dec 2020 11:48:19 GMT

Did yours take a lot to open? Mine has already been thinking for 6 min straight and won't launch.

I don't know, this is driving me crazy. Let me know if im skipping any important part. I have:

Disabled standard mode in the qmc engine part.
My settings.ini looks exactly like yours (literally copied it)
My script looks exactly like yours (literally copied it).
If there's anything else you may think of that may be failing I'll be more than thankful. Could it be a problem of my deployment?

If not, thanks anyway for your time and help

Re: Execute Command in script will finish but not execute

Anil_Babu_Samineni — Tue, 29 Dec 2020 11:57:19 GMT

It was taken 30 seconds to my URL, Have you disabled all engine nodes?

Try this in desktop first and see, If that is working or not?

Re: Execute Command in script will finish but not execute

eventasm — Tue, 29 Dec 2020 16:39:20 GMT

It does work in my desktop QS.

And yes, I have it configured just as you do:

Again thanks a lot. Do you know if there's someone from Qlik I can contact with this issue or something?

Re: Execute Command in script will finish but not execute

Anil_Babu_Samineni — Tue, 29 Dec 2020 16:47:29 GMT

I should not disclose Qlik email's here. But let's see @Clever_Anjos can help?

Re: Execute Command in script will finish but not execute

Arindam_Ghoshal_13 — Tue, 17 Jan 2023 11:16:58 GMT

Hi @Anil_Babu_Samineni & @eventasm

I have facing exact same problem in qlik sense

I have created a .bat file which runs 3 python code and generate 3 xlsx file as output.

While double clicking on bat file it WORKS perfectly from server but not getting execting from Qlik Sense "Execute" statement.

I have tried multiple statements & also tried after changing settings.ini file to below configurations & restarted the services.

[Settings 7]
StandardReload=0
AllowExecuteCommand=1
OverrideScriptSecurity=1

Please help as there are few batch files in my code at mutiple sections.