topic QVD RELOAD ISSUE in QlikView

QVD RELOAD ISSUE

Fri, 25 Jul 2014 14:25:57 GMT

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

Re: QVD RELOAD ISSUE

Thu, 28 Aug 2014 12:21:34 GMT

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

Re: QVD RELOAD ISSUE

Sun, 07 Sep 2014 09:49:35 GMT

Hi,

if it's still relevant...

go to: Document >> Reload >> Timeout seconds- update to more than 6 hours (21600)

cheer,

Hila.

Re: QVD RELOAD ISSUE

Sun, 07 Sep 2014 21:08:51 GMT

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

Re: QVD RELOAD ISSUE

Mon, 08 Sep 2014 07:23:43 GMT

Hi Riadh,

I'm actually facing the same problem with the loading time..

Will let you know if I find an answer

Re: QVD RELOAD ISSUE

Mon, 08 Sep 2014 07:38:14 GMT

Is it always running for more then 6hours?

Any other tasks running at the same time?

Re: QVD RELOAD ISSUE

Mon, 08 Sep 2014 07:41:25 GMT

Thank you very much M. Hila .

Re: QVD RELOAD ISSUE

Mon, 08 Sep 2014 07:42:20 GMT

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.

Re: QVD RELOAD ISSUE

Mon, 08 Sep 2014 07:49:59 GMT

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 .