Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Failed to open the document

Hi,

I have implemented the section access in my qlikview document. The Qlikview server account is already part of the users table in section access and is admin. When I reload the document, the qlikview service account is able to open the document

In the QMC distribute tab of the task, I have selected all users. When I reload the document and try to access it on web,  I get an error message that Failed to open the document. You dont have access to this document

I have also added the AD usergroup to the security of the document. Can someone please guide me how to fix this

Shah

8 Replies
Not applicable

Re: Failed to open the document

Hi,

You are facing 'Failed to open' means user is not authorized for this app.

can you send your section access code.

Regards

Vimlesh

Not applicable

Re: Failed to open the document

Tthe same user is able to open the same document using Qlikview client. Only not able to view it using web. I believe that if it was section access problem, the user will not be able to access it at all whether using Qlikview client or web/accesspoint

awhitfield
Esteemed Contributor

Re: Failed to open the document

Use process of elimination, comment out the section access script, reload the qvw. Redistribute and get the user to try again. That way you know if it's section access.

Not applicable

Re: Failed to open the document

Yes. it's section access in the sense that all non section access documents can be viewed on web. However there is a problem. The users that are trying to view this section access implemented document on web can open it using qlikview desktop client. However, they are not able to view it using access point. So If they can access it using Qlikview client, why not web. Below is what I have tried

1) Qlikveiw service account is part of the section access table and is able to open the document and is admin in section access

2) In QMC task properties--> distribute option, I have selected all users

3) I have added the AD group all users to the security of the document

What else am I messing so that users are able to view the document on web

Shah

awhitfield
Esteemed Contributor

Re: Failed to open the document

Hi Syed,

Go into Document Properties > Opening Tab, ensure that 'Initial Data Reduction on Section Access' and 'Strict Exclusion and both unticked. Re distribute etc and try again.

Not applicable

Re: Failed to open the document

Hi,

Yes, removing section access solves it but I want to do it with section access. The problem is that I can view it fine on Qlikview client but not on web. If my user was not in the section access user able, then I would not be able to access the file at all

The problem is that on the same machine, using my AD user, If I open the file on Qlikview client, it opens. If I open it on web, I get an access issue. I can view other non section access files fine

Any idea how to fix this?

Shah

bbs
Contributor

Re: Failed to open the document

Would recommend checking out the Design Blog posts regarding Section Access: Qlik Design Blog

I do not understand your use case here in that you are setting All Users on Distribution, but you are using Section Access as well, this combination does not make sense, as All Users means anyone has access, and You Section Access table then must contain a record for every user in that case in order for things to work properly.

Regards,

Brett

Not applicable

Re: Failed to open the document

You are right. I am distributing to all users to make sure that section access is the only security checking the user access. Because I am getting this access issue, I am debugging it and have disabled other things that might block my access. Eventually I will change it back to a certain group of users once I resolve the section access issue

At the moment, my issue is that I have loaded my user into section access user table and I can view it using qlikview client but not web. I do have a named cal so I should be able to open all documents. I can open all other documents that do not have section access