Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Section access not working with Publisher (when distributed)

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:


ACCESSACCESS_KEYNTNAME
USERPLANAMERICASCOMPONENTELOTOUCH\SIDDHARTH.CHOUDHARY
USERPLANAPJCOMPONENTELOTOUCH\SIDDHARTH.CHOUDHARY
USERPLANEMEACOMPONENTELOTOUCH\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



2 Replies
frank_bossuyt
New Contributor

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

under which user does the service run?

mov
Esteemed Contributor III

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

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


Community Browser