Sparkline Problem

Ignition
1

Running 7.5.2 (b1146)

I have a Window that has approximately 40 sparklines on it. They are each bound to history of a single tag per sparkline, for the last 4 hours, with data every minute. Polling mode is “absolute” every 60 seconds.

Occasionally, an error is generated. The error message is:

java.lang.Exception: Error running query:
TagHistory(paths=[wht_lt001_lvl], start=Tue Apr 01 12:11:03 BST 2014, end=Tue Apr 01 16:11:03 BST 2014, flags=0)@60000ms
On: Overview.Overview.Site1.Sump1LevelChart.data
	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: Unexpected error running tag history query.
	at com.inductiveautomation.factorypmi.application.gateway.TagHistoryQuery.execute(TagHistoryQuery.java:39)
	at com.inductiveautomation.factorypmi.application.gateway.QueryManager$Query.execute(QueryManager.java:701)
	at com.inductiveautomation.factorypmi.application.gateway.QueryManager$Query.access$500(QueryManager.java:674)
	at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:315)
	... 1 more
Caused by: java.lang.IllegalArgumentException: Comparison method violates its general contract!
	at java.util.TimSort.mergeLo(Unknown Source)
	at java.util.TimSort.mergeAt(Unknown Source)
	at java.util.TimSort.mergeCollapse(Unknown Source)
	at java.util.TimSort.sort(Unknown Source)
	at java.util.TimSort.sort(Unknown Source)
	at java.util.Arrays.sort(Unknown Source)
	at java.util.Collections.sort(Unknown Source)
	at com.inductiveautomation.ignition.common.sqltags.history.cache.TagHistoryCache.maybeSortBuckets(TagHistoryCache.java:306)
	at com.inductiveautomation.ignition.common.sqltags.history.cache.TagHistoryCache.createRoomFor(TagHistoryCache.java:145)
	at com.inductiveautomation.ignition.common.sqltags.history.cache.TagHistoryCache.registerBucket(TagHistoryCache.java:268)
	at com.inductiveautomation.ignition.common.sqltags.history.cache.SubCache.registerBucketData(SubCache.java:63)
	at com.inductiveautomation.ignition.common.sqltags.history.cache.StandardCacheBucket.getData(StandardCacheBucket.java:212)
	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:247)
	at com.inductiveautomation.factorypmi.application.gateway.TagHistoryQuery.execute(TagHistoryQuery.java:34)
	... 4 more

Ignition v7.5.2 (b1146)
Java: Oracle Corporation 1.7.0_51

Any idea what is happening here?

2

Not sure if this issue is still a topic or not. But, I think this may have been fixed. I would suggest updating to the most recent release of Ignition 7.5, and the latest release of Java, if you have not already.

Also, you might try clearing the tag history cache, found in the menu bar Help>Diagnostics>Clear Tag History Cache