Execute .Net.exe in data load - nothing happens

[SimonAichmayr]

Hi guys,

I have some problems according to the execute statement.

I built an application to load an external encrypted script into qlik sense (server).

So, I did a lot of tasks to don´t get erros like:

- Turned on Legacy mode

- in settings.ini added AllowExecution = 1 & OverrideScriptSecurity=1 

- Furthermore, I created a connection to location (local on the server) where my files are.

When i type: Execute [lib://ScriptExe(srvqstd_qssimon)/QlikSenseHubCpConnector.exe]; no error occured. The program tells me that the data load was successfully but nothing happens.

I also tried a batch-file but the same result. 

I tried my application manually and it works properly. So, I believe that this problem has to be a security setting or something else....

Please help me!

Thank you in advance!

Best Regards,

Simon

[rwunderlich · Accepted solution]

It may well be that you are successfully executing the exe file.  But an EXECUTE does not return data to the script.  Execute is generally used to create a file that is then consumed by a subsequent LOAD statement. 

Based on the name "QlikSenseHubCPConnector" it looks like this program may be (or is intended to be) a Qlik Connector. If that is the case you do not use it with EXECUTE.  Instead, you install it as a Connector and invoke it using CONNECT and LOAD statements. 

I may be misunderstanding the details of what you are trying to do.  

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com