Load error

[#1]

Can anyone tell me why this file occasionally fails to update please.

It reloads every 2 hours and approx 1 in 4 fail.

I cannot see anywhere in the error log that it actually tells me the issue.

The output qvw is accessed by another 10 qvw's on a 15 minute interval.

Thanks for your help

(2016-11-03 08:00:00) Information: Starting task 'Data Files/SalesHist.qvw'. Id:f2c81b5e-ea45-484a-ae95-8a881510aad2. Triggered by 'ScheduleTrigger'. Id:83b59dd5-ba91-4d33-b2f0-163ec9428749

(2016-11-03 08:00:00) Information: Entering Task Execution.

(2016-11-03 08:00:00) Information: ClusterID=1

(2016-11-03 08:00:00) Information: QDSID=a4a90fe7-f2d3-315b-483e-33ea04c0e5b6

(2016-11-03 08:00:00) Information: TaskID=f2c81b5e-ea45-484a-ae95-8a881510aad2

(2016-11-03 08:00:00) Information: MaxRunTime=06:00:00

(2016-11-03 08:00:00) Information: MachineName=QLIKVIEW

(2016-11-03 08:00:00) Information: Max attempts:1

(2016-11-03 08:00:00) Information: Current Attempt=0

(2016-11-03 08:00:00) Information: Task Dependencies are OK

(2016-11-03 08:00:00) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2016-11-03 08:00:00) Information: Opening "\\pf01sql01\QlikView\Data Files\SalesHist.qvw"

(2016-11-03 08:00:00) Information: Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).

(2016-11-03 08:00:00) Information: Max retries:5

(2016-11-03 08:00:00) Information: Attempt:01

(2016-11-03 08:00:03) Information: Opened the QlikView Engine successfully. ProcessID=8832

(2016-11-03 08:00:03) Information: Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=8207.

(2016-11-03 08:00:03) Information: Loading document "\\pf01sql01\QlikView\Data Files\SalesHist.qvw" (185.31 Mb)

(2016-11-03 08:00:04) Information: Loading. LoadTime=00:00:01.0140325

(2016-11-03 08:00:06) Information: Loading. LoadTime=00:00:03.0420975

(2016-11-03 08:00:10) Information: Loading. LoadTime=00:00:07.0982275

(2016-11-03 08:00:12) Information: Physical FileSize=185.31 Mb. Memory Allocation Delta for this file=3.14 Mb. Available Physical Memory Before Open=2868.62 Mb. Available Physical Memory After Open=2838.26 Mb. Total Physical Memory=6143.55 Mb.

(2016-11-03 08:00:12) Information: Attempted to load the document without data.

(2016-11-03 08:00:12) Information: The document was loaded successfully.

(2016-11-03 08:00:12) Information: Document was opened successfully

(2016-11-03 08:00:12) Information: Starting reload

(2016-11-03 08:00:12) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.

(2016-11-03 08:00:12) Information: Waiting for the document log "\\pf01sql01\QlikView\Data Files\SalesHist.qvw" to become available.. Check until 03/11/2016 08:00:42

(2016-11-03 08:00:12) Information: The Source Document is being reloaded. DocumentPath=\\pf01sql01\QlikView\Data Files\SalesHist.qvw

(2016-11-03 08:00:12) Information: Found a document log. FileName=\\pf01sql01\QlikView\Data Files\SalesHist.qvw.log

(2016-11-03 08:00:12) Information: Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20161103\080000 - Data Files_SalesHist.qvw\DocumentLog.txt

(2016-11-03 08:00:22) Information: Reloading..........

(2016-11-03 08:00:23) Information: Slow down logging. Log every <2> seconds.

(2016-11-03 08:00:43) Information: Reloading..........

(2016-11-03 08:00:45) Information: Slow down logging. Log every <10> seconds.

(2016-11-03 08:02:26) Information: Reloading..........

(2016-11-03 08:02:37) Information: Slow down logging. Log every <60> seconds.

(2016-11-03 08:07:41) Information: Reloading.....

(2016-11-03 08:08:26) Information: The Source Document reload complete. DocumentPath=\\pf01sql01\QlikView\Data Files\SalesHist.qvw

(2016-11-03 08:08:26) Information: Memory Allocation Delta for this file=31.96 Mb. Available Physical Memory Before Reload=2838.26 Mb. Available Physical Memory After Reload=2309.54 Mb. Total Physical Memory=2309.54 Mb.

(2016-11-03 08:08:26) Error: The Source Document was NOT reloaded successfully. DocumentPath=\\pf01sql01\QlikView\Data Files\SalesHist.qvw.

(2016-11-03 08:08:26) Information: Closing the document.

(2016-11-03 08:08:27) Information: Closed the QlikView Engine successfully. ProcessID=8832

(2016-11-03 08:08:29) Error: The task "Data Files/SalesHist.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=\\pf01sql01\QlikView\Data Files\SalesHist.qvw.  || at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult) ||    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)

(2016-11-03 08:08:29) Information: Task Execute Duration=00:08:29.1904201

(2016-11-03 08:08:29) Information: TaskResult.status=Finished

(2016-11-03 08:08:29) Information: Notifying all triggers of new state:FinishedWithErrors

(2016-11-03 08:08:29) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2016-11-03 08:08:29) Information: Saving Task Result

[MK9885]

You're assigning triggers in QMC for your source file to load?

[#3]

Hi, yes there is a QMC trigger to run a QVD for a reload every 2 hours.

Is that what you meant ?

Thanks

[MK9885]

Yes.

So your source file is failing to refresh?

[rupamjyotidas]

Are there any Pre Tasks /Triggers. Probably the Refresh is having too frequently before the Pre Tasks are over.

Also check your memory utilization. Maybe the memory is creating problem.

[alexdataiq]

Do you have the application log? There could me some clues there, maybe the qvw is trying to save the file while one or more qvw's are reading the QVD.

Regards

[ramasaisaksoft]

HI PM,

1 way is if the job is failed in QMC run the same qvw by manually in Qlikview personal edition.so that you also know which source files are causing for failure.

2nd Way, if this is the first time job failed may be Comfortable RAM is  not available at that moment so check the RAM.

Note:-As per Experts view we need to restart Qlikview services for every month at least once depends on your down time.

[DavidFoster1]

look at the Document log \\pf01sql01\QlikView\Data Files\SalesHist.qvw.log

[#9]

Hi all

If I manually run this file it never fails.

I have doubled the available memory and it is still failing.

David, this is the final part of the log

08/11/2016 05:07:02: 0290  Store SalesOrderLinesHistory into \\pf01sql01\QlikView\Data Files\SalesOrderHistory.qvd

08/11/2016 05:07:06:       General Script Error

08/11/2016 05:07:06:       Execution Failed

08/11/2016 05:07:06:      Execution finished.

This is the final part of the script

Store SalesOrderLinesHistory into \\pf01sql01\QlikView\Data Files\SalesOrderHistory.qvd;

I'm very confused as it isn't anything special in size or complexity.