topic Re: Reload schedule sometimes fails in QlikView

Reload schedule sometimes fails

Thu, 25 Oct 2012 11:08:52 GMT

I have a huge list of scheduled QV reload on the QV server. Sometimes 1 or more QV reload fails. We have minmized the reload fails spreading out the reloads on the server, max 2 active at each time, but every few days a QV reload fails with only the message

(2012-10-25 01:09:36) Information: Reloading
(2012-10-25 01:24:36) Information: Reloading.
(2012-10-25 01:24:44) Information: The Source Document reload complete. DocumentPath=[Some QV document path].qvw
(2012-10-25 01:24:44) Information: Memory Allocation Delta for this file=93.18 Mb. Available Physical Memory Before Reload=8636.74 Mb. Available Physical Memory After Reload=10876.36 Mb. Total Physical Memory=10876.36 Mb.
(2012-10-25 01:24:45) Error: The Source Document was NOT reloaded successfully. DocumentPath=[Some QV document path].qvw.
(2012-10-25 01:24:45) Information: Initializing Reload (0), Finished (11621015)
(2012-10-25 01:24:45) Error: Reload failed.
(2012-10-25 01:24:45) Information: Closing the document.
(2012-10-25 01:24:45) Information: Closed the QlikView Engine successfully. ProcessID=3372
(2012-10-25 01:24:45) Information: Initializing (0), Finished (282)
(2012-10-25 01:24:45) Error: Reload failed. Distribution skipped.
(2012-10-25 01:24:45) Error: The task "[Some QV document path].qvw" failed. ErrorCount=3
(2012-10-25 01:24:45) Information: Sending Alert Mail to 3 recipients.

My question is: Is there any way to monitor exactly why the reload fails? Does QV offer this kind of monitorin or do I need some 3rd party monitoring/reporting tool? This does not happen every time we reload, so the code should not be the problem. I'm not sure if you need more info about this to answer, but any tips would be much appreciated.

Regards,

Gunnar

Re: Reload schedule sometimes fails

Gysbert_Wassenaar — Thu, 25 Oct 2012 11:38:05 GMT

Have you enabled logging in your qvw document? You can also try adding trace statements to get more information in the log. Perhaps a connection to a database was disrupted.

Re: Reload schedule sometimes fails

Thu, 25 Oct 2012 12:10:26 GMT

Yes, the logging was enabled in the QVW. I always assumed that that log was the same as on the reload server, but I see now that the QVW log file contains much more information, thank you.

In the log, I see that the reload failed becouse of a "General Script Error". Also it stops when trying to store a table into a QVD. It's unlikely that it's an actual script error since most of the time the QVW reloads successfully. And it's a weird place to stop if the database connection was lost, couse it fails after selecting ("74 fields found: ...) a large SAP table and when saving it into a QVD file.

Am I right to assume these pointers? But at least this log file helps alot.

Edit:

25-10-2012 0:51:28: 4194 SQL SELECT [Long list of SAP tables]

25-10-2012 0:51:28: 4195 FROM EKBE

25-10-2012 0:51:37: 74 fields found: [List of the 74 fields] 2.293.736 lines fetched

25-10-2012 1:24:40: 4197 STORE EKBE INTO ..\..\Data\[Some QVD document path].QVD

25-10-2012 1:24:44: General Script Error

25-10-2012 1:24:44: Execution Failed

25-10-2012 1:24:44: Execution finished.

Re: Reload schedule sometimes fails

Gysbert_Wassenaar — Thu, 25 Oct 2012 12:39:04 GMT

I don't think the select was the problem. After all, the log says 2.293.736 lines fetched. I'd assume that the error happened after that. It could be the store. You could check if the qvd file was created correctly by checking the file time and trying to load manually in a test qvw file. If that's all correct then the script error occurred after that. You'll have to see what statements are executed there.

Re: Reload schedule sometimes fails

Thu, 25 Oct 2012 12:50:38 GMT

Yes. The QVD was not created, so the reload failed there. I'll look into that.

We had problems before with low hard drive space on the server, maybe the reloads are taking up some temporary space and failes becouse of that. But these tips helps alot, thanks.