failed in task in QMC

[#1]

Dear All,

I have one task in QMC to reload data .it's start after successful of one task. While running that task it's failed ,but while opening that document in QV desktop and reloading it, it's completed successfully without any error .

I checked the bath of that document and the security and all are right .

the log show this information : 

(2017-01-15 09:25:15) Information: Starting task 'Reload of BI Product\QV_Apps\Projects\HR\Apps\HR.qvw'. Id:bd9b9592-c2ad-4515-80ed-278cf844b3d2. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2017-01-15 09:25:15) Information: Entering Task Execution.

(2017-01-15 09:25:15) Information: ClusterID=1

(2017-01-15 09:25:15) Information: QDSID=a284cc68-1c45-94f3-f2fa-52b61b6b64c2

(2017-01-15 09:25:15) Information: TaskID=bd9b9592-c2ad-4515-80ed-278cf844b3d2

(2017-01-15 09:25:15) Information: MaxRunTime=1.00:00:00

(2017-01-15 09:25:15) Information: MachineName=PASI-PIDT

(2017-01-15 09:25:15) Information: Max attempts:1

(2017-01-15 09:25:15) Information: Current Attempt=0

(2017-01-15 09:25:15) Information: Task Dependencies are OK

(2017-01-15 09:25:15) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2017-01-15 09:25:15) Information: Opening "D:\PASI BI Project\BI Product\QV_Apps\Projects\HR\Apps\HR.qvw"

(2017-01-15 09:25:15) Information: Allocating new QlikView Engine. Current usage count=1 of 4 (of type non-reader).

(2017-01-15 09:25:15) Information: Max retries:5

(2017-01-15 09:25:15) Information: Attempt:01

(2017-01-15 09:25:16) Information: Opened the QlikView Engine successfully. ProcessID=8252

(2017-01-15 09:25:16) Information: Allocated QlikView Engine successfully. Current usage count=2 of 4 (of type non-reader). Ticket number=41.

(2017-01-15 09:25:16) Information: Loading document "D:\PASI BI Project\BI Product\QV_Apps\Projects\HR\Apps\HR.qvw" (9.59 Mb)

(2017-01-15 09:25:17) Information: Loading. LoadTime=00:00:01.0000443

(2017-01-15 09:25:18) Error: Document open call failed. The document might require username and password.

(2017-01-15 09:25:18) Information: Attempted to load the document without data.

(2017-01-15 09:25:18) Error: The document failed to open.

(2017-01-15 09:25:19) Information: Closed the QlikView Engine successfully. ProcessID=8252

(2017-01-15 09:25:19) Error: Document could not be opened

(2017-01-15 09:25:19) Information: Closed the QlikView Engine successfully. ProcessID=8252

(2017-01-15 09:25:19) Information: Failed to check in document: D:\PASI BI Project\BI Product\QV_Apps\Projects\HR\Apps\HR.qvw

(2017-01-15 09:25:19) Error: The task "Reload of BI Product\QV_Apps\Projects\HR\Apps\HR.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to check out document with path: D:\PASI BI Project\BI Product\QV_Apps\Projects\HR\Apps\HR.qvw ||    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) ||    --- End of inner exception stack trace --- ||    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) ||    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) ||    --- End of inner exception stack trace --- ||    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) ||    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2017-01-15 09:25:19) Information: Task Execute Duration=00:00:03.8641711

(2017-01-15 09:25:19) Information: TaskResult.status=Finished

(2017-01-15 09:25:19) Information: Notifying all triggers of new state:FinishedWithErrors

(2017-01-15 09:25:19) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2017-01-15 09:25:19) Information: Saving Task Result

[stabben23]

Hi,

In Reload tab in Your task, tick Section Access, add service account and password where it should be, try reload again.

[Peter_Cammaert]

Your situtation is getting a bit confusing. If your service account is present in the Section Access source xlsx, then maybe your problem is simply caused by the fact that the current version of your QVS document still contains a reduced list of users in which the service account is missing. Chicken & Egg: service account needs to reload to add its own name but cannot because of no access.

If you reload the server document with QV desktop and the correct Section Access source xlsx (that includes the service account), and then place this document on the server and you initiate a QMC reload, does it work then?

Peter

[MK9885]

Use the 2nd script also in Section Access.

Adding Service account (below table) to Section Application might help.

Include your below script within the section access script and run it through qmc.

Thanks.

[satheshreddy]

Hi,

I think you have one global Admin ID use that one while scheduling the task.

                                               OR

Check once comment Section Acess Table and Reload lets see what happen.

Regards

Sathish

[Anonymous]

Hi Maeda,

Add QV Service User to section access with domain, this user must be Admin.

Then, keep in mind that, if you have exclusion and this user doesn't have related data, he won't be able to open document.

Regards!!

[#7]

I used QV services Accounts .and it's Admin .

[#8]

while commented the section Access, it's working fine