Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi. i have a task which was working before allocating section access management. after i made a hidden script visually i started to fail. the error is this, do you know how can i fix it? (the reload works when i do it manually in desktop version in my own pc)
:
Information: Starting task ' Reload and Distribute of SalesDashCenter'. Id:f33b211f-8f25-4c39-b412-c721d617cba9. Triggered by 'TaskCompletedTrigger'. Id:540f8d5e-9cd2-4fdc-b403-899b22a963c6
(2014-12-08 10:48:06) Information: Entering Task Execution.
(2014-12-08 10:48:06) Information: ClusterID=1
(2014-12-08 10:48:06) Information: QDSID=92f624aa-4490-dbbf-9f28-69df00e98bbb
(2014-12-08 10:48:06) Information: TaskID=f33b211f-8f25-4c39-b412-c721d617cba9
(2014-12-08 10:48:06) Information: MaxRunTime=1.00:00:00
(2014-12-08 10:48:06) Information: MachineName=TFS
(2014-12-08 10:48:06) Information: Max attempts:1
(2014-12-08 10:48:06) Information: Current Attempt=0
(2014-12-08 10:48:06) Information: Task Dependencies are OK
(2014-12-08 10:48:06) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
(2014-12-08 10:48:06) Information: Opening "E:\QlikView_Dist\SalesDash.qvw"
(2014-12-08 10:48:06) Information: Allocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader).
(2014-12-08 10:48:06) Information: Max retries:5
(2014-12-08 10:48:06) Information: Attempt:01
(2014-12-08 10:48:07) Information: Opened the QlikView Engine successfully. ProcessID=4444
(2014-12-08 10:48:07) Information: Allocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=273.
(2014-12-08 10:48:07) Information: Loading document "E:\QlikView_Dist\SalesDash.qvw" (2.58 Mb)
(2014-12-08 10:48:08) Information: Loading. LoadTime=00:00:01.0001000
(2014-12-08 10:48:09) Error: Document open call failed. The document might require username and password.
(2014-12-08 10:48:09) Information: Attempted to load the document without data.
(2014-12-08 10:48:09) Error: The document failed to open.
(2014-12-08 10:48:09) Information: Closed the QlikView Engine successfully. ProcessID=4444
(2014-12-08 10:48:09) Error: Document could not be opened
(2014-12-08 10:48:09) Information: Closed the QlikView Engine successfully. ProcessID=4444
(2014-12-08 10:48:09) Information: Failed to check in document: E:\QlikView_Dist\SalesDash.qvw
(2014-12-08 10:48:09) Error: The task " Reload and Distribute of SalesDashCenter" failed. Exception:
(2014-12-08 10:48:09) 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: E:\QlikView_Dist\SalesDash.qvw
(2014-12-08 10:48:09) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2014-12-08 10:48:09) Error: --- End of inner exception stack trace ---
(2014-12-08 10:48:09) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2014-12-08 10:48:09) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2014-12-08 10:48:09) Error: --- End of inner exception stack trace ---
(2014-12-08 10:48:09) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2014-12-08 10:48:09) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
(2014-12-08 10:48:09) Information: Task Execute Duration=00:00:03.3423342
(2014-12-08 10:48:09) Information: Sending Alert mail
(2014-12-08 10:48:09) Warning: No SMTP Server found
(2014-12-08 10:48:09) Information: TaskResult.status=Finished
(2014-12-08 10:48:09) Information: Notifying all triggers of new state:FinishedWithErrors
(2014-12-08 10:48:09) Information: Notifying all triggers of new state:FinishedWithErrors - completed
(2014-12-08 10:48:09) Information: Saving Task Result
Mana,
Check this:
Problem: Error Document open call failed. The document might require username and password.
Thanks,
AS
Is section access being used in the application? If so, service account might have to be added in the section access with admin role.
i have added service account as an admin in section access management. also i made the setting in reload tab of tasks(checked the section access option and entered data needed). but it also fails to reload.
When reloads fail on server side, they sometimes imply wrong section access implementation.
The basic section access table must be in upper case(values in your table are just the way they are). Such as :
ACCESS, NTNAME, VALUEFIELD
ADMIN, TEST\SERHAN, value1
USER, TEST\USER1, value2
etc.
May help.
BR
Serhan