reload task failed see the event log below

[SunilChauhan]

hi,

I have schedule a job on publisher and it getting failed in few second.its seems like it is not able to open file to load

2014-03-26 04:17:55	2014-03-26 04:17:58	4	700	Information	Debug: Entering CNTService::ServiceMain()
2014-03-26 04:17:55	2014-03-26 04:17:58	4	700	Information	Debug: CNTService::SetStatus(1675696, 2)
2014-03-26 04:17:55	2014-03-26 04:17:58	4	700	Information	Debug: CNTService::SetStatus(1675696, 4)
2014-03-26 04:17:55	2014-03-26 04:17:58	4	700	Information	Debug: 2 CPU cores found in 2 CPUs
2014-03-26 04:17:55	2014-03-26 04:17:58	1	300	Error	Logon: Anonymous logon failed: L.
2014-03-26 04:17:55	2014-03-26 04:17:58	1	300	Error	Account: Failed to create account IQVS_xmsd0xxx, The account already exists.

[SunilChauhan]

(2014-07-21 10:35:53) Information: QDSID=93477ff4-4431-c7d2-7160-6a7069f8dd51 (2014-07-21 10:35:53) Information: TaskID=44e9d30f-6ff8-40b9-a002-0c1f614afbcd (2014-07-21 10:35:53) Information: MaxRunTime=1.00:00:00 (2014-07-21 10:35:53) Information: MachineName=xmdm00xx (2014-07-21 10:35:53) Information: Max attempts:1 (2014-07-21 10:35:53) Information: Current Attempt=0 (2014-07-21 10:35:53) Information: Task Dependencies are OK (2014-07-21 10:35:53) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution. (2014-07-21 10:35:53) Information: Opening "D:\test.qvw" (2014-07-21 10:35:53) Information: Allocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader). (2014-07-21 10:35:53) Information: Max retries:5 (2014-07-21 10:35:53) Information: Attempt:01 (2014-07-21 10:35:53) Information: Opened the QlikView Engine successfully. ProcessID=4692 (2014-07-21 10:35:53) Information: Allocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=5. (2014-07-21 10:35:53) Information: Loading document "D:\test.qvw" (58.04 Mb) (2014-07-21 10:35:54) Information: Loading. LoadTime=00:00:01.0001088 (2014-07-21 10:35:56) Error: Document open call failed. The document might require username and password. (2014-07-21 10:35:56) Information: Attempted to load the document without data. (2014-07-21 10:35:56) Error: The document failed to open. (2014-07-21 10:35:56) Information: Loading. LoadTime=00:00:03.0003264 (2014-07-21 10:35:56) Information: Closed the QlikView Engine successfully. ProcessID=4692 (2014-07-21 10:35:56) Error: Document could not be opened (2014-07-21 10:35:56) Information: Closed the QlikView Engine successfully. ProcessID=4692 (2014-07-21 10:35:56) Information: Failed to check in document: D:\test.qvw (2014-07-21 10:35:56) Error: The task "Di_ORION" failed. Exception: (2014-07-21 10:35: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: D:\test.qvs (2014-07-21 10:35:56) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) (2014-07-21 10:35:56) Error: --- End of inner exception stack trace --- (2014-07-21 10:35:56) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) (2014-07-21 10:35:56) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) (2014-07-21 10:35:56) Error: --- End of inner exception stack trace --- (2014-07-21 10:35:56) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) (2014-07-21 10:35:56) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult) (2014-07-21 10:35:56) Information: Task Execute Duration=00:00:03.2816070 (2014-07-21 10:35:56) Information: TaskResult.status=Finished (2014-07-21 10:35:56) Information: Notifying all triggers of new state:FinishedWithErrors (2014-07-21 10:35:56) Information: Notifying all triggers of new state:FinishedWithErrors - completed (2014-07-21 10:35:56) Information: Saving Task Result Di_ORION Execution Started Status Duration 21/07/2014 10:35:53 Failed 3 sec 21/07/2014 10:31:36 Failed 7 sec Last updated @ 21/07/2014 10:56:11 Automatic refresh of task list Refresh Refresh

[SunilChauhan]

hi i found the fact.

this is because of section access. its not able to open the file..

i have commented the  section access code.its running .

but i need to apply section access also.

Now my question is i am able to open application using Service account login. but not able to execute job using this account.its not even allow to open while excuting the task i believe.

Thanks

Sunil

[ashfaq_haseeb]

Hi,

For section access to work you must provide section access credentials in the below path.

QEMC--> system-->Setup --> Distribution service --> Advance --> add admin account credentials of your section access.

Make sure your service account belong to Local administrator group too.

Hope it helped.

Regards

ASHFAQ

[SunilChauhan]

Thanks for you reply but its not working

it showing me error

Failed to check in document: D:test.qvw

[ashfaq_haseeb]

Hi,

Can you provide logs.

Without seeing logs its really hard to say where the issue comes from.

Regards

ASHFAQ

[#7]

The error looks like the document have Section Access and the service User has no access. Add a user in the Reload task or add the service user in Section Access if you use NTNAME

Document open call failed. The document might require username and password.