Section Access does not work after publisher reload

[#1]

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$);

[simondachstr]

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?

[#3]

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"

[#4]

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

Hope can find a solution for this.

[sudeepkm]

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

[SunilChauhan]

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

[simondachstr]

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.

[SunilChauhan]

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.

[simondachstr]

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

[SunilChauhan]

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

[ashfaq_haseeb]

Hi,

Opening a support case could be another option.

regards

ASHFAQ