topic Re: Server has no access to document in QlikView

Server has no access to document

mall1m — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Server has no access to document

krishnacbe — Tue, 06 Dec 2016 16:27:51 GMT

Hi,

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

Re: Server has no access to document

mall1m — Tue, 06 Dec 2016 16:36:26 GMT

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

;

Re: Server has no access to document

krishnacbe — Tue, 06 Dec 2016 16:42:37 GMT

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

Re: Server has no access to document

mall1m — Tue, 06 Dec 2016 16:49:07 GMT

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

Re: Server has no access to document

krishnacbe — Tue, 06 Dec 2016 17:02:46 GMT

During QMC reload what is the error you are getting?

Re: Server has no access to document

mall1m — Tue, 06 Dec 2016 20:19:52 GMT

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

Re: Server has no access to document

krishnacbe — Tue, 06 Dec 2016 20:28:07 GMT

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.

Re: Server has no access to document

mall1m — Tue, 06 Dec 2016 21:35:17 GMT

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 )

Re: Server has no access to document

krishnacbe — Tue, 06 Dec 2016 21:46:50 GMT

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"

Re: Server has no access to document

mall1m — Mon, 12 Dec 2016 13:42:58 GMT

Ok many thanks

I will provide these information to the customer and confirm if it solve the problem

Regards

Nicolas