Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
You can see here the log about a task that failed:
5/12/2011 09:34:51.1108000 Information Executing ClusterID=1, QDSID=a5b1991f-d7ea-a27b-4fbb-d9626286a734 QDSMain.DistributeTask
5/12/2011 09:34:51.1108000 Information Starting task "E-TRAVEL/flights_synchronizer.qvw" (Attempt 1 of 1)
5/12/2011 09:34:51.1108000 Information Max run time: 06:00:00
5/12/2011 09:34:51.1576000 Information Document is marked for refresh; Initializing Reload.
5/12/2011 09:34:51.1576000 Information Opening "C:\ProgramData\QlikTech\Documents\E-TRAVEL\flights_synchronizer.qvw"
5/12/2011 09:34:51.1576000 Information Allocating QlikView Engine
5/12/2011 09:34:51.1576000 Information Allocating new QlikView Engine. Current usagecount=1 of 2
5/12/2011 09:34:51.1576000 Information An instance of the QlikView Engine is being created
5/12/2011 09:34:51.1576000 Information Starting QlikView Engine
5/12/2011 09:34:51.8284000 Information Allocated QlikView Engine successfully. Current usagecount=1 of 2, Ticket=545
5/12/2011 09:34:51.8284000 Information Loading document "C:\ProgramData\QlikTech\Documents\E-TRAVEL\flights_synchronizer.qvw" (0.16 Mb)
5/12/2011 09:34:52.8424000 Information Loading. LoadTime=00:00:01.0140000
5/12/2011 09:34:53.9656000 Information Physical FileSize=0.16 Mb. Memory Allocation Delta for this file=5.76 Mb. Available Physical Memory Before Open=29798.00 Mb. Available Physical Memory After Open=29791.92 Mb. Total Physical Memory=31999.60 Mb.
5/12/2011 09:34:53.9656000 Information The document was loaded successfully.
5/12/2011 09:34:53.9656000 Information Initializing Checkout (0), Loading document (671), Initializing load (671), Checking read (671), Creating QlikView Engine (671), Checking Size (687), Load (2715), Load Completed (2746), Tables read (2777), Opened successfully (2808)
5/12/2011 09:34:53.9656000 Information Document was opened successfully
5/12/2011 09:34:53.9656000 Information Opened successfully (0)
5/12/2011 09:34:53.9656000 Information Starting reload
5/12/2011 09:34:53.9812000 Information QlikView->Settings->Document Peferences->Generate Logfile in document is not set.
5/12/2011 09:34:54.9796000 Information Reloading.
5/12/2011 09:34:55.9936000 Information Reloading..
5/12/2011 09:34:55.9936000 Information The Source Document is being reloaded. DocumentPath=C:\ProgramData\QlikTech\Documents\E-TRAVEL\flights_synchronizer.qvw
5/12/2011 09:34:57.0076000 Information Reloading...
5/12/2011 09:34:58.0216000 Information Reloading....
5/12/2011 09:34:59.0356000 Information Reloading.....
5/12/2011 09:35:00.0496000 Information Reloading......
5/12/2011 09:35:01.0636000 Information Reloading.......
5/12/2011 09:35:02.0776000 Information Reloading........
5/12/2011 09:35:03.0916000 Information Reloading.........
5/12/2011 09:35:04.1056000 Information Reloading..........
5/12/2011 09:35:05.1196000 Information Slowing down logging. LoggingSeconds=2
5/12/2011 09:35:05.1196000 Information Reloading
5/12/2011 09:35:07.1476000 Information Reloading.
5/12/2011 09:35:09.1756000 Information Reloading..
5/12/2011 09:35:11.2036000 Information Reloading...
5/12/2011 09:35:13.2316000 Information Reloading....
5/12/2011 09:35:15.2596000 Information Reloading.....
5/12/2011 09:35:17.2876000 Information Reloading......
5/12/2011 09:35:19.3156000 Information Reloading.......
5/12/2011 09:35:21.3436000 Information Reloading........
5/12/2011 09:35:23.3716000 Information Reloading.........
5/12/2011 09:35:25.3996000 Information Reloading..........
5/12/2011 09:35:25.6960000 Information The Source Document reload complete. DocumentPath=C:\ProgramData\QlikTech\Documents\E-TRAVEL\flights_synchronizer.qvw
5/12/2011 09:35:25.7116000 Information Memory Allocation Delta for this file=18.71 Mb. Available Physical Memory Before Reload=29791.92 Mb. Available Physical Memory After Reload=29770.90 Mb. Total Physical Memory=29770.90 Mb.
5/12/2011 09:35:25.9300000 Error The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\E-TRAVEL\flights_synchronizer.qvw.
5/12/2011 09:35:25.9300000 Information Initializing Reload (0), Finished (31965)
5/12/2011 09:35:25.9300000 Error Reload failed.
5/12/2011 09:35:25.9612000 Information Closing the document.
5/12/2011 09:35:26.2108000 Information Closed the QlikView Engine successfully. ProcessID=2084
5/12/2011 09:35:26.2108000 Information Initializing (0), Finished (280)
5/12/2011 09:35:26.2108000 Error Reload failed. Distribution skipped.
5/12/2011 09:35:26.2108000 Error The task "E-TRAVEL/flights_synchronizer.qvw" failed. ErrorCount=3
5/12/2011 09:35:26.2108000 Information Sending Alert Mail to 1 recipients.
How/where can I have more info about this error? Please note that this task takes place every 5 minutes and has never failed. Also, it does not fail anymore (since 5/12/2011 09:35). So, I do not have any clue why a task that goes flawlessly might have failed onece.
Can I increase the log level? Will I get something from there?
Thanks in advance.
Panayotis
Hi Panayotis,
To see where the script stopped, so you can go further to troubleshoot the error, open the document, go to the Settings menu, Document Properties, and in the General tab check the "Generate Logfile" (and is a good idea to check the "Timestamp in logfile name" as well). This will create a "Document.qvw.log" file in the same folder where the QVW file is, that will record the execution of the script line after line.
Along with some TRACEs in your script (to see for example whether a variable has the correct value) this should do.
LET vToday = Today();
// This will print on the load dialog (if opened) and in the log file the result of the variable assignment
TRACE $(vToday);
Hope that helps.
Miguel
Hi Panayotis,
To see where the script stopped, so you can go further to troubleshoot the error, open the document, go to the Settings menu, Document Properties, and in the General tab check the "Generate Logfile" (and is a good idea to check the "Timestamp in logfile name" as well). This will create a "Document.qvw.log" file in the same folder where the QVW file is, that will record the execution of the script line after line.
Along with some TRACEs in your script (to see for example whether a variable has the correct value) this should do.
LET vToday = Today();
// This will print on the load dialog (if opened) and in the log file the result of the variable assignment
TRACE $(vToday);
Hope that helps.
Miguel