Reload Task set to "Brasilia" Time Zone Daylight Saving (DST) are not updated after DST change

[Andre_Sostizzo]

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:

• Qlik Sense Enterprise on Windows any version

A workaround is available to address this.

1. Stop all Qlik Sense Services except the Qlik Sense Repository Database
2. Execute the following query against the Qlik Sense Repository Database: 

   UPDATE "SchemaEvents" SET "DaylightSavingTime" = '1'
   WHERE "DaylightSavingTime" = '0';

   This will change existing triggers from Observe daylight saving time to Permanent standard time.
3. Start the Qlik Sense Services

Future tasks should all be set with the setting Daylight saving time set to Permanent Standard time.

[Felipe02]

Where do I type and write this change?

Can you give me an image or more detailed guidance?

[Sonja_Bauernfeind]

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. 

• Always back up your database before you make changes!
• If in doubt, speak to your local database admins, who will be able to assist you

All the best,
Sonja