topic Re: Section Access does not work after publisher reload in QlikView

Section Access does not work after publisher reload

Mon, 26 Jan 2026 18:19:17 GMT

I have a situation here where once my qvw is reloaded and distributed to publish folder the section access doesn't work anymore. This would be a non-AD environment and publisher and server are on separate servers.

My scripts are simple, please see below. Can anyone help to correct. Thanks

Section Access;
UserAccess:
LOAD USERID, 
     PASSWORD, 
     ACCESS, 
     NTNAME,
     GROUP
FROM
[..\..\Development\AccessRight\PH_AccessRight.xls]
(biff, embedded labels, table is AccessRight$);


Section Application;

AccessMatrix:
LOAD GROUP, 
     BusiUnit
FROM
[..\..\Development\AccessRight\PH_AccessRight.xls]
(biff, embedded labels, table is Matrix$);

Re: Section Access does not work after publisher reload

ashfaq_haseeb — Mon, 21 Jul 2014 09:40:26 GMT

Hi,

Is this work locally?

Did you try to provide section access admin account credential in below path.

QEMC--> System --> Setup --> Distribution service --> Advance --> In section access area provide admin account details that you use in your section access.

Regards

ASHFAQ

Re: Section Access does not work after publisher reload

Mon, 21 Jul 2014 10:01:24 GMT

Hi Ashfaq,

It works perfect locally. I have provided section access admin account for every task as per the screenshot below

Do i need to provide credentials in setup as well?

Re: Section Access does not work after publisher reload

ashfaq_haseeb — Mon, 21 Jul 2014 10:04:41 GMT

Yes,

Follow the above path suggested.

and let me know it that worked.

Regards

ASHFAQ

Re: Section Access does not work after publisher reload

Tue, 22 Jul 2014 02:03:58 GMT

I have tried your suggestion but it did not help. I can access using any users credentials locally but when access from access point the qvw can only be accessed by admins or users from one group. It does not except the rest.

If I copy the reloaded application into the publish folder, it allows all users to access.

Not sure where could be the issue.

Regards,

Vivek

Re: Section Access does not work after publisher reload

ashfaq_haseeb — Tue, 22 Jul 2014 08:40:57 GMT

Hi,

It means its authenticating issue.

Do you have publisher?

Regards

ASHFAQ

Re: Section Access does not work after publisher reload

Tue, 22 Jul 2014 09:00:46 GMT

Hi,

Yes I do have publisher. The QVS and publisher is in separate nodes.

Publisher reloads and distributes to a folder in QVS node.

Thanks

Regards,

Vivek

Re: Section Access does not work after publisher reload

ashfaq_haseeb — Tue, 22 Jul 2014 09:01:56 GMT

OK,

Do you add users wile distributing application?

Regards

ASHFAQ

Re: Section Access does not work after publisher reload

Tue, 22 Jul 2014 09:13:32 GMT

There are 2 layer security since this is not an AD environment. One is to access the access point and one is for qvw.

Users can go through the first one but just not the second.

The users list are maintained in an Excel document.

Will this be because I have strict exclusion option selected. If i don't select this users are able to log in but users will be able to see all data

Regards,

Vivek

Re: Section Access does not work after publisher reload

SunilChauhan — Tue, 22 Jul 2014 09:23:09 GMT

it will allow you

when uncheck strict exclusion.

but with this option i am also searching for solution.

Thanks

Re: Section Access does not work after publisher reload

simondachstr — Tue, 22 Jul 2014 09:25:32 GMT

Can you specify "doesn't work anymore"

What's the error message? Can you open the reloaded applications and only the distributed one causes errors?

Re: Section Access does not work after publisher reload

Tue, 22 Jul 2014 10:11:21 GMT

Hi Martin,

I am able to open reloaded applications with any users in the list but after distribution it only allows admins and does not accept other users.

After few tries the error message i get is "Failed to open document, you don't have access to the server"

Re: Section Access does not work after publisher reload

Tue, 22 Jul 2014 10:14:26 GMT

The data will not get filtered according to the user if I have strict exclusion uncheck.

Hope can find a solution for this.

Re: Section Access does not work after publisher reload

sudeepkm — Tue, 22 Jul 2014 10:22:49 GMT

you have both USERID and NTNAME. Can you please show a sample data from your section access table?

Re: Section Access does not work after publisher reload

SunilChauhan — Wed, 23 Jul 2014 05:32:31 GMT

Hi Sudeep ,

We have only NTNAme and NTNames Are Ad Groups not individual id

section access;

Load

ACCESS,

NTNAME,

FUNCTION

from Path;

Section Application;

is there any work around for this

Re: Section Access does not work after publisher reload

simondachstr — Wed, 23 Jul 2014 08:02:42 GMT

Can you make sure to include the QlikView Publisher Service account in the PH_AccessRight.xls list with ADMIN rights. I think the reduction is not working properly.

Re: Section Access does not work after publisher reload

SunilChauhan — Wed, 23 Jul 2014 08:45:37 GMT

Ya i also tried adding Service account. but i unfortunately its not working.

but strange beahviour is that its woking on other machine without publisher.

i am agree with you that rduction is not working properly. is there any other work around for this.

Re: Section Access does not work after publisher reload

simondachstr — Wed, 23 Jul 2014 09:06:06 GMT

Can you exclude the Service Account from the Access Matrix - table.

Re: Section Access does not work after publisher reload

SunilChauhan — Wed, 23 Jul 2014 09:09:21 GMT

i have tried both adding and excluding . both cases not working

Re: Section Access does not work after publisher reload

ashfaq_haseeb — Wed, 23 Jul 2014 09:34:34 GMT

Hi,

Opening a support case could be another option.

regards

ASHFAQ