Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Not applicable

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

I am getting the below error, when I run my Reload task.

I have one sheet which contains "Section Access" script as below

Section Access;

Security:

LOAD Distinct

       Upper(AccessLevel) as ACCESS,

       'DOMAINNAME\' & upper(USERID) as NTNAME 

;

SQL SELECT *

FROM dbo.User_Access;

Error :

(2014-06-11 04:13:52) Information: Starting task 'Reload MSO Dashboard'. Id:29365970-6c74-48c4-946f-345229f9f29e. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2014-06-11 04:13:52) Information: Entering Task Execution.

(2014-06-11 04:13:52) Information: ClusterID=1

(2014-06-11 04:13:52) Information: QDSID=9e50631d-d758-48e8-3c56-6b384d23961d

(2014-06-11 04:13:52) Information: TaskID=29365970-6c74-48c4-946f-345229f9f29e

(2014-06-11 04:13:52) Information: MaxRunTime=1.00:00:00

(2014-06-11 04:13:52) Information: MachineName=D116237-002

(2014-06-11 04:13:52) Information: Max attempts:1

(2014-06-11 04:13:52) Information: Current Attempt=0

(2014-06-11 04:13:52) Information: Task Dependencies are OK

(2014-06-11 04:13:52) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2014-06-11 04:13:52) Information: Opening "\\firmwide.corp.gs.com\root\Projects\Firmwide\NY\APGQlikview\IMD\QA\Infra\MSO_DashBoard.qvw"

(2014-06-11 04:13:52) Information: Allocating new QlikView Engine. Current usage count=1 of 4 (of type non-reader).

(2014-06-11 04:13:52) Information: Max retries:5

(2014-06-11 04:13:52) Information: Attempt:01

(2014-06-11 04:13:53) Information: Opened the QlikView Engine successfully. ProcessID=5880

(2014-06-11 04:13:53) Information: Allocated QlikView Engine successfully. Current usage count=2 of 4 (of type non-reader). Ticket number=346.

(2014-06-11 04:13:53) Information: Loading document "\\firmwide.corp.gs.com\root\Projects\Firmwide\NY\APGQlikview\IMD\QA\Infra\MSO_DashBoard.qvw" (2.30 Mb)

(2014-06-11 04:13:54) Information: Loading. LoadTime=00:00:01.0000519

(2014-06-11 04:13:55) Error: Document open call failed. The document might require username and password.

(2014-06-11 04:13:55) Information: Attempted to load the document without data.

(2014-06-11 04:13:55) Error: The document failed to open.

(2014-06-11 04:13:56) Information: Closed the QlikView Engine successfully. ProcessID=5880

(2014-06-11 04:13:56) Error: Document could not be opened

(2014-06-11 04:13:56) Information: Closed the QlikView Engine successfully. ProcessID=5880

(2014-06-11 04:13:56) Information: Failed to check in document: \\firmwide.corp.gs.com\root\Projects\Firmwide\NY\APGQlikview\IMD\QA\Infra\MSO_DashBoard.qvw

(2014-06-11 04:13:56) Error: The task "Reload MSO Dashboard" failed. Exception:

(2014-06-11 04:13:56) 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: \\firmwide.corp.gs.com\root\Projects\Firmwide\NY\APGQlikview\IMD\QA\Infra\MSO_DashBoard.qvw

(2014-06-11 04:13:56) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2014-06-11 04:13:56) Error: --- End of inner exception stack trace ---

(2014-06-11 04:13:56) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2014-06-11 04:13:56) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-06-11 04:13:56) Error: --- End of inner exception stack trace ---

(2014-06-11 04:13:56) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-06-11 04:13:56) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2014-06-11 04:13:56) Information: Task Execute Duration=00:00:04.0042392

(2014-06-11 04:13:56) Information: TaskResult.status=Finished

(2014-06-11 04:13:56) Information: Notifying all triggers of new state:FinishedWithErrors

(2014-06-11 04:13:56) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2014-06-11 04:13:56) Information: Saving Task Result


Can somebody please help ?

It is very urgent.


Thanks in Advance 

Tags (2)
1 Solution

Accepted Solutions
Employee
Employee

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

Hi,

When a reload is done the service account is the user that opens the document. So, if this user is not part of section access it can't open the document.  In the below image my service account is qvpub, so I would have to have than in section access with Admin rights. Take a look at the attached document .

sa.png

Bill

15 Replies

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

Hi

If you have section access.

Then you need to go to distribution service --Advance tab --> Provide your section access admin credentials here.

Image attached.

Hope it helped.

Regards

ASHFAQ

thornofcrowns
Valued Contributor II

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

Same question as http://community.qlik.com/thread/48028

Check there for the replies if the answer of Ashfaq Mohammed isn't the solution.

Not applicable

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

Hi Ashfaq,

I am using ACCESS and NTNAME in my Section Access.

So what should be the UserName and Password ?

Thanks

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

Hi,

What is the content of field access level?

Regards

ASHFAQ

Employee
Employee

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

Hi,

Make sure that the service account that the QlikView services are running under is in section access and has admin rights .

Bill

Not applicable

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

Below are the contents of the table. You can see the AccessLevel Field.

USERID           DeptName              AccessLevel   

-------------      --------------------             --------------

padhsu             xxxxx                      ADMIN         

prbara               yyyy                       USER 

Not applicable

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

Hi Bill,

I didn't understand what you said. I am new to QlikView.

Can you please elaborate ?

Thanks

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

Hi use any account with admin privileges.

also make sure service account  even belong to admin group as suggested by bill.

Regards

ASHFAQ

Not applicable

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

Hi,

Can you please elaborate about Service Accounts ?

I don't have any idea

Sujeet