topic Re: macros not working on server in QlikView

macros not working on server

Tue, 30 Aug 2011 09:44:06 GMT

Hi All,

I have created macros within a Qlikview application. They work fine when run from the desktop client, but will not run when run from Accesspoint.

Can anyone shed any light on it? The macro is a simple export macro which writes out a few variables to a text file. The text file is located on the server itself and all paths are correct.

Thanks

Dan

macros not working on server

Miguel_Angel_Baeyens — Tue, 30 Aug 2011 09:56:15 GMT

Hi Dan,

There are a lot of posts about this issue. In the server environment, some macros will not work, according to its design. Anyway, there are two points worth noting:

Make sure you are granting System Access to your macros in the server through QEMC (System, Setup, QlikView Servers, expand and click, Seucrity tab in the right pane "Allow unsafe macro execution on server" and "Allow macro execution on server" ticked) and in the Macro editor, (Ctrl + M, bottom left drop downs)
If they are creating some filesystem object (such an excel file) make sure you are using the IE Plugin.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: macros not working on server

Tue, 30 Aug 2011 10:01:52 GMT

Hi,

Please enable the Allow unsafe macro in enterprise management console, please see the image attached

HTH

Reg,

Shubhu

macros not working on server

Tue, 30 Aug 2011 14:37:41 GMT

Thanks Miguel. It does work when used with the IE plugin rather than AJAX. This is a little dissappointing as we were trying to use zero footprint clients as a company.

macros not working on server

Tue, 21 Feb 2012 14:36:54 GMT

Hello to everybody, I'm trying

to execeute this macro on the server

Sub TEST

Dim obj

Set obj = CreateObject("WScript.Shell")

obj.Run "c:\test.bat ", , TRUE

End Sub

This Macro write a file txt on the server.

I have put this option

Make sure you are granting System Access to your macros in the server through QEMC (System, Setup, QlikView Servers, expand and click, Seucrity tab in the right pane "Allow unsafe macro execution on server" and "Allow macro execution on server" ticked) and in the Macro editor, (Ctrl + M, bottom left drop downs)
If they are creating some filesystem object (such an excel file) make sure you are using the IE Plugin.

But the macro don't run on the server.

What I must to check ?

Thanks

Oronzo

macros not working on server

Miguel_Angel_Baeyens — Mon, 27 Feb 2012 15:46:23 GMT

Hi Oronzo,

Note that macros do not behave in Server as they do in Desktop. There are some limitations to start with, and they are documented in the Reference Manual. Besides, macro code is usually executed in the computer from where it is called, so if you are clicking a button in the Plugin, the macro will execute (meaning that it will look for paths, applications and so) in the Plugin computer, not in the Server. In addition, there are some things that the Plugin is able to perform (such as object modification) but the Ajax client is not (because it does not use the ActiveX controls that only work in Windows devices)

So you can create a test.bat in your computer and try to trigger it as you are already doing, or if the file is in the Server, then use a UNC path (in the form \\Server\Folder\file.bat ) that is available to the user that is running the application.

Hope that helps.

Miguel

macros not working on server

Mon, 27 Feb 2012 15:58:03 GMT

Thank you Miguel Angel,

Reading all the post,I think it's better to use task with QLIKVIEW PUBLISHER.

Regards

Oronzo

Re: macros not working on server

Tue, 05 Mar 2013 11:23:01 GMT

Hi Miguel Angel Baeyens

It gives problem on Access point and in server it is workingg fine. In access point macro is not triggering even I have given a msgbox to display hello and this pop up is also not coming...

Please help me.

Thanks in advance

Re: macros not working on server

vinicius_siquei — Fri, 31 Jan 2014 14:27:43 GMT

Great Miguel ! You suggestion make it work fine!

Re: macros not working on server

Wed, 26 Feb 2014 17:27:29 GMT

Hi Miguel --

Could you expand on #2? Which IE plugin are you referring to? How is it used on the server?

Many thanks,

Dave

Re: macros not working on server

david_hg96 — Thu, 30 May 2019 14:49:27 GMT

Hi!

Did you solve it?

Re: macros not working on server

fallenangel6 — Wed, 24 Jul 2019 10:55:00 GMT

i'm still facing issues. unable to make macros work in accesspoint but it works fine in server. used ie plugin as well but no luck. please help. i work on Qlikview 11.2