topic Re: Dynamic update - add users to QV Admins on which server? in QlikView

Dynamic update - add users to QV Admins on which server?

dgreenberg — Tue, 28 Apr 2015 13:26:49 GMT

We have 3 servers 1 Qlikview, QVWS and QMC.

Which server(s) do the users need to be added to as members of the QV Admin Group?

Also if we don't add them to the QMC server are there any security concerns about the users being members of the QV Admin group?

I know it won't affect their access defined in Section Access.

Thanks

Dan

Re: Dynamic update - add users to QV Admins on which server?

awhitfield — Tue, 28 Apr 2015 13:34:13 GMT

Hi Dan,

Strictly speaking, only the Qlikview Service user needs to be a member of the Qlikview Administrators group. However is you are using this to allow AD access rights to our Qlikview Files, then it only applies to the server on which the actual dashboard files reside.

Andy

Re: Dynamic update - add users to QV Admins on which server?

dgreenberg — Tue, 28 Apr 2015 14:12:17 GMT

Thanks.

I am still having trouble getting Dynamic update working. All of the document and server settings are correct.

Even just the dynamic update statement seems to do nothing when I hit it from the Access point. Ajax, IE Plugin or even fat client.

It only works when I run it local. I will have to double check everything once the web server comes back - unfortunately it's down at the moment which makes it a little tough to trouble shoot .

Thanks

Dan

Re: Dynamic update - add users to QV Admins on which server?

awhitfield — Tue, 28 Apr 2015 15:24:43 GMT

Hi Dan,

never played with Dynamic Update before.... but had a go with downloaded example of the community, and it only works from the access point when I ticked, QMC>System>Setup>Security - Allow Dynamic data Update. Have you got this ticked?

Andy

Re: Dynamic update - add users to QV Admins on which server?

Tue, 28 Apr 2015 15:50:25 GMT

Hi Dan,

to ensure the proper functioning of the " dynamic update", you have to check:
1) enable the checkbox "Enable dynamic data update" of qvw, in Document Properties> server
2) on the server must be enabled entries
"Allow dynamic data update"
and, if it runs the command with macros, also
Allow macro execution on server
Allow unsafe macro execution on server
3) the server must be 11 sr1 or later. Previous versions required a specific license

4) server configured to use NTFS. Does not work with DMS.

Alex

Re: Dynamic update - add users to QV Admins on which server?

dgreenberg — Tue, 28 Apr 2015 20:25:55 GMT

Yes all the settings in the document and Server are set to allow Dynamic update.

I have an update - it works for me from the Fat client but not Ajax or IE Plugin.

Alessandro -

Server is 11.20.12235.0

As far as I can tell it's NTFS not sure what DMS means.

All settings for Macros and allow dynamic update are correct.

Re: Dynamic update - add users to QV Admins on which server?

dgreenberg — Thu, 30 Apr 2015 13:57:30 GMT

Another update on this weird behavior.

The Fat client sporadically works for me when opening the document in the server.

IE via plugin worked briefly yesterday but then stopped.

This is frustrating I need to get this figured out.

Thanks

Dan

Re: Dynamic update - add users to QV Admins on which server?

Mon, 04 May 2015 14:27:54 GMT

could be related to the command.

What kind of operation do you run in dynamic update command? insert, delete or update?

In update and delete operations you should always specify a where clause

Alessandro

Re: Dynamic update - add users to QV Admins on which server?

dgreenberg — Mon, 04 May 2015 14:43:17 GMT

All of the Dynamic Update commands Insert, Delete and Update are sporadic. If one works they all work for me.

They always work locally from my QV Fat client.

They sometimes work when opening in the server from Fat client and sometimes work when opening in IE 11 with the plugin from the Access Point.

I see no mention of it requiring a later service release but I am going to try that.

The server is Windows 2012 and we are on QV 11.20 SR5. I am going to go to SR10 or SR11 and see what happens. The only thing in the release notes that may indicate it may help is SR6 says it supports Windows Server 2012 R2.

Thanks

Dan

Re: Dynamic update - add users to QV Admins on which server?

Tue, 05 May 2015 15:52:51 GMT

Hi Dan,

I worked with dynamic update function since qlikview 9. I think it's no a service release problem.

Could you try the simple qvw attached? I'm sure that this one work fine with IE11 (plugin and also full browser) + QVS 11.2 sr8.

Alessandro

Re: Dynamic update - add users to QV Admins on which server?

dgreenberg — Wed, 06 May 2015 13:47:25 GMT

Thank you for the response - unfortunately it didn't work.

The reason I think the SR update will help is SR6 specifically mentions Windows 2012 Server support and that is what we are using.

Via plugin

Macro fails with error

Button action does nothing

Via Chrome

macro does nothing

button does nothing.

Re: Dynamic update - add users to QV Admins on which server?

dgreenberg — Mon, 11 May 2015 12:15:15 GMT

Qlikviews canned response is:

The intended usage of Dynamic Update allows a QlikView Administrator to:
• feed limited amounts of data in to a QlikView document
• from a single source
• without running a reload of the document

There are scenarios where Dynamic Update is not supported. Dynamic Update is not intended to be implemented:
• by the end users
• through the clients connecting to the QlikView Server (AJAX, IE Plugin
• In a QVS cluster

Please can we hear from those that have it working so I can go back to QV and say it does work and we need to figure out why it's not working for us.

Re: Dynamic update - add users to QV Admins on which server?

dgreenberg — Thu, 14 May 2015 19:36:30 GMT

Qlikview confirmed it can work but we may have other issues because we are running in a clustered environment. Has anyone implemented a good solution for notes?

Re: Dynamic update - add users to QV Admins on which server?

dgreenberg — Thu, 14 May 2015 19:37:22 GMT

Alessandro Qlik was able to confirm your solution works so it's definitely my environment IMHO the SR.

Re: Dynamic update - add users to QV Admins on which server?

dgreenberg — Thu, 18 Feb 2016 21:02:51 GMT

Working with Qlik Support we determined this is a bug in QV 11.2 SR5 where Dynamic Update doesn't work but does in later SRs.