Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi..
Its you qlikview administrator account.
With which you start your qlikview services.
Regards
ASHFAQ
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 .
Bill
Hi Bill,
I don't see any information about QlikView in my Services.
Can you please tell me.. why ?
Hi Sujeet,
are you on qlikview server or local client machine?
you will find this in QlikView Server Machine.
Regards
ASHFAQ
Hi Ashfaq,
Can you please elaborate ?
Can you please tell me how to get this information about QlikView Services ?
Sujeet
Hi..
Go to your QlikView server.
Start windows --> run
type this command in run services.msc now qlik on letter q It will take you to QlikView services.
You can ask someone from your network team to assist you here.
Regards
ASHFAQ