Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

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

vinayababu
Level 2
Level 2

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

2 Replies
amritakedia_epsilon
Level 3
Level 3

What is the value of the Option variable : WdbcTimeZone ?

vinayababu
Level 2
Level 2

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