topic Re: Failed to open document. Access point error in QlikView

Failed to open document. Access point error

poojask123 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Failed to open document. Access point error

Gysbert_Wassenaar — Wed, 20 Jul 2016 08:19:50 GMT

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

];

Re: Failed to open document. Access point error

poojask123 — Wed, 20 Jul 2016 09:41:26 GMT

Hi Gysbert,

I added the comma but no luck.

Re: Failed to open document. Access point error

Gysbert_Wassenaar — Wed, 20 Jul 2016 11:04:22 GMT

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

Re: Failed to open document. Access point error

poojask123 — Wed, 20 Jul 2016 11:11:52 GMT

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 ?

Re: Failed to open document. Access point error

Gysbert_Wassenaar — Wed, 20 Jul 2016 15:01:47 GMT

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?

Re: Failed to open document. Access point error

poojask123 — Thu, 21 Jul 2016 05:47:18 GMT

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 ?

Re: Failed to open document. Access point error

Gysbert_Wassenaar — Thu, 21 Jul 2016 06:37:56 GMT

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

];

Re: Failed to open document. Access point error

poojask123 — Thu, 21 Jul 2016 06:46:04 GMT

QLikview desktop version 11.2 SR 13

and server version 11.2 SR 12

Re: Failed to open document. Access point error

philipp_ebner — Thu, 21 Jul 2016 07:38:25 GMT

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

Re: Failed to open document. Access point error

philipp_ebner — Thu, 21 Jul 2016 07:41:37 GMT

Star is *; <------this in front of section Access, sorry , I forgot!

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

];

Re: Failed to open document. Access point error

Gysbert_Wassenaar — Thu, 21 Jul 2016 07:46:46 GMT

That explains why user2 can see everything and user1 does not get access at all. When you set the star variable to * then * means all values instead of only the listed values.

Re: Failed to open document. Access point error

philipp_ebner — Thu, 21 Jul 2016 08:31:54 GMT

Allow me to disagree a bit Gysbert.

The Problem with the "Section Access"-part of the script is that

QlikView Seperates the Section Access table from the actual "datamodel".

This is why you never "see" the section Access table in your table model Viewer.

If you write "star is * ; " in front of your section Access script, the "*" Symbol represents all listed values within the

field COUNTRY within the Section Access Part of the script.

After that QlikView builds up the Connection to the real datamodel. --> So if you only list Country UK in the section Access Part, all users are reduced to only see UK (even if they have a "*").

Best Regars Philipp

Re: Failed to open document. Access point error

Thu, 21 Jul 2016 10:53:47 GMT

Hi Pooja,

I believe you can see the dashboard in the access point, which means your section access code is correct.

But, when you are using '*' in your script, it will select all the listed values from Country column. But when you are using blank or null values for all Countries you should avoid using '*', else blank or null values will be treated as none. Hence you will get this kind of error.

Best would be use either '*' or blank for all values selection.

Can you please check if you have allocated Named CAL or DOC license to the mentioned user?

Regards,

Sakir

Re: Failed to open document. Access point error

Anonymous — Thu, 21 Jul 2016 11:02:44 GMT

Hi Pooja,

Ensure the dashboard has been allocated with sufficient document CALs in the below given location.

In QMC-->Under Documents -->User Documents-(Select the dashboard)-->Document CALs (on the right part of the screen)

Document CALs allocated to the document should be more than that the Document CALs assigned to users.