Events in the 'Events Chart' show several hours off Follow

 

  

Problem Description:

In the Event Chart in the Dashboard all graphs are shown by several hours off or do not show at all when filtering by specific event or new implementation.

Environment:

  • On-Premise: Backend: All Versions using Mysql and Server running on a Timezone (not UTC)

 

 

Resolution:

  1. Navigate to the Takipi-server 'shared' folder, by default at:
    /opt/takipi-server/conf/tomcat/shared
  2. Create a new config file called my.rdbms.properties
  3. Specify the exact timezone of your server as shown in the example below:
  4. Do NOT use 3 letter abbreviations!
mysql.serverTimezone=Asia/Jerusalem

Or

mysql.serverTimezone=Asia/Tokyo

 For a list of available codes see here

Cause:

Issue is caused when server is running in timezones which have duplicate codes.

Example:

IST Indian Standard Time UTC+05:30
IST Irish Standard Time[8] UTC+01
IST Israel Standard Time UTC+02

The JDBC (Java Database Connectivity) application reads the time zone as 'India Standard Time' and sends the information to MySql instance, which in its turn reads the timestamp as 'Israel Standard Time'

The difference between those timestamps is are causing the data to be written by several hours off based on the differences above.

 

 

Comments

0 comments