topic Re: Logging script execution in QlikView

Logging script execution

Anonymous — Thu, 19 Dec 2013 09:45:09 GMT

Hi Experts,

I have a scheduled daily QlikView batch that executes to extract a series of data from Customer A to Z. I would like to log the execution to a log file so that I know the batch has executed for Customer A to Z successful. Example of the log content

DateTime Message ErrorMsg

10/12/2013 05:00 Data Extraction Started on 10/12/2013

10/12/2013 05:00 Data successfully extracted for Customer A

10/12/2013 05:00 Data successfully extracted for Customer B

10/12/2013 05:01 Data extraction failed for Customer!! Some error message

I am quite a loss on how I can do this in QlikView. Can someone advise? Thx.

Re: Logging script execution

Gysbert_Wassenaar — Thu, 19 Dec 2013 09:51:47 GMT

I don't understand your question. You can enable the Generate Logfile option in the document properties of .qvw documents so a log is generated when the file is reloaded. You can use the TRACE keyword in the script to output custom logging lines. See the help file for more details.

Re: Logging script execution

Anonymous — Thu, 19 Dec 2013 10:01:53 GMT

Nickson

How about you:

Create a log.qvd if it does not exist
Early in your load script load it into resident
Concatenate your log information to it with an Inline
At the end of your script store the log.qvd

Best Regards, Bill

Re: Logging script execution

Anonymous — Thu, 19 Dec 2013 10:06:12 GMT

Thx for your suggestion! I just tried switching on the log and placing a few trace statement in my scripts and then reload my file.

Urmm... I am not able to find the any log file generated. Can advise where are the logs generated to?

Re: Logging script execution

Anonymous — Fri, 20 Dec 2013 03:36:06 GMT

Thx gwassenaar! I got it.