Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This reload fails every day after running for 6 Hrs+. The Og file generated by file Shows NO error but the QMC LOg shows the Following. Can someone pls help
Below is the Reload failure LOg from QMC. The file LOg does not show any error
2014-07-25 08:00:11) Error: Exception=System.ObjectDisposedException: Safe handle has been closed
(2014-07-25 08:00:11) Error: at System.Threading.WaitHandle.WaitOneNative(SafeHandle waitableSafeHandle, UInt32 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)
(2014-07-25 08:00:11) Error: at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)
(2014-07-25 08:00:11) Error: at QVBWrapper.Document.ReadDocumentLogThread(ILogBucket i_LogBucket, DateTime i_ReloadStartTime)
(2014-07-25 08:00:11) Error: The task "QVDBuilders/Layer1/Claims/Claimsnapshot_QVDBuilder_Layer1.qvw" failed. Exception:
(2014-07-25 08:00:11) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> System.Threading.ThreadAbortException: Thread was being aborted.
(2014-07-25 08:00:11) Error: at System.Threading.WaitHandle.WaitOneNative(SafeHandle waitableSafeHandle, UInt32 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)
(2014-07-25 08:00:11) Error: at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)
(2014-07-25 08:00:11) Error: at SolutionGlobal.ThreadPool.ThreadPoolJob.SafeWaitEvent(WaitHandle eventWaitHandle)
(2014-07-25 08:00:11) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2014-07-25 08:00:11) Error: --- End of inner exception stack trace ---
(2014-07-25 08:00:11) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2014-07-25 08:00:11) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2014-07-25 08:00:11) Error: --- End of inner exception stack trace ---
(2014-07-25 08:00:11) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2014-07-25 08:00:11) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
(2014-07-25 08:00:12) Error: Task failed with exception
(2014-07-25 08:00:12) Error: Exception=The currently executing operation was aborted.
Hi everyone ,
I have the same issue as M. Ray and this is the text of the log in the file "Root_20140828.txt" in the folder "C:\ProgramData\QlikTech\DistributionService\1\Log" :
03:20:00;Triggered;Unhandled, Task=Analyse Commerciale/Analyse Vente & SAV/QVW/Analyse Performance Ventes & SAV_QVD.qvw
28/08/2014 03:20:11.3124774 Error The task "Analyse Commerciale/Analyse Vente & SAV/QVW/Analyse Performance Ventes & SAV_QVD.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)
Thank you for help !
Hi,
if it's still relevant...
go to: Document >> Reload >> Timeout seconds- update to more than 6 hours (21600)
cheer,
Hila.
Thank you very much M. Hila . I should find it by my self but I have never focus on this number before ![]()
I thought it was mentioned in a configuration file somewhere in Qlikview folder.
Qlikview won't stop my script after that but I have to find the reason the time of reload increased from
1h20 to more than 6 hours
Hi Riadh,
I'm actually facing the same problem with the loading time..
Will let you know if I find an answer ![]()
Is it always running for more then 6hours?
Any other tasks running at the same time?
Thank you very much M. Hila .
Hi Ako,
Thx for your reply ![]()
The process used to run for about 2-3 hours and now it is running for 7.5 hours.
There are no other tasks running at the same time.
Hi M. ako
Thank you for your interest ,
No , they are 4 tasks running one after the other (Just one at a time) .
But we found the problem . It was a problem with the VPN . There was a reversal of roles in features. that was active became passive and vice versa causing a slowdown in the circulation time between Qlikview server and the database server .
Thanks for all of you .