How to resolve time zone error while connecting External account MYSQL Data base in adobe Campaign classic client console | Community
Skip to main content
V
vinayababu
Level 2
January 13, 2021
Question

How to resolve time zone error while connecting External account MYSQL Data base in adobe Campaign classic client console

  • January 13, 2021
  • 1 reply
  • 2234 views

Hi Team,

I am getting below error while trying to connect with external account MYSQL Database.

"MYS-230000 MYSQL error 1298:Unknown or incorrect timezone:"

MySQL Database server is with time zone (GMT-05:00)Est(united states and Canada).

Could you please suggest how to fix the issue.

Thanks

Vinaya

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

A
amritakedia_epsilon
Level 3
January 13, 2021

What is the value of the Option variable : WdbcTimeZone ?

V
vinayababuAuthor
Level 2
January 18, 2021

Hi Amritakedia, The value for WDB-200001 SQL statement 'SET time_zone='America/New_York'' .

 

Yes its not resolving to WDB time zone.

 

Thanks Vinaya

K
krishnakanthgmail
November 28, 2022

Hi @vinayababu, Was this resolved? Can you help me with this?

I remember someone telling me that zoneinfo.zip to be modified [or] xtk:commons:timezone needs to be changed before the server loads. but I'm unable to remember it clearly.

Terms & ConditionsAccessibility statement

Loading footer...