Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

mall1m
New Contributor III

Server has no access to document

Dear All,

I'm facing problem with a customer install

On an existing application, we added a security based on section access

- if I reload manually the document and save it, the server has no more access to the document and can't reload it

- if I reload WITHOUT security, save it, enable security, save again WITHOUT reoading, then the server is able to reload the document

There is a problem with qlik server account

I checked file permission and everything seem correct

I also checked the if the local admin account used to launch services was in QlikView and ADmin group and everything seem ok

do you have any idea of where the problem should be located ?

Thanks in advance

Labels (1)
10 Replies
krishnacbe
Valued Contributor III

Re: Server has no access to document

Hi,

Did your Section access code has Qlikview Service/Functional ID added.

mall1m
New Contributor III

Re: Server has no access to document

Yes, as far as I can see

Capture.PNG

I tried removing it as I thought it was useless but it didn't change anything.

below is the code of the section access & the security bridge

I had to do several change in security without enough time to check

SECTION ACCESS;

STAR IS *;

ACCESS:

LOAD ACCESS,

    NTNAME,

    COMMERCIAL_SECU&'|'&GROUP as AUTHID

FROM

[$(VS_REP_RACINE)$(VS_REP_FICHIERS_SOURCES)Security\COMMERCIALE_SECU.xlsx]

(ooxml, embedded labels, table is RESP_COM);

/*Partie Application pour réduire les données*/

SECTION APPLICATION;

SECURITY_BRIDGE:

LOAD DISTINCT

    Upper( Replace( [Nom inspecteur] ,' ', '_') )&'|'&if(Format <> 'VRAC','HORS_VRAC',Format) as $AuthID,

    Upper( Replace( [Nom inspecteur] ,' ', '_') )&'|'&if(Format <> 'VRAC','HORS_VRAC',Format) as AUTHID

Resident FAITS

;

Concatenate(SECURITY_BRIDGE)

LOAD DISTINCT

    Upper( Replace( [Nom inspecteur] ,' ', '_') )&'|'&if(Format <> 'VRAC','HORS_VRAC',Format) as $AuthID,

    Upper( Replace( [Nom inspecteur] ,' ', '_') )&'|'&'*'                                    as AUTHID

Resident FAITS

;

Concatenate(SECURITY_BRIDGE)

LOAD DISTINCT

    Upper( Replace( [Nom inspecteur] ,' ', '_') )&'|'&if(Format <> 'VRAC','HORS_VRAC',Format) as $AuthID,

    '*'                                          &'|'&if(Format <> 'VRAC','HORS_VRAC',Format) as AUTHID

Resident FAITS

;

krishnacbe
Valued Contributor III

Re: Server has no access to document

Without adding service account to section access code, dashboard will not reload in QMC.

What is the problem, reload fails in QMC or you are unable to open the dashboard after successful reload

mall1m
New Contributor III

Re: Server has no access to document

reload fails in QMC if I previously reload and saved it with my own account (with security activated)

I'm always able to open the qvw

krishnacbe
Valued Contributor III

Re: Server has no access to document

During QMC reload what is the error you are getting?

mall1m
New Contributor III

Re: Server has no access to document

right now, I don't have access to the server anymore

there was the following error in the server log:

"Error: Document open call failed. The document might require username and password"

I remind the server also tried to open the application without data

krishnacbe
Valued Contributor III

Re: Server has no access to document

Are you sure the Qlikview service account is added and reloaded in your local machine who has admin access. Verify the NTNAME of service account in section access code and the service account running the QMC.

mall1m
New Contributor III

Re: Server has no access to document

I checked this point but I wasn't 100% sure it was ok

>> Qlik services are set up with a local administrator ".\administrator

the server machine name is SRVQLK

>> in the access spreadsheet, the local admin SRVQLK\administrator is given full right

for me SRVQLK\administrator is the same as .\administrator on the server SRVQLK but i'm not sure

(Krishnapriya Arumugam thanks for the time you spend trying to help me )

krishnacbe
Valued Contributor III

Re: Server has no access to document

You are welcome Nicolas.

Yes this matters a lot related to Section access.

First the Document must be opened by the Service account that is used to run the Qlikview services.

As per your message SRVQLK user needs access to open your dashboard. But you haven't provided it in section access part and you cant provide as it is Local machine administrator. Check with your System Administrator to reconfigure the Services with "DomainName\QlikViewAdm"