Qlikview reload failing with below errors.

[#1]

Hi,

We have a daily scheduled reload task. For the last two weeks, its failing with the below errors. Also, the Qlikview services are getting stopped randomly.

_______________________________________________________________________

Below are the errors in the task.log :

The task "Knova Analytics.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)

_____________________________________________________________________________________________

Also found the below errors in the Event logs:

An unexpected error occurred while trying to read file, C:\ProgramData\QlikTech\DistributionService\LoadBalancer.xml.

Exception=System.Exception: Failed to open C:\ProgramData\QlikTech\DistributionService\LoadBalancer.xml with Read access after 21 retries. Exceptions=

   The process cannot access the file 'C:\ProgramData\QlikTech\DistributionService\LoadBalancer.xml' because it is being used by another process.

   The process cannot access the file 'C:\ProgramData\QlikTech\DistributionService\LoadBalancer.xml' because it is being used by another process.

   at QDSMain.Clustering.ClusterFileHandler.OpenFile(FileAccess fileAccess)

   at QDSMain.Clustering.ClusterFile.Read(UInt32 timeoutSeconds)

_____________________________________________________________________

The QV reload would start at 12:01 AM daily (Usually completes in 45-50 mins). At 12.30 AM daily, we have a windows daily task, ProgramDataUpdater.

Is this making the xml file unaccessible for the QV reload? (If that's the case, How to confirm that?)

Thanks in advance!

Regards,

Karan

[ramasaisaksoft]

Hi Karan,

Step 1;- Document Properties-->General Tab-->Generate Log File.

Step 2 :- reload your qvw file by using Exit script ; by each tab in script then you will find easily which .qvd source file is not loading properly?

I hope either supported Source  files are not available  in folder structure you mentioned. else

if the same file is working Desktop means check all the related files you have for this app i mean (if you reload by this qvw file after modifying  some excel columns in Transform .excel file then check those modifications properly. )