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

[Anil_Babu_Samineni]

May be few files are kills the Task reload. Would you share whole log file from server

[#3]

Hi Anil,

PFA the log file

[Siva_Sankar]

Karan,

Can you check the document log file and paste the error here?

[Anil_Babu_Samineni]

Here, 3/24/2017 03:36:15.7195518 reloaded successful

and again - with in 3 minutes it is failed 3/24/2017 03:36:19.2763062. Not getting any idea due to don't have much experience in Server level

[Siva_Sankar]

Task log will not give complete information, you need to check document log to get the exact error message.

[Anil_Babu_Samineni]

True, Accepted

[#8]

The document log just says 'General Script Error, Execution failed'.

[#9]

yesterday I tried to perform a reload using the Qlikview desktop, and it was successful. But when trying through QMC, the distribution service shuts down after some time.

I've attached the document logs for 3/24

Thanks!

[Siva_Sankar]

Karan,

Open the script editor of your dashboard, and search for group by [Document ID + Version]

Issue might be here... check syntax is correct, semilcolon at the end is there or not?