Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

data load log

Dear all,

Can I get from a log file the step-by-step (as displayed) the data load (script execution)?

What I realy want is to setup alarms for problems in any specific load. example: 0 records loaded.

Thanks in advancce.

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

Hi,

You can enable the log file on Settings- > Document Properties -> General Tab -> On the right, check 'Generate Log file'.

If you want to keep a log for each reload, you can also check the 'Timestamp in logfile name'. Otherwise, the log will be overwritten each time it runs.

The log file will be in the same folder of your qvw and the name will be the same of the .qvw but with the extension .log ( or the name can be name_timestamp.log if you enable the timestamp)

After that, you will need to create a script to interpret the results from the .log

Alternatively, you can use the approach we discussed in this thread:

http://community.qlik.com/message/230891#230891

There, we included a few more steps in the script to store the number of rows that were loaded in selected tables in qvds. Then, you can create an auxiliary qvw to analyse your results.

Hope it helps,

Erich

View solution in original post

2 Replies
erichshiino
Partner - Master
Partner - Master

Hi,

You can enable the log file on Settings- > Document Properties -> General Tab -> On the right, check 'Generate Log file'.

If you want to keep a log for each reload, you can also check the 'Timestamp in logfile name'. Otherwise, the log will be overwritten each time it runs.

The log file will be in the same folder of your qvw and the name will be the same of the .qvw but with the extension .log ( or the name can be name_timestamp.log if you enable the timestamp)

After that, you will need to create a script to interpret the results from the .log

Alternatively, you can use the approach we discussed in this thread:

http://community.qlik.com/message/230891#230891

There, we included a few more steps in the script to store the number of rows that were loaded in selected tables in qvds. Then, you can create an auxiliary qvw to analyse your results.

Hope it helps,

Erich

Anonymous
Not applicable
Author

Thanks Erich.