Require more info on script error in order to troubleshoot

[#1]

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

[Miguel_Angel_Baeyens · Accepted solution]

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