since upgrading to version 11 and after applying SR2 we have intermittment reload failures. Jobs fail because document does not reload successfully. But if restarted it works ok. Is there some set up incorrect that we need to change on V11?
we load c 20 jobs every night and since going to V11 we have had at least one job fail most nights. It is different jobs and different times but generally the same error. Example below. If the job is re-started, even immediately afterwards it runs OK.
Getting to be a nuisance as the purpose of the loads is to get an upto date set of data for start of business every morning and if somebody doesnt nurse the jobs through late evening/early morning we do not achieve this.
(2012-11-18 21:10:08) Information: Physical FileSize=0.14 Mb. Memory Allocation Delta for this file=2.46 Mb. Available Physical Memory Before Open=29105.43 Mb. Available Physical Memory After Open=29103.72 Mb. Total Physical Memory=31998.60 Mb.
(2012-11-18 21:10:08) Information: Attempted to load the document without data.
(2012-11-18 21:10:08) Information: The document was loaded successfully.
(2012-11-18 21:10:08) Information: Document was opened successfully
(2012-11-18 21:10:08) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.
(2012-11-18 21:10:08) Information: Waiting for the document log "C:\CLIK\DATASOURCES\VE_Production_consumption.qvw" to become available..
(2012-11-18 21:10:08) Information: The Source Document is being reloaded. DocumentPath=C:\CLIK\DATASOURCES\VE_Production_consumption.qvw
(2012-11-18 21:10:08) Information: Found a document log. FileName=C:\CLIK\DATASOURCES\VE_Production_consumption.qvw.log
(2012-11-18 21:10:08) Information: Writing documentLog to C:\ProgramData\QlikTech\DistributionService\2\Log\20121118\211007 - Data Sources_VE_Production_consumption.qvw\DocumentLog.txt
(2012-11-18 21:10:09) Information: The Source Document reload complete. DocumentPath=C:\CLIK\DATASOURCES\VE_Production_consumption.qvw
(2012-11-18 21:10:09) Information: Memory Allocation Delta for this file=2.52 Mb. Available Physical Memory Before Reload=29103.68 Mb. Available Physical Memory After Reload=29134.39 Mb. Total Physical Memory=29134.39 Mb.
(2012-11-18 21:10:09) Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\CLIK\DATASOURCES\VE_Production_consumption.qvw.
(2012-11-18 21:10:09) Information: Reloading.
(2012-11-18 21:10:11) Information: Closing the document.
(2012-11-18 21:10:11) Information: Closed the QlikView Engine successfully. ProcessID=3048
(2012-11-18 21:10:11) Error: The task "Data Sources/VE_Production_consumption.qvw" failed. Exception:
(2012-11-18 21:10:11) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.ThreadPoolJobStillRunningException: Aborting reload. Error: QDSMain.TaskResult
It seems that there was an error in the document reload. You will probably have more information on the error if you check the last few lines from the document log available in
C:\ProgramData\QlikTech\DistributionService\2\Log\20121118\211007 - Data
This didnt help as the jobs that failed to start didnt write a log and this that failed when trying to reload also didnt write any reason when trying to reload after job finished.
We had several days of QV support company working on this to help us get it resolved.
We moved file server and stopped the antivirus TREND running when we are running re-load schedules. Since stopping TREND we have had 1 failure in 8 weeks since we did this.
Our jobs are on a schedule that ensures no sharing of files occurred. They were also timed so that there are never more than 2 running at any one time.
The issue appears to be TREND antivirus software that seems to cause issues with QV 11
I guess we can say that the problem is the same: file locking. Maybe the ativirus was locking the qvds or qvws at the moment that your tasks were trying to update them...
