Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

poojask123
New Contributor III

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
MVP & Luminary
MVP & Luminary

Re: Failed to open document. Access point error

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
New Contributor III

Re: Failed to open document. Access point error

Hi Gysbert,

I added the comma but no luck.

MVP & Luminary
MVP & Luminary

Re: Failed to open document. Access point error

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


talk is cheap, supply exceeds demand
poojask123
New Contributor III

Re: Failed to open document. Access point error

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

MVP & Luminary
MVP & Luminary

Re: Failed to open document. Access point error

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
New Contributor III

Re: Failed to open document. Access point error

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 ?

MVP & Luminary
MVP & Luminary

Re: Failed to open document. Access point error

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
New Contributor III

Re: Failed to open document. Access point error

QLikview desktop version 11.2 SR 13

and server version 11.2 SR 12

Partner
Partner

Re: Failed to open document. Access point error

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