ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

MYSQL Agent Timezone issue | U02012064 The server time zone ... is unrecognized

book

Article ID: 238151

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

We are getting following error with MYSQL CONN object:

U02012064 The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specifc time zone value if you want to utilize t..

The issue seems to have appeared after the DST change from CET to CEST.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

Solution:

Add a Timezone like UTC, Europe/Paris or America/New_York to Advanced > Connection Properties Extension of the MySQL CONN object.