Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

task error

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

4 Replies
amit_saini
Honored Contributor III

Re: task error

MVP
MVP

Re: task error

Is section access being used in the application? If so, service account might have to be added in the section access with admin role.

Not applicable

Re: task error

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.

Partner
Partner

Re: task error

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