topic Re: Problem: Error Document open call failed. The document might require username and password. in QlikView

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

Anonymous — Fri, 20 Nov 2020 18:02:30 GMT

Hi,

I am facing following error while reloading document

I am using section access in my document and its based on DOMAIN\USERID and PASSWORD

To reload document automatically qlikview uses SERVICE ACCOUNT ,but while reloading its not able to open documnt please suggest .

logs are given below

(2014-11-13 12:48:20) Information: Entering Task Execution. (2014-11-13 12:48:20) Information: ClusterID=1 (2014-11-13 12:48:20) Information: TaskID=611c40b5-eaf5-4ead-a76c-5f9c7aa49974 (2014-11-13 12:48:20) Information: MaxRunTime=1.00:00:00 (2014-11-13 12:48:20) Information: MachineName=INPCG022 (2014-11-13 12:48:20) Information: Max attempts:1 (2014-11-13 12:48:20) Information: Current Attempt=0 (2014-11-13 12:48:20) Information: Task Dependencies are OK (2014-11-13 12:48:20) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution. (2014-11-13 12:48:20) Information: Opening "C:\QlikView\Dev\EPABX\Dashboard\EPABX-SA.qvw" (2014-11-13 12:48:20) Information: Allocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader). (2014-11-13 12:48:20) Information: Max retries:5 (2014-11-13 12:48:20) Information: Attempt:01 (2014-11-13 12:48:22) Information: Allocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=726. (2014-11-13 12:48:22) Information: Loading document "C:\QlikView\Dev\EPABX\Dashboard\EPABX-SA.qvw" (1.46 Mb) (2014-11-13 12:48:23) Information: Loading. LoadTime=00:00:00.9999808 (2014-11-13 12:48:24) Error: Document open call failed. The document might require username and password. (2014-11-13 12:48:24) Information: Attempted to load the document without data. (2014-11-13 12:48:24) Error: The document failed to open. (2014-11-13 12:48:25) Information: Closed the QlikView Engine successfully. ProcessID=632 (2014-11-13 12:48:25) Error: Document could not be opened (2014-11-13 12:48:25) Information: Closed the QlikView Engine successfully. ProcessID=632 (2014-11-13 12:48:25) Information: Failed to check in document: C:\QlikView\Dev\EPABX\Dashboard\EPABX-SA.qvw (2014-11-13 12:48:25) Error: The task "Reload EPABX SA DB" failed. Exception: (2014-11-13 12:48:25) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to check out document with path: C:\QlikView\Dev\EPABX\Dashboard\EPABX-SA.qvw (2014-11-13 12:48:25) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) (2014-11-13 12:48:25) Error: --- End of inner exception stack trace --- (2014-11-13 12:48:25) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) (2014-11-13 12:48:25) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) (2014-11-13 12:48:25) Error: --- End of inner exception stack trace --- (2014-11-13 12:48:25) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) (2014-11-13 12:48:25) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult) (2014-11-13 12:48:25) Information: Task Execute Duration=00:00:04.2811678 (2014-11-13 12:48:25) Information: TaskResult.status=Finished (2014-11-13 12:48:25) Information: Notifying all triggers of new state:FinishedWithErrors (2014-11-13 12:48:25) Information: Notifying all triggers of new state:FinishedWithErrors - completed (2014-11-13 12:48:25) Information: Saving Task Result

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

ashfaq_haseeb — Thu, 13 Nov 2014 07:59:54 GMT

Hi,

Make sure you add service account to your Section access admin account.

Let me know if that worked.

Regards

ASHFAQ

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

Anonymous — Thu, 13 Nov 2014 09:11:44 GMT

yes i have added the service account in same format as DOMAIN\ACCOUNTNAME and password too

but still its showing the same error

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

ashfaq_haseeb — Thu, 13 Nov 2014 09:15:48 GMT

HI,

Next Step add service account here.

have a look at attached image.

Let me know if that worked.

Regards

ASHFAQ

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

Anonymous — Thu, 13 Nov 2014 09:17:07 GMT

i have used ACCESS,NTNAME AND PASSWORD FOR secction access

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

Anonymous — Thu, 13 Nov 2014 09:24:26 GMT

still the same error

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

ashfaq_haseeb — Thu, 13 Nov 2014 09:27:50 GMT

Hi,

Can you send the same snapshot I send.

Even send me section access part.

Then we will move for next step.

Regards

ASHFAQ

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

Peter_Cammaert — Thu, 13 Nov 2014 09:41:08 GMT

Remove the PASSWORD field from all SA lines that have an NTNAME specification, or - for a mixed security (NTNAME and USERID/PASSWORD lines) put a star in the PASSWORD field.

In an AD environment, the best thing you can do is omit the USERID/PASSWORD columns from SA altogether. Windows will provide authentication information, not QlikView.

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

Anonymous — Thu, 13 Nov 2014 09:43:19 GMT

section access part

Section Access;

LOAD * INLINE [

ACCESS, PASSWORD, NTNAME

ADMIN, Harshal@123456, WW930\A549398

ADMIN, Atos@123, WW930\qlikview_user

USER, !7BLESSINGom, WW930\A545150

];

Section Application;

i am not able to take screen shot of i mage u sent but i hv checked the section access box

and entered

username-WW930\qlikview_user

passwd-Atos@123

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

Peter_Cammaert — Thu, 13 Nov 2014 09:47:11 GMT

As I said, remove the PASSWORD column from your SA table. It's of no use whatsoever here, because Windows will have taken care of verifying usernames and passwords. Windows will tell QlikView who the user is that tries to get into this document, and they only need to pass a security (kerberos) token to each other. The token corresponds to the NTNAME value you specify in your SA table.

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

ashfaq_haseeb — Thu, 13 Nov 2014 09:53:52 GMT

Yes Agree with Peter.

Try by removing password from you section access script.

Secondly add service account to admin group not user group.

Hope it helps

Regards

ASHFAQ

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

Thu, 13 Nov 2014 09:54:39 GMT

Hi,

this is the section access issue.if you are reloading the document through the server you need tho provide the section access parameters.

system--->user documents--->reload--->section access

der u need to provide the parameters.

or else you are reloading the applicatin through .BAT file then you need to add the section access parameters in that.Bat file

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

Thu, 04 Dec 2014 07:51:10 GMT

Hi,

I am also facing the same issue. I have the section access parameter empty but the problem is that the reload fails only rarely with the message that Document open call failed. However, on next reload, it loads successfully. I have also realized that I have still available distribution engines so it should not be an issue too

Shah

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

cerolsan83 — Thu, 21 Jan 2021 23:25:48 GMT

Could you print yout " table SA ". I have the same problem. help!!!!!!!!!!!!!!

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

cerolsan83 — Thu, 21 Jan 2021 23:27:29 GMT

could you print me a screen? oy four section access???? please!!!! help!!!!!!!!!!!