QMC task not executing a qvw containing vbscript

[elie_issa]

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

[swuehl]

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?

[elie_issa]

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 ?

[swuehl]

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