Task QVW refresh get fails

[#1]

Hi

We created task and scheduled.

Recently it getting fails continue sly.

Following is error massage we reviving ...

The task "UAE Fanaar/FanaarDashboard/Business Intelligence System_Data.qvw" failed. Part of the log file follows:

2/16/2016 4:54:52 PM Warning The QlikView Engine is Reloading, it will be killed (Please ignore logged warnings/errors about the kill).
2/16/2016 4:54:52 PM Error The task "UAE Fanaar/FanaarDashboard/Business Intelligence System_Data.qvw" failed. Exception: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.WaitHandle.WaitOneNative(SafeHandle waitableSafeHandle, UInt32 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext) at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext) at SolutionGlobal.ThreadPool.ThreadPoolJob.SafeWaitEvent(WaitHandle eventWaitHandle) 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)
2/16/2016 4:54:52 PM Error Task failed with exception
2/16/2016 4:54:52 PM Error Exception=The currently executing operation was aborted.

Can any one please suggest what cause ....

[swuehl]

Could you upload the complete task log as well as the document log (which may show more details about what is causing the issue)?

[#3]

Hi

I received those detail on mail.

Where i will get all detailed log file.

Regards,

Lokesh S

[swuehl]

Have a look at

Video - Troubleshooting reload and distribution task failures‌

Video - QlikView Server log files explained‌

[#5]

Hi

Detailed log is as follow -

Log: 2016-04-11 13:07:572016-04-11 13:07:232016-04-11 11:38:312016-04-11 07:09:072016-04-11 01:12:432016-04-10 19:19:272016-04-10 13:29:262016-04-10 07:08:592016-04-10 01:10:592016-04-09 19:11:172016-04-09 13:08:082016-04-09 07:08:532016-04-09 01:12:492016-04-08 19:11:542016-04-08 13:09:382016-04-08 07:08:382016-04-08 01:15:222016-04-07 13:14:272016-04-07 07:07:282016-04-07 01:18:222016-04-06 19:25:182016-04-06 13:12:072016-04-06 09:32:402016-04-06 07:07:462016-04-06 01:18:402016-04-05 19:16:542016-04-05 16:22:052016-04-05 14:53:292016-04-05 13:10:132016-04-05 07:08:502016-04-05 01:16:032016-04-04 19:11:212016-04-04 17:23:022016-04-04 13:10:102016-04-04 07:08:222016-04-04 01:15:062016-04-03 19:17:432016-04-03 16:30:522016-04-03 13:10:572016-04-03 07:08:582016-04-03 01:09:162016-04-02 19:08:442016-04-02 13:11:532016-04-02 07:08:362016-04-02 01:09:162016-04-01 19:07:422016-04-01 13:08:132016-04-01 07:08:272016-04-01 01:13:562016-03-31 19:18:312016-03-31 13:09:542016-03-31 07:08:312016-03-31 01:13:262016-03-30 19:18:322016-03-30 13:10:152016-03-30 07:08:182016-03-30 01:12:492016-03-29 19:12:272016-03-29 13:08:342016-03-29 07:08:042016-03-29 01:14:202016-03-28 19:15:512016-03-28 13:12:142016-03-28 07:08:442016-03-28 01:12:492016-03-27 19:14:342016-03-27 13:13:072016-03-27 07:08:382016-03-27 01:09:062016-03-26 19:10:312016-03-26 13:11:392016-03-26 07:08:282016-03-26 01:08:402016-03-25 19:11:172016-03-25 13:07:152016-03-25 07:08:182016-03-25 01:16:122016-03-24 19:13:252016-03-24 13:07:402016-03-24 07:07:532016-03-24 01:16:032016-03-23 19:12:532016-03-23 13:06:562016-03-23 07:08:242016-03-23 01:14:582016-03-22 19:12:322016-03-22 14:42:442016-03-22 13:08:012016-03-22 13:06:022016-03-22 07:07:452016-03-22 01:11:142016-03-21 19:12:102016-03-21 13:07:322016-03-21 07:08:362016-03-21 01:10:562016-03-20 19:18:452016-03-20 13:11:492016-03-20 07:08:192016-03-20 01:09:582016-03-19 19:07:412016-03-19 13:07:252016-03-19 07:07:292016-03-19 01:09:252016-03-18 19:08:362016-03-18 13:09:462016-03-18 07:07:332016-03-18 01:16:382016-03-17 19:14:222016-03-17 13:10:302016-03-17 07:07:462016-03-17 01:10:082016-03-16 19:16:512016-03-16 13:09:542016-03-16 07:08:112016-03-16 01:11:352016-03-15 19:24:402016-03-15 19:20:182016-03-15 13:08:472016-03-15 07:08:032016-03-15 01:11:382016-03-14 19:22:562016-03-14 07:08:332016-03-14 01:12:112016-03-13 19:19:012016-03-13 13:20:392016-03-13 13:10:122016-03-13 07:08:492016-03-13 01:11:012016-03-12 19:11:142016-03-12 13:09:172016-03-12 07:07:59

(2016-04-11 13:07:23) Information: Starting task 'UAE Fanaar/FanaarDashboard/DataOptimizer.qvw'. Id:3878d15a-680b-4914-bebf-9baaac9bd3f2. Triggered by 'TaskCompletedTrigger'. Id:607eff43-b466-4845-baee-731de3e678fe

(2016-04-11 13:07:23) Information: Entering Task Execution.

(2016-04-11 13:07:23) Information: ClusterID=1

(2016-04-11 13:07:23) Information: QDSID=4bce805c-f697-fa66-2971-a882f0dc0de5

(2016-04-11 13:07:23) Information: TaskID=3878d15a-680b-4914-bebf-9baaac9bd3f2

(2016-04-11 13:07:23) Information: MaxRunTime=01:00:00

(2016-04-11 13:07:23) Information: MachineName=AEDXBAPP65

(2016-04-11 13:07:23) Information: Max attempts:1

(2016-04-11 13:07:23) Information: Current Attempt=0

(2016-04-11 13:07:23) Information: Task Dependencies are OK

(2016-04-11 13:07:24) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2016-04-11 13:07:24) Information: Opening "D:\KPMG QLIKVIEW\DASHBOARD\FanaarDashboard\DataOptimizer.qvw"

(2016-04-11 13:07:24) Information: Allocating new QlikView Engine. Current usage count=1 of 4 (of type non-reader).

(2016-04-11 13:07:24) Information: Max retries:5

(2016-04-11 13:07:24) Information: Attempt:01

(2016-04-11 13:07:24) Information: Opened the QlikView Engine successfully. ProcessID=3764

(2016-04-11 13:07:24) Information: Allocated QlikView Engine successfully. Current usage count=2 of 4 (of type non-reader). Ticket number=32.

(2016-04-11 13:07:24) Information: Loading document "D:\KPMG QLIKVIEW\DASHBOARD\FanaarDashboard\DataOptimizer.qvw" (0.16 Mb)

(2016-04-11 13:07:25) Information: Physical FileSize=0.16 Mb. Memory Allocation Delta for this file=2.52 Mb. Available Physical Memory Before Open=22575.66 Mb. Available Physical Memory After Open=22501.38 Mb. Total Physical Memory=32767.06 Mb.

(2016-04-11 13:07:25) Information: Attempted to load the document without data.

(2016-04-11 13:07:25) Information: The document was loaded successfully.

(2016-04-11 13:07:25) Information: Document was opened successfully

(2016-04-11 13:07:25) Information: Starting reload

(2016-04-11 13:07:25) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.

(2016-04-11 13:07:25) Information: Waiting for the document log "D:\KPMG QLIKVIEW\DASHBOARD\FanaarDashboard\DataOptimizer.qvw" to become available..

(2016-04-11 13:07:25) Information: The Source Document is being reloaded. DocumentPath=D:\KPMG QLIKVIEW\DASHBOARD\FanaarDashboard\DataOptimizer.qvw

(2016-04-11 13:07:25) Information: Found a document log. FileName=D:\KPMG QLIKVIEW\DASHBOARD\FanaarDashboard\DataOptimizer.qvw.log

(2016-04-11 13:07:25) Information: Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20160411\130723 - UAE Fanaar_FanaarDashboard_DataOptimizer.qvw\DocumentLog.txt

(2016-04-11 13:07:26) Information: Reloading.

(2016-04-11 13:07:26) Information: The Source Document reload complete. DocumentPath=D:\KPMG QLIKVIEW\DASHBOARD\FanaarDashboard\DataOptimizer.qvw

(2016-04-11 13:07:26) Information: Memory Allocation Delta for this file=69.80 Mb. Available Physical Memory Before Reload=22501.77 Mb. Available Physical Memory After Reload=22663.79 Mb. Total Physical Memory=22663.79 Mb.

(2016-04-11 13:07:26) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\KPMG QLIKVIEW\DASHBOARD\FanaarDashboard\DataOptimizer.qvw.

(2016-04-11 13:07:26) Information: Closing the document.

(2016-04-11 13:07:27) Information: Closed the QlikView Engine successfully. ProcessID=3764

(2016-04-11 13:07:27) Error: The task "UAE Fanaar/FanaarDashboard/DataOptimizer.qvw" failed. Exception:

(2016-04-11 13:07:27) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=D:\KPMG QLIKVIEW\DASHBOARD\FanaarDashboard\DataOptimizer.qvw.

(2016-04-11 13:07:27) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2016-04-11 13:07:27) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2016-04-11 13:07:27) Error: --- End of inner exception stack trace ---

(2016-04-11 13:07:27) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2016-04-11 13:07:27) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2016-04-11 13:07:27) Error: --- End of inner exception stack trace ---

(2016-04-11 13:07:27) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2016-04-11 13:07:27) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2016-04-11 13:07:27) Information: Task Execute Duration=00:00:03.4873487

(2016-04-11 13:07:27) Information: Sending Alert mail

(2016-04-11 13:07:34) Information: TaskResult.status=Finished

(2016-04-11 13:07:34) Information: Notifying all triggers of new state:FinishedWithErrors

(2016-04-11 13:07:34) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2016-04-11 13:07:34) Information: Saving Task Result

Regards,

Lokesh

[swuehl]

The reload failed, you probably find more information in the document log:

C:\ProgramData\QlikTech\DistributionService\1\Log\20160411\130723 - UAE Fanaar_FanaarDashboard_DataOptimizer.qvw\DocumentLog.txt