Server has no access to document

[mall1m]

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

[krishnacbe]

Hi,

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

[mall1m]

Yes, as far as I can see

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]

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]

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]

During QMC reload what is the error you are getting?

[mall1m]

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]

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]

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]

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"