topic Re: Daylight saving issue in load schedule. in QlikView

Daylight saving issue in load schedule.

dsharmaqv — Sat, 16 Nov 2024 05:09:17 GMT

I am facing an issue due to day light saving.

My server is in UK and load job is scheduled at UKT, where as my file timing follows IST(India time).

After day light saving change in UK, Now my schedule is running before the file arrives in landing folder.

How to resolve such situation, manually changing schedule twice every year is not a good approach

Re: Daylight saving issue in load schedule.

tomasz_tru — Fri, 23 Nov 2018 10:01:42 GMT

If there's no direct trigger between placing files in a source folder and app loading it's worth to make sure files are there, besides the running hours. Minimalists example:

SET vFile='lib://Folder/Do_I_exist.txt';

DO UNTIL FileSize('$(vFile)')>0 
  Sleep 100000; 
  Trace Not yet...;
LOOP

TRACE You can load the data now;

exit script;