topic Re: v11SR2 Publisher not working w/ Section Access in QlikView

v11SR2 Publisher not working w/ Section Access

avastani — Mon, 26 Jan 2026 18:19:17 GMT

Installed Server/Publisher on a new box.

Created a basic SectionAccess app to test Data Reduction based on guide

Reload is successful.

When I test the app with impersonation in Developer,it works fine. Copy paste the app in the Published apps folder and impersonate and it reduces data as expected for restricted users.

Tried the same with a Distribution job and the app denies access to the same restricted user.

Has anyone facced this issue before?

Re: v11SR2 Publisher not working w/ Section Access

Miguel_Angel_Baeyens — Mon, 17 Dec 2012 10:03:34 GMT

Hi,

Did you add the NTNAME account running the QlikView services as ADMIN in your section access table, with no value (not even "*") in the reduction field specified?

Hope that helps.

Miguel

Re: v11SR2 Publisher not working w/ Section Access

avastani — Mon, 17 Dec 2012 13:42:43 GMT

ADMIN account has *. V9 this works flawlessly. Same server settings for services and setup. V11 distribution does not work.

Thanks.

Amir.

=====================

Amirali Vastani

Tel: 646.773.7936

Re: v11SR2 Publisher not working w/ Section Access

Miguel_Angel_Baeyens — Mon, 17 Dec 2012 13:55:03 GMT

Hi Amir,

Then, unless all values are listed in the section access table within the reduction field, set it to a blank value rather than the "*". Make sure the NTNAME account in the form DOMAIN\ACCOUNT has all permissions to open the document and see all rows with the setup mentioned above.

Hope that helps.

Miguel

Re: v11SR2 Publisher not working w/ Section Access

avastani — Mon, 17 Dec 2012 13:56:42 GMT

No changes there. Reading from local text files as datasource. The funny part is, copy paste the reloaded app to the published directory, it works fine, no matter the filename. Apply distribution job and it doesn’t work anymore.

Thanks.

Amir.

=====================

Amirali Vastani

Tel: 646.773.7936

Re: v11SR2 Publisher not working w/ Section Access

Miguel_Angel_Baeyens — Mon, 17 Dec 2012 14:04:03 GMT

Hi Amir,

I still don't know how your section access looks like, and if you are setting the account name in the NTNAME field, and whether or not you are specifying the username in the section access part of the task.

Are you using Publisher? If so, are you authorizing the users in the task? Are you looping and reducing the file or just reloading with section access?

It's difficult to say without further elaboration. Distribution with section access works just fine with version 11 (it had some issues in the ealiest releases of v11, but the current one works all right).

Hope that helps.

Miguek

Re: v11SR2 Publisher not working w/ Section Access

avastani — Mon, 17 Dec 2012 14:08:06 GMT

To make matters simpler, I created an app from scratch with nothing but section access, and the stores for table. Applied reload, tested in Desktop, worked fine. Copy paste to the published folder, works fine. Apply distribution job and the restricted user with access = USER and NTNAME AS Domain\Username, the app does not permit access to the document.

This is the most basic app with section access we even go through in QV Developer class.

Re: v11SR2 Publisher not working w/ Section Access

Miguel_Angel_Baeyens — Mon, 17 Dec 2012 15:09:35 GMT

Does the document have licenses available assigned to users?

Miguel

Re: v11SR2 Publisher not working w/ Section Access

avastani — Mon, 17 Dec 2012 15:10:49 GMT

100 user cals available. Dynamic lease checked

Re: v11SR2 Publisher not working w/ Section Access

jchoucq — Sat, 26 Jan 2013 09:27:52 GMT

HI,

du you have any news about your problem ?

We met exactly the same problem.

After the distribution task, users can't open the document !

Best regards

Johann

Re: v11SR2 Publisher not working w/ Section Access

avastani — Sat, 26 Jan 2013 13:29:43 GMT

So yes, you have to open the doc in developer, reload it and then save and close. Then try again via publisher

-afv.

Tel: 646.773.7936

Re: v11SR2 Publisher not working w/ Section Access

Tue, 02 Apr 2013 12:15:58 GMT

Hi,

We solve the problem by removing the "*" for the admin but now data reduction is not working. As anyone the same problem with this QV version.

Kevin

Re: v11SR2 Publisher not working w/ Section Access

Fri, 28 Jun 2013 09:18:33 GMT

Hi everyone,

We too are having the same problem .

Upgrading to v11922 on our Test machine defintely broke or altered Section Access. I am testing this on identical qvws and identical section access setups, on the live server everything works fine - on the upgraded test server, reload works fine on client, but through publisher we get an 'you don't have access to this document' error. Removing the '*' entries for our 'admin reloader' login in section access seems to have fixed this.

Can we get confirmation from Qlikview that this patch altered this Section Access and that this is how it should be done now? I.e.replacing * with <blank>?

Re: v11SR2 Publisher not working w/ Section Access

Wed, 24 Jul 2013 13:49:27 GMT

We decided to revert back to v11643, and once again the admin * in Section Access is working as expected. I am convinced that v11922 does somethign to section access that broke our (rather complex) system. Replacing * with 'blank' fixed the issue for some of the dashboard but not for all of them. I hope Qlikview can investigate and confirm this issue in case we are not alone in this.

Re: v11SR2 Publisher not working w/ Section Access

Bill_Britt — Wed, 24 Jul 2013 15:52:18 GMT

Hi Sim Car,

You need to open a case with support and have them test it and see what if it is a bug.

Bill

Re: v11SR2 Publisher not working w/ Section Access

Thu, 25 Jul 2013 13:47:56 GMT

I did the upgrade with a previous section access app installed and works as usual.

Is there any security protocol updgrade with this version???

Take a look on something else on your enviroment.

Cheers

Re: v11SR2 Publisher not working w/ Section Access

avastani — Wed, 30 Oct 2013 19:47:48 GMT

The ultimate solutions was to keep the service account with no * or anything in teh reduction fields. All other data can have * or whatever the values may be.

Service account only needs a mention to be able to access the app.

Caveat, if there is a value in the reduction field that is not mapped with other reducing fields, that will get excluded from the user's view who has full access to the dashboard. happy Qliking!