# Easy chart: error displaying trend for more than 7 days **URL:** \ **Category:** Ignition\ **Tags:** vision\ **Created:** [April 1, 2023, 11:07am UTC](https://forum.inductiveautomation.com/t/easy-chart-error-displaying-trend-for-more-than-7-days/71933 "2023-04-01T11:07:30Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Aljon\_Tanteo](https://avatars.discourse-cdn.com/v4/letter/a/dec6dc/32.png) [@Aljon\_Tanteo](https://forum.inductiveautomation.com/u/Aljon_Tanteo)\ **Post date:** [April 1, 2023, 11:07am UTC](https://forum.inductiveautomation.com/t/easy-chart-error-displaying-trend-for-more-than-7-days/71933/1 "2023-04-01T11:07:30Z")
Hello Everyone, I am having trouble with the easy chart when viewing older data. please see image below. also, I have other charts that has no problem like this. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/d/7dab45c915e88838cdc93898e68adc015280cf08.jpeg) thank you in advance ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [April 1, 2023, 12:07pm UTC](https://forum.inductiveautomation.com/t/easy-chart-error-displaying-trend-for-more-than-7-days/71933/2 "2023-04-01T12:07:37Z")
Please provide more detail, like the complete errors. (Get them as text from the diagnostic console, and paste them here as text. After pasting, highlight the pasted text and click the "preformatted text" button to make it show as a code block.) ---
**Author:** ![Aljon\_Tanteo](https://avatars.discourse-cdn.com/v4/letter/a/dec6dc/32.png) [@Aljon\_Tanteo](https://forum.inductiveautomation.com/u/Aljon_Tanteo)\ **Post date:** [April 1, 2023, 12:58pm UTC](https://forum.inductiveautomation.com/t/easy-chart-error-displaying-trend-for-more-than-7-days/71933/3 "2023-04-01T12:58:46Z")
@pturmel, is this what you are looking for? ```auto java.lang.Exception: Error running query: SQLQuery(query=SELECT t_stamp FROM level WHERE t_stamp >= ? AND t_stamp <= ? ORDER BY t_stamp, database=MySQL)@0ms On: Z4 TRENDS LEVEL.Root Container.Easy Chart at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:311) at java.base/java.lang.Thread.run(Unknown Source) Caused by: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: HOUR_OF_DAY: 2 -> 3 at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:351) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:325) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:278) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.runLimitQuery(GatewayInterface.java:880) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.runQuery(GatewayInterface.java:851) at com.inductiveautomation.factorypmi.application.gateway.SQLQuery.execute(SQLQuery.java:50) at com.inductiveautomation.factorypmi.application.gateway.QueryManager$Query.execute(QueryManager.java:668) at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:308) ... 1 more Caused by: java.sql.SQLException: HOUR_OF_DAY: 2 -> 3 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:85) at com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(ResultSetImpl.java:947) at org.apache.commons.dbcp2.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:948) at org.apache.commons.dbcp2.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:948) at com.inductiveautomation.ignition.gateway.datasource.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:346) at com.inductiveautomation.ignition.common.gateway.TypeMappings.getValueFromResultSet(TypeMappings.java:259) at com.inductiveautomation.ignition.common.gateway.TypeMappings.getValueFromResultSet(TypeMappings.java:214) at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.RunQuery.run(RunQuery.java:141) at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.AbstractDBAction.invoke(AbstractDBAction.java:66) at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:431) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:86) at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1450) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1631) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:600) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1440) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1355) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at com.inductiveautomation.catapult.handlers.RemoteHostNameLookupHandler.handle(RemoteHostNameLookupHandler.java:121) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:322) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.Server.handle(Server.java:516) at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487) at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) at java.lang.Thread.run(null) Ignition v8.1.22 (b2022110109) Java: Azul Systems, Inc. 11.0.16.1 ``` ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [April 1, 2023, 1:39pm UTC](https://forum.inductiveautomation.com/t/easy-chart-error-displaying-trend-for-more-than-7-days/71933/4 "2023-04-01T13:39:42Z")
> [@Aljon\_Tanteo](#): > > `Caused by: java.sql.SQLException: HOUR_OF_DAY: 2 -> 3` Huh. Never seen that one before. A quick search indicates it is related to a timezone conversion and a (possible) bug in a JDBC driver. Might want to call support. If this is MS SQL Server, make sure both gateway and database are operating in UTC to ensure timestamps are converted correctly in both directions.