QlikView Administration

[#1]

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 

[ashfaq_haseeb]

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]

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

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

[#4]

Hi Ashfaq,

I am using ACCESS and NTNAME in my Section Access.

So what should be the UserName and Password ?

Thanks

[ashfaq_haseeb]

Hi,

What is the content of field access level?

Regards

ASHFAQ

[Bill_Britt]

Hi,

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

Bill

[#7]

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

USERID           DeptName              AccessLevel   

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

padhsu             xxxxx                      ADMIN         

prbara               yyyy                       USER 

[#8]

Hi Bill,

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

Can you please elaborate ?

Thanks

[ashfaq_haseeb]

Hi use any account with admin privileges.

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

Regards

ASHFAQ

[#10]

Hi,

Can you please elaborate about Service Accounts ?

I don't have any idea

Sujeet