topic Re: Section Access not working in Publisher in QlikView

Section Access not working in Publisher

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I have applied the section Access based on NTNAME in my application. When I am scheduling the application for reload using publisher and opening it throught access point it shows error mgs 'Failed to open Document,You dont have access to this Document'

But when I implement the Section Access without the Publisher its working fine .

I want to implement the section access based on NTNAME and reload the application using the Publisher.. Can any one guide me what more I have to consider in the section access to achive this .

Regards,

ELakkian.

Re: Section Access not working in Publisher

Wed, 23 Apr 2014 06:33:39 GMT

Is the reload being done or do you get an error?

Is the account running QlikView Distribution Service added to the Section Access script?

You can´t use a group in the Section Access script for the Service account, it needs to be added as user.

Re: Section Access not working in Publisher

Wed, 23 Apr 2014 08:13:51 GMT

The reload has no errors and it is being published correctly.

the account running the distribution is added to the script as admin.

Re: Section Access not working in Publisher

Wed, 23 Apr 2014 08:20:08 GMT

If you have strict exclusion toggled on and you do not have any data associated to the account you are logging in under it will give you that message, ensure you are able to view all data as an administrator

Re: Section Access not working in Publisher

nilesh_gangurde — Wed, 23 Apr 2014 08:21:00 GMT

not sure about this.

but you can try. --- you can add your name in the security tab. screen shot attached.

-Nilesh

Re: Section Access not working in Publisher

Wed, 23 Apr 2014 08:28:55 GMT

the service account is not a group...

Re: Section Access not working in Publisher

Wed, 23 Apr 2014 08:39:59 GMT

My name is already in there with a full control

- Elakkian

Re: Section Access not working in Publisher

Wed, 23 Apr 2014 08:42:32 GMT

as an admin i have full privilege to view all data . But still the error is coming.

Re: Section Access not working in Publisher

Wed, 23 Apr 2014 08:58:24 GMT

hi felim shanaghy,

if i remove the strict exclusion then the user is also able u see all the data which is not correct..

- Elakkian

Re: Section Access not working in Publisher

Bill_Britt — Wed, 23 Apr 2014 09:12:44 GMT

Hi,

The service account has to have rights to all the data. So, lets look at the below. Being you are doing the reduction the ADMIN below will on see the following US,UK and FR. The ADMIN will not see DE. The reason is the *. If you want the ADMIN to see everything remove the start. You would also have to put the service account in here also with the LINK being Blank.

One more thing to know when the ADMIN logins into the document they are USER at that point. You are only an ADMIN when you open the document in the desktop Client.

Section Access;
Access:
Load* INLINE [
ACCESS, USERID, PASSWORD, LINK
ADMIN,ADMIN, ADMIN, *
USER, USER1, USER1, US
USER, USER2, USER2, UK
USER, USER3, USER3, FR

];

Section Application;

Sales:
LOAD * Inline [
LINK, Country, Sales
US, USA, 1000
UK, United Kingdom, 800
FR, France, 750
DE, Germany, 940
];

Bill

Re: Section Access not working in Publisher

Wed, 23 Apr 2014 09:30:10 GMT

hi Bill,

the fields for the service account is left blank . only the ACCESS, USERID is given except all are left blank only.

- Elakkian

Re: Section Access not working in Publisher

Bill_Britt — Wed, 23 Apr 2014 10:38:19 GMT

Hi,

Can you post your section access script?

Bil

Re: Section Access not working in Publisher

Wed, 23 Apr 2014 10:56:26 GMT

SECTION Access;

LOAD if(len(Access)=0,'ADMIN',Upper(Access)) as ACCESS,

UserID as NTNAME,

Upper(if(Len(trim([QCompany Code]))=0,'ALL',[QCompany Code])) as GROUP

FROM

[..\..\Data Sources\Access.xlsx]

Re: Section Access not working in Publisher

martinpohl — Wed, 23 Apr 2014 11:08:25 GMT

Don't use ALL but * (Wildcard) for unfilled QCompyna Codes

Re: Section Access not working in Publisher

ToniKautto — Wed, 23 Apr 2014 11:13:24 GMT

The NTNAME field must also be stored as UPPER case in the section access table.

Keep in mind that the reduction field will be in upper case in the section access table, which means it also must be in upper case in the data model. The reduction is case sensitive.

Does your publisher task have a reduction? Or is only a plain reload?

Re: Section Access not working in Publisher

Wed, 23 Apr 2014 11:50:24 GMT

hi tko,

Thats why i am using the upper function...

yes my task has a reduction

-Elakkian

Re: Re: Section Access not working in Publisher

Wed, 23 Apr 2014 12:04:08 GMT

Hi Elakkian,

Use the wildcard (*) character in your section access to grant full permission to yourself.

Please see attached excel file and use the script below...

star is *;

Section Access;

LOAD

Upper(Access)) as ACCESS,

UserID as NTNAME,

QCompany as GROUP

FROM

[..\..\Data Sources\Access.xlsx];

Section Application;

star is *;

Re: Section Access not working in Publisher

Bill_Britt — Wed, 23 Apr 2014 12:06:44 GMT

Hi,

My suggestion would be start off simple and get it working. Then you can add all the additional stuff and if it doesn't work it is in you code.

Bill

Re: Section Access not working in Publisher

Thu, 24 Apr 2014 06:43:04 GMT

HI Bill Britt,

Actually i did a sample with the same section access code and the excel file... its working perfectly, for other apps also its working but only for this app its not working ... i cant figure outs whats the problem which is violating the section access..

-Elakkian

Re: Section Access not working in Publisher

ToniKautto — Thu, 24 Apr 2014 07:20:04 GMT

There are three things that you can evaluate in order to resolve the issue. Please let us know if any of these resolve the issue.

1 All values in the Section Access table must be in UPPER case. Your NTNAMEs are not in upper case

2 If you use Strict Exclusion you can not use 'ALL' as wildcard value. Replace ALL with the star wildcard

3 The Star is * statement is generally not required in the script, so comment or delete them