topic Issue in Using NTNAME in Section Access and reloading the application using Publisher. in QlikView

Issue in Using NTNAME in Section Access and reloading the application using 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 , the reload of the application is Failed.

But I implement the Section Access based on the USERID and PASSWORD and specify the USERID and PASSWORD while scheduling a task under Reload 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,

Chakravarthy.

Issue in Using NTNAME in Section Access and reloading the application using Publisher.

Miguel_Angel_Baeyens — Mon, 28 Feb 2011 10:03:19 GMT

Hello Chakravararthy,

You should include the NTNAME that is running the Distribution Service, so the reload pulls all records and can distribute correctly. Set the ACCESS to that NTNAME account to ADMIN and leave blank the reduction field, if any.

Hope this helps.

Issue in Using NTNAME in Section Access and reloading the application using Publisher.

Mon, 28 Feb 2011 10:59:23 GMT

Thanks for your reply Miguel. I have concatenated the NTNAME of the distribution Service as shown below .Its working fine now . Just I want to know, Is there any issue in doing like this . Please suggest.

LOAD [USERID] as NTNAME,
[ACCESS]
FROM

(qvd);
concatenate
Load * inline [
NTNAME,ACCESS
QlikViewtst,ADMIN,
];

section application;
LOAD
EMPID as NTNAME,
DEPARTMENT
FROM
[$(Path)\Users.QVD]
(qvd);

Regards,

Chakravarthy.

Issue in Using NTNAME in Section Access and reloading the application using Publisher.

Miguel_Angel_Baeyens — Mon, 28 Feb 2011 11:40:40 GMT

Hi,

There's no problem creating the Section Access from two different sources, provided they have the same fields and the information comes consequently (uppercase in both sources and so).

Hope that helps.

Issue in Using NTNAME in Section Access and reloading the application using Publisher.

Tue, 01 Mar 2011 06:05:36 GMT

Thanks Miguel,

Regards,

Chakravarthy.

Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

Tue, 30 Apr 2013 06:33:02 GMT

Hi,

Did anyone use publisher to reload and distribute?

I built something similar, and when i reload and distribute by publisher, the access works, i have the correct reduction, but the NTNAME appear to be the service account name which is used by the distribution service.

Is this a bug or section access doc should not use publisher to do reload and distribution?

Thanks.

Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

Bill_Britt — Tue, 30 Apr 2013 09:15:39 GMT

Hi nicksatch,

I don't understand your issue. The service account is used to do the reload and distribution of the document.

Bill

Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

Tue, 30 Apr 2013 09:34:36 GMT

HI Bill,

Yes, it's due to that, after the doc is distributed, in the NTFS, i have the following....

- the service account

- Authenticated Users

- System

but if i open the doc in desktop, the reduction works, the NTNAME is showing only my NT ID

but if i open from access point, sometimes the reduction works sometimes doesnt, and the NT name is always the service acct id.

Some advice i have was to create another qvw and schedule it to run to execute a copy command to move the doc to access point folder.

so, before doing that, i just want to find out if this is a bug or something else?

Thanks.

Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

Bill_Britt — Tue, 30 Apr 2013 09:38:41 GMT

I would think you have an error in the way you have section access setup. I have not seen any bugs dealing with what you are seeing. The serivce account has to be setup as Admin in section access and it should have rights to all the data.

Bill

Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

Tue, 30 Apr 2013 09:51:07 GMT

if there's a problem, i'd expect it wont work when i open in desktop.

Problem occur after the reload & distribution, so that narrow down to the publisher.

I think it's due to that we use Publisher, the service account is setup for Distribution.exe, so naturally the service account is used by publisher to reload and distribute, and therefore, we see only the service account name in NTNAME and the reduction works according to what is assigne to service account.

meaning to say, when you have a section access, we are not suppose to use the publisher to reload and distribute?

If this is not the case, do you have a reference doc on how i can setup the distribution for a section access doc?

by the way, the above explanation was given to me by a consultant, but i thought i can also check with the public.

Thanks for any comments or feedbacks.

Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

Bill_Britt — Tue, 30 Apr 2013 12:03:12 GMT

That is incorrect and if this was an issue with publisher then we would be seeing it all over. Can you post you section access code so we can look at it.

Bill

Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

pauljohansson — Mon, 07 Oct 2013 12:51:21 GMT

nisksatch, I have the exact same issue. Did you find a solution? br Paul

Re: Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

pauljohansson — Mon, 07 Oct 2013 13:05:19 GMT

Hi Bill,

I have a similar issue.

When I log on to the server and open a document. Identification works as expected via NTNAME and data reductions works fine. I can also verifiy that im correctly identifed by looking at fieldname NTNAME.

However, when accessing the same document via Accesspoint I have verified that im identified as using the Qlikview service account, consequently no data reducation takes place.

Do you have any idea how to proceed the trouble shooting? Any ideas are welcome,

I attached the section access part,

Thanks in advance, br Paul

Re: Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

Bill_Britt — Mon, 07 Oct 2013 13:19:03 GMT

You will need to make sure that your service account has rights to see all data in %CUSTOMERMARKET_ID

Bill

Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

Anonymous — Mon, 07 Oct 2013 13:37:16 GMT

Paul,

The data reduction field must be in both Section Access and Section Application. In fact, you're using NTANME as the data reduction field, which looks risky to me.

So, try section access like this (I'd also rather avoid the '%' in the data reduction field):

ACCESS:

load Distinct

upper(ACCESS) as ACCESS,

upper(NTNAME) as NTNAME,

upper(CUSTOMERMARKET_ID) as CUSTOMERMARKET_ID // for data reduction

RESIDENT TEMP;

and section application:

kolla:
Load
ACCESS as ge,
NTNAME as vem,

upper(CUSTOMERMARKET_ID) as CUSTOMERMARKET_ID // for data reduction
CUSTOMERMARKET_ID as vart
Resident TEMP;

drop table TEMP;

Regards,

Michael

Re: Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

pauljohansson — Mon, 07 Oct 2013 13:38:29 GMT

Hi Bill, Thanks for replying. I have verified that the service account have access to all the data in %CUSTOMERMARKET_ID br Paul

Re: Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

pauljohansson — Mon, 07 Oct 2013 14:17:43 GMT

Hi Michael, thank you for putting time into this. Note, that the code works for other documents. But for this specifi document, for some reason, it gets connected to the service account, and the service account only,after beeing distributed via the Publisher. br Paul

Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

Anonymous — Mon, 07 Oct 2013 14:31:27 GMT

Yes, there must be something different in the apps if one works and another doesn't. I can't help much more with it, except a recommendation - for testing, try to use "initial selection" instead of the "initial data reduction". It doesn't fix the problem but may show you something you can't see now (?)

Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

Tue, 08 Oct 2013 09:04:31 GMT

Common issue is that users implement a more complicated SA script before they even verify that a basic SA script works, and then build the SA script from that point.

Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

Tue, 12 Nov 2013 11:27:15 GMT

Hi all,

I got the same issue on version 11.2 sr 2 and sr3. Is anyone have solution? It work fine in desktop but after reload in publisher it use server account instead of NT account when open report in accesspoint...

Thanks