topic Re: Task QVW refresh get fails in QlikView

Task QVW refresh get fails

Tue, 16 Feb 2016 13:08:46 GMT

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 ....

Re: Task QVW refresh get fails

swuehl — Tue, 16 Feb 2016 14:49:04 GMT

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

Re: Task QVW refresh get fails

Sun, 21 Feb 2016 08:25:51 GMT

I received those detail on mail.

Where i will get all detailed log file.

Regards,

Lokesh S

Re: Task QVW refresh get fails

swuehl — Sun, 21 Feb 2016 17:36:50 GMT

Have a look at

Video - Troubleshooting reload and distribution task failures‌

Video - QlikView Server log files explained‌

Re: Task QVW refresh get fails

Mon, 11 Apr 2016 09:42:00 GMT

Detailed log is as follow -

Log:

(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.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

Re: Task QVW refresh get fails

swuehl — Tue, 12 Apr 2016 08:15:51 GMT

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