topic Re: Check reload percentage in log files in QlikView

Check reload percentage in log files

Wed, 01 Jul 2015 06:56:18 GMT

Hi all,

is there a way to check the reload percentage in log files?

We have to retrieve about 2 millions of rows and it takes about two hours.

I would like to see, at a certain time, how many rows have been processed.

Thanks a lot

Re: Check reload percentage in log files

datanibbler — Wed, 01 Jul 2015 07:00:30 GMT

Hi Roberto,

I think the log_files are written dynamically, no?`So you can look in there from time to time.

Another possibility might be to run the script locally while you are logged on to the server - that way, you'd have the execution_window all the time.

But anyhow, retrieving 2mio rows should not take so long. Where do you get that data from? From a database probably?`

Maybe you could schedule the reload to take place during off-hours when no one cares about the time it takes?

HTH

Re: Check reload percentage in log files

Wed, 01 Jul 2015 07:14:44 GMT

Hi DataNibber,

the log files are written dinamically by the scheduler but they don't show any informations about how many records have been retrieved since a certain time as we can see during manual reload in Desktop Application (YYYY records fetched... refreshing every second); we have only the final output but not in realtime.