Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
dsharmaqv
Creator III
Creator III

Daylight saving issue in load schedule.

Hi 

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

Labels (2)
1 Reply
tomasz_tru
Specialist
Specialist

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;