Section access not working with Publisher (when distributed)

Wed, 08 Jan 2014 19:43:44 GMT

We upgraded to the publisher (11.0.11440.0) and the section access is not working when document is refreshed through publisher. If the dashboard is refreshed on the server but not distributed everything works perfect, but when refreshed & distributed through publisher, only admin can open the dashboard. It fails for all other users saying "You don't have access to this doc" . In other words, the NTNAME = ADMIN can see all data, but other persons (even when access is ADMIN or USER) cannot open their dashboard. Also, when strict exclusion is unchecked, it starts working fine but not when it is checked. QlikTech support replied like the service account is not set up properly in section access (because of observation that it works when strict exclusion is unchecked) but I can't find any error. Can you please help. Below is the script & section access file.

Complete section access script:

Section Access;

LOAD ACCESS,

ACCESS_KEY,

UPPER(NTNAME) as NTNAME

FROM

(ooxml, embedded labels, table is test);

star is *;

Section Application;

Section access file:

ACCESS	ACCESS_KEY	NTNAME
USER	PLANAMERICASCOMPONENT	ELOTOUCH\SIDDHARTH.CHOUDHARY
USER	PLANAPJCOMPONENT	ELOTOUCH\SIDDHARTH.CHOUDHARY
USER	PLANEMEACOMPONENT	ELOTOUCH\SIDDHARTH.CHOUDHARY
ADMIN	*	ELOTOUCH\SID.CHOUDHARY
ADMIN	*	ELOTOUCH\QV_ADMIN

ACCESS_KEY is a field in the data.

Below are some more specifications

- Initial Data Reduction Based on Section Access
- Strict exclusion is checked
- Reload and distribute is in one single task, user type set on "All Authenticated Users"
- Service account is in local admin & QV admin group on server
- Service account is marked as admin in section access file
- Tried thorugh IE as well as chrome.
- QV Admin account has access, but no other users can’t open

- Tried replacing * with blanks & actual keys but not working

Please help!

Thanks

Re: Section access not working with Publisher (when distributed)

frank_bossuyt — Tue, 15 Apr 2014 09:54:02 GMT

under which user does the service run?

Re: Section access not working with Publisher (when distributed)

Anonymous — Tue, 15 Apr 2014 19:06:49 GMT

I do not use "strict exclusion" anymore because of this issue. To prevent unauthorized access to all data for the users who should be "strict excluded", I create dummy records for these users in the section application. They can open application but can't see anything.

Regards,

Michael

topic Re: Section access not working with Publisher (when distributed) in QlikView

Section access not working with Publisher (when distributed)

Re: Section access not working with Publisher (when distributed)

Re: Section access not working with Publisher (when distributed)