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

[Anonymous]

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

[ashfaq_haseeb]

Hi,

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

Let me know if that worked.

Regards

ASHFAQ

[Anonymous]

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

but still its showing the same error

[ashfaq_haseeb]

HI,

Next Step add service account here.

have a look at attached image.

Let me know if that worked.

Regards

ASHFAQ

[Anonymous]

i have used ACCESS,NTNAME AND PASSWORD FOR secction access

[Anonymous]

still the same error

[ashfaq_haseeb]

Hi,

Can you send the same snapshot I send.

Even send me section access part.

Then we will move for next step.

Regards

ASHFAQ

[Peter_Cammaert]

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.

[Anonymous]

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

[Peter_Cammaert · Accepted solution]

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.