Processing files still being copied to server - handling query

[#1]

Hi,

I have a pre-process which produces the source data for my QVW. This is transmitted to the Qlikview server, where the QVWs will pick them up as per their scheduling. The question on this is how does Qlikview server handle the scenario where a file is changing in size (due to it still being copied) at the time the script runs, due to the scheduling commencing this process. I'd imagine this would cause any number of issues if there was not some type of in-built handling.

Thanks

[tanelry]

If the issue is critical then you can add a sleep-loop in QV script, checking the source file with filetime() or filesize() functions.

For example check filetime() and if date is older than today OR datetime less than 10 min ago, sleep 10 minutes and repeat.

[jonathandienst]

Alternatively, assuming you have control over the process writing the data to the source file, have the process create a log file with the completion date. Then your script can read the log file and can determine that the data is ready by examining the most recent completion date.

Regards

Jonathan