topic Re: Macro is not working while refreshing task from QMC in QlikView

Macro is not working while refreshing task from QMC

nagarajupinnibo — Mon, 28 Apr 2014 12:40:20 GMT

Hi,

I created sample procedure to update value in database.. I need to run macro after every post reload..

I called my macro under document properties->triggers->on post reload. Here, Iam calling run macro with name as "updatestatus'.

And, I selected security options as "system access" and "Allow system access" under current local security.

While doing manual reload, my macro is working fine and value is updated in database.

But, when Iam refreshing task from QMC, reload is working fine but my macro is not working..

In QMC ,under system-> setup, I enabled "Allow macro on server" and "Allow unsafe Macro execution on server" check boxes.

While refreshing task, Macro is not working..

Please provide solution for it..

Thanks

Nagaraju

jerrysvensson — Mon, 28 Apr 2014 12:44:46 GMT

A standard Publisher job will not run Macros. See Reference manual.

Workaround is to use "batch" reload instead.

For instance qv.exe /r app.qvw

You can use an external program task to do this.

Anonymous — Mon, 28 Apr 2014 12:46:34 GMT

Hi Nagaraju,

Macros won't run on QMC.

To run macros, you need to create a batch file and run the application through it.

You can run batch files thought external tasks on QMC.

Hope this helps.

Thanks

R N

nagarajupinnibo — Mon, 28 Apr 2014 12:57:08 GMT

Hi Jerry,

Can u please provide some sample document.. Iam unable to find the answer for it..

jerrysvensson — Mon, 28 Apr 2014 14:34:25 GMT

Any app will do.

To reload a QlikView app you can use commandline: c:\program files\qlikview\qv.exe /r yourapplication.qvw

The path to qv.exe might be another on your installation.