Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, We added the section access with strict exclusion. The logic is working fine on the Qlikview Desktop client. But when we deployed to Staging server the strict exclusion is not working. We got "Failed to Open a Document Access denied".
Is these any server settings needs to be update ?
Any one faced this type error before
I am facing the same problem. But in my case I don't have any limited fields/values and only wanted to enable admins to have access but not the users...so it is not a problem to turn off 'strict exclusion'. I thought the reason for the denied access could be the situation that there were no corresponding fields in section access in section application
See the manual:
"...access to the document will be denied whenever the field values in
the section access reduction fields lack matches in their corresponding section
application field."
But would be interested to know if there is another reason.
Hi,
I've faced the same problem in documents with SA. Even though we do not use Initial Data reduction in some of them.
We've resolve this issue by ticking off "Strict exclusion checkbox" even it seems to be disabled (not active).
Hope this helps.
Regards,
Andrei
You're probably mixing two things here:
Peter
Peter, if the user have both his reduction value & null, it denied ?
Hi,
You need to make sure the service account is in SA and has ADMIN rights.
Bill
Britt, I am using our staging server service account in SA and that have full Admin privileges on the staging server.
Is there any idea why other user accounr got "Failed to open the document Access Denied" error.
Hi,
Take a look at the attached qvw. If you try to login as user D you will get the error and it is because he has no data assigned to him.
Section Access;
LOAD * INLINE [
ACCESS, USERID, DATA
ADMIN, A, *
USER, B, 1
USER, C, 2
USER, D,
];
Section Application;
LOAD * INLINE [
DATA, YEAR
1, 2015
2, 2014
3, 2013
];
Britt, The example you provided looks fine. In my case the developers (testing) can access the qvw with desktop client. But we can't access the qvw on Access point.
LOAD * INLINE [
NTNAME , ACCESS, REDUCTIONFIELD
DOMAIN\SQLIKVIEW , ADMIN , <ALL>
DOMAIN\USER1 , USER , A
DOMAIN\USER2 , USER , B
DOMAIN\USER3 , USER , C
];
LOAD * INLINE [
REDUCTIONFIELD , FIELD
<ALL> , A
<ALL> , B
<ALL> , C
A, A
B,B
C,C
];
The above is the exiting SA & reduction table on environment. The reduction works fine on Desktop Client. But it won't work on the Access point.
Did you let the server reload your document before opening it in the AccessPoint?
Peter