Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am receiving below error while loading qvw through qmc where section access implemented (it is working well in local machine).
Error: Document open call failed. The document might require username and password.
Information: Attempted to load the document without data.
Error: The document failed to open. Bad Username and password is the most likely cause of this problem.
I have added server account (user and password) while creating task under reload tab. But still i can see this error and the same account is available in section access table as well.
Can anyone help me what would the issue here?
Thanks,
Raju S
Whatever you put in the link field isn't that important, as long as you assign ACCESS=ADMIN to the service account. Even strict exclusion, won't have any effect on a reload.
To publish your document with Section Access, you can do one of two things:
Also check whether the NTNAME value for the service account includes the domain name (like domain\account) and is spelled correctly.
Best,
Peter
On a QlikView Server, the service account running the QlikView services is the one trying to open and reload your document. Is that account present in your Section Acces table? If not, add an ADMIN entry for the service account and reload before publishing this document.
Remember, a service account is a Windows account. So it would need an NTNAME entry. Username and Password are for document security only, and have no relation to Windows accounts or Active Directory.
Thanks Peter for the information. The server NTNAME i have added in section access table. My NTNAME is different than server NTNAME.
So you mean i need to load this qvw first in my local machine then i should move it to server?
Thanks,
Raju
We have data restricted field called Store where i have added * in that entry for server NTNAME. Is it causing this issue? Other user have all values in multiple rows.
hi
The SERVICE ACCOUNT is setup while installing the Qlikview server. It is responsible for all the reload and it should always have ADMIN access.
Your NTNAME will be domain name/username . if you want to use NTNAME security you have to add it , if not and you are using user name and password it shall work fine.
if this doesn't work share your section access script. I have ran into this kind of thing some days back hopefully will able to help you out.
Whatever you put in the link field isn't that important, as long as you assign ACCESS=ADMIN to the service account. Even strict exclusion, won't have any effect on a reload.
To publish your document with Section Access, you can do one of two things:
Also check whether the NTNAME value for the service account includes the domain name (like domain\account) and is spelled correctly.
Best,
Peter
hi
please add star is *; statement before section access.
try unchecking strict exclusion if doesn't reload
regards
Pradosh
@Sure Peter, Thank you. Now receiving below error.
Thanks Peter and Pradosh. It is working now.