Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Oct 27, 2020 6:03:27 AM
Nov 19, 2019 3:54:05 PM
Reload Task set to "Brasilia" Time Zone Daylight Saving (DST) are not updated after DST change.
Brazil has cancelled DST. Previously set up tasks in Qlik Sense do not respect this change.
When using the Qlik Sense task's Daylight saving time "Observe daylight saving time", the time needs to be set 1 hour ahead for it to take effect in the configuration if scheduled to run within the next hour, as the effective time after clicking Apply rolls back 1 hour.
Environment:
A workaround is available to address this.
UPDATE "SchemaEvents" SET "DaylightSavingTime" = '1' WHERE "DaylightSavingTime" = '0';This will change existing triggers from Observe daylight saving time to Permanent standard time.
Future tasks should all be set with the setting Daylight saving time set to Permanent Standard time.
Where do I type and write this change?
Can you give me an image or more detailed guidance?
Hello @Felipe02
This is an SQL query you can run in, for example, pgAdmin. For instructions on how to connect to the Qlik Sense Repository with pgAdmin, see How to connect to the Qlik Sense Enterprise on Windows or Qlik NPrinting PostgreSQL database .
For documentation about the query tool, see Query Tool | pgAdmin .
But please note that Qlik assumes experience with SQL queries and how to execute them.
All the best,
Sonja