topic Re: QMC task not executing a qvw containing vbscript in QlikView

QMC task not executing a qvw containing vbscript

elie_issa — Fri, 13 May 2016 13:51:02 GMT

Hi All,

Please advise why when I run the qvw manually the macro script is executed successfully but when creating a QMC task and running it the task is finishing after 2 sec without error but also without running the macro and the qvw i am trying to call in my macro script is locked. Below script details :

Load Script :

LET FBreload = FBreload();

Load $(FBreload);

VBScript:

Thanks

Re: QMC task not executing a qvw containing vbscript

swuehl — Fri, 13 May 2016 16:37:42 GMT

AFAIR publisher won't execute macros.

Have you tried with an EXECUTE statement in your script?

And have you checked that security settings allow executing external scripts / system access on the server?

Re: QMC task not executing a qvw containing vbscript

elie_issa — Mon, 16 May 2016 06:45:10 GMT

Yes i have tried first to the execute statement in the script and didn't work.

Also i have adjusted the security settings to allow executing the external scripts from the qvw file but how can check the security access on the server ?

Re: QMC task not executing a qvw containing vbscript

swuehl — Mon, 16 May 2016 16:24:29 GMT

Depending on your server version, you might need to adapt an .ini file setting:

Authorizing the Script EXECUTE Statement | Qlikview Cookbook

Macro execution needs also to be authorized, AFAIR in QMC on System - Setup - YourQVServer - Security - Miscellaneous