User receives errors running report against MySQL: FOC1400 SQLCODE IST 1


Diagnostics

Product: Reporting Server
Release: 8206
Primary OS: Windows
Solution Date:

Symptom

(FOC1400) SQLCODE IST 1 (HEX: 00000001) XOPEN: 01S00

(FOC1500)  :  (0) [01S00] The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver

(FOC1500)  :  (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.java.sql.SQLException: The server

(FOC1500)  :  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

(FOC1500)  :  property) to use a more specifc time zone value if you want to utilize time zone support.

Problem

The user receives the error messages above while running a report against MySQL.

Solution

MySQL introduced a UC in connect/J 8.



To address this issue, add the following to the end of the MySQL connection URL: 



&|serverTimezone=EST5EDT