Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
poojask123
Partner - Creator
Partner - Creator

Failed to open document. Access point error

Hi Guys,

I am trying to access a qvw on Access point which has section access implemented. I have NT authentication for the users in my section access script, which looks like below:

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, COUNTRY

    ADMIN, DOMAIN\USER1

    ADMIN, DOMAIN\USER2, *

    USER, DOMAIN\USER3, UK

];

Section Application;

test:

LOAD * INLINE [

    Data, COUNTRY

    10, IN,

    20, UK

    30, AU

    40, CH

];

I have enabled strict exclusion in the properties. I provided username,pwd for reload in QMC (I gave user2). When i try to access with user1's login, i get an error "FAILED TO OPEN DOCUMENT, YOU DONT HAVE ACCESS TO THIS DOCUMENT".

I saw a few post and tried to do a reload and deleted .shared, .meta files. But nothing helped.

I am able to see the app with the other 2 users ( User2 and User3). Only user1 is getting this error. I want User1 to have access to all Conutry data.

Can someone plz help ?

Regards
Pooja

14 Replies
Gysbert_Wassenaar

Try adding a comma after USER1 in your section access table.

LOAD * INLINE [

    ACCESS, NTNAME, COUNTRY

    ADMIN, DOMAIN\USER1,

    ADMIN, DOMAIN\USER2, *

    USER, DOMAIN\USER3, UK

];


talk is cheap, supply exceeds demand
poojask123
Partner - Creator
Partner - Creator
Author

Hi Gysbert,

I added the comma but no luck.

Gysbert_Wassenaar

Does USER1 have ntfs read access to the .qvw file?


talk is cheap, supply exceeds demand
poojask123
Partner - Creator
Partner - Creator
Author

I have set the authentication mode as NTFS in QMC. I am not sure how do i check if this User1 have read access to the .qvw. Can you please help ? I am not well aware of things on QMC. I guess its something to be done here. But not sure where ?

Capture.PNG

Gysbert_Wassenaar

Yes, that's fine. But does that user have ntfs read privileges to the .qvw file stored on the filesystem of the server where Qlikview is installed?


talk is cheap, supply exceeds demand
poojask123
Partner - Creator
Partner - Creator
Author

Yes the user has full access to view the document. The strange thing is, when i give a * (for the data access) or a any value (IN,UK,AU or CH) for this user, the user is able to view the dashboard with respective data. Its only then I leave it blank I get this error. How do I handle the script when I have to give this User access to all the data ?

Gysbert_Wassenaar

Which version of Qlikview are you using?

Have you tried setting the Star variable:

Star is _all_;

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, COUNTRY

    ADMIN, DOMAIN\USER1, _all_

    ADMIN, DOMAIN\USER2, *

    USER, DOMAIN\USER3, UK

];

Section Application;

test:

LOAD * INLINE [

    Data, COUNTRY

    10, IN,

    20, UK

    30, AU

    40, CH

];


talk is cheap, supply exceeds demand
poojask123
Partner - Creator
Partner - Creator
Author

QLikview desktop version 11.2 SR 13

and server version 11.2 SR 12

philipp_kunz
Partner - Creator II
Partner - Creator II

Hi Pooja,

the Problem is that DOMAIN\USER1 has 'BLANK' as value that he is allowed to see.

The Value 'BLANK' says, he might not see anything!

If you are only restricting on one reduction field (COUNTRY), then you should adapt your security to this:

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, COUNTRY

    ADMIN, DOMAIN\USER1,*

    ADMIN, DOMAIN\USER2,

    USER, DOMAIN\USER3, UK

    USER,,IN

    USER,,AU

    USER,,CH

];

Section Application;

test:

LOAD * INLINE [

    Data, COUNTRY

    10, IN,

    20, UK

    30, AU

    40, CH

];

According to this USER 1 sees all Countries, USER 2 has no Access (but may reload the application on QMC), USER3 sees UK

Regards