I have multiple Pop Up windows with an Easy chart, some times I get an error. I’m using Tag Historian module and Mysql.
[attachment=0]error[1685].png[/attachment]
[size=200][b]EDIT: I attached a video.
https://youtu.be/GHmp88hFAeA[/b][/size]
I made a video explaining my problem.
Full error:
java.lang.Exception: Error running query:
TagHistory(paths=[prov:default:/tag:1_Digestor Continuo Linea 1/ANALOGO/PI1003, prov:default:/tag:1_Digestor Continuo Linea 1/ANALOGO/PI1011, prov:default:/tag:1_Digestor Continuo Linea 1/ANALOGO/PI1054, prov:default:/tag:1_Digestor Continuo Linea 1/ANALOGO/PI1055, prov:default:/tag:1_Digestor Continuo Linea 1/ANALOGO/PI1088, prov:default:/tag:1_Digestor Continuo Linea 1/ANALOGO/PI1089, prov:default:/tag:1_Digestor Continuo Linea 1/ANALOGO/PI1156, prov:default:/tag:1_Digestor Continuo Linea 1/ANALOGO/PI1157, prov:default:/tag:1_Digestor Continuo Linea 1/ANALOGO/PI1180, prov:default:/tag:1_Digestor Continuo Linea 1/ANALOGO/PI1181, prov:default:/tag:1_Digestor Continuo Linea 1/ANALOGO/PI1233, prov:default:/tag:1_Digestor Continuo Linea 1/ANALOGO/PI1234, prov:default:/tag:1_Digestor Continuo Linea 1/ANALOGO/TT1014, prov:default:/tag:1_Digestor Continuo Linea 1/ANALOGO/TT1100], start=Thu Nov 24 20:29:48 CLT 2016, end=Thu Nov 24 20:29:49 CLT 2016, flags=68)@0ms
On: Graficos Historicos.Root Container.Easy Chart
at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:317)
at java.lang.Thread.run(Unknown Source)
Caused by: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: The maximum row limit (1001) has been reached for this query.
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:329)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:303)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.runTagHistoryQuery(GatewayInterface.java:712)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.runTagHistoryQuery(GatewayInterface.java:681)
at com.inductiveautomation.factorypmi.application.gateway.GWITagHistoryProvider.query(GWITagHistoryProvider.java:16)
at com.inductiveautomation.ignition.common.sqltags.history.cache.StandardCacheBucket.loadData(StandardCacheBucket.java:229)
at com.inductiveautomation.ignition.common.sqltags.history.cache.StandardCacheBucket.getData(StandardCacheBucket.java:194)
at com.inductiveautomation.ignition.common.sqltags.history.cache.SubCache$BucketHit.getData(SubCache.java:224)
at com.inductiveautomation.ignition.common.sqltags.history.cache.SubCache.getData(SubCache.java:160)
at com.inductiveautomation.ignition.common.sqltags.history.cache.TagHistoryCache.query(TagHistoryCache.java:254)
at com.inductiveautomation.factorypmi.application.gateway.TagHistoryQuery.execute(TagHistoryQuery.java:34)
at com.inductiveautomation.factorypmi.application.gateway.QueryManager$Query.execute(QueryManager.java:690)
at com.inductiveautomation.factorypmi.application.gateway.QueryManager$Query.access$500(QueryManager.java:663)
at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:314)
... 1 more
Caused by: java.lang.IllegalStateException: The maximum row limit (1001) has been reached for this query.
at com.inductiveautomation.ignition.gateway.sqltags.history.query.HistoryWriter.incrementRowCount(HistoryWriter.java:159)
at com.inductiveautomation.ignition.gateway.sqltags.history.query.HistoryWriter.commitRows(HistoryWriter.java:376)
at com.inductiveautomation.ignition.gateway.sqltags.history.query.HistoryWriter.readData(HistoryWriter.java:318)
at com.inductiveautomation.ignition.gateway.sqltags.history.query.HistoryWriter.execute(HistoryWriter.java:230)
at com.inductiveautomation.ignition.gateway.sqltags.SQLTagsManagerImpl.queryHistory(SQLTagsManagerImpl.java:1191)
at com.inductiveautomation.ignition.gateway.project.ProjectSettingsCache$ProjectDefaultTagManagerFacade.queryHistory(ProjectSettingsCache.java:633)
at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.QueryTagHistory.invoke(QueryTagHistory.java:127)
at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:390)
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:85)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:837)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1160)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1092)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
at org.eclipse.jetty.server.Server.handle(Server.java:518)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:308)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:244)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceAndRun(ExecuteProduceConsume.java:246)
at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:156)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572)
at java.lang.Thread.run(null)
Ignition v7.9.0 (b2016101208)
Java: Oracle Corporation 1.8.0_66