Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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 

1 Solution

Accepted Solutions
Bill_Britt
Former Employee
Former Employee

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

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post

15 Replies
ashfaq_haseeb
Champion III
Champion III

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
Specialist II
Specialist II

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
Author

Hi Ashfaq,

I am using ACCESS and NTNAME in my Section Access.

So what should be the UserName and Password ?

Thanks

ashfaq_haseeb
Champion III
Champion III

Hi,

What is the content of field access level?

Regards

ASHFAQ

Bill_Britt
Former Employee
Former Employee

Hi,

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

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable
Author

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

USERID           DeptName              AccessLevel   

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

padhsu             xxxxx                      ADMIN         

prbara               yyyy                       USER 

Not applicable
Author

Hi Bill,

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

Can you please elaborate ?

Thanks

ashfaq_haseeb
Champion III
Champion III

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
Author

Hi,

Can you please elaborate about Service Accounts ?

I don't have any idea

Sujeet