# Table Tag History Queries No Longer Work **URL:** \ **Category:** Ignition\ **Created:** [October 15, 2011, 1:03pm UTC](https://forum.inductiveautomation.com/t/table-tag-history-queries-no-longer-work/3440 "2011-10-15T13:03:05Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Duffanator](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/duffanator/32/3560_2.png) [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Post date:** [October 15, 2011, 1:03pm UTC](https://forum.inductiveautomation.com/t/table-tag-history-queries-no-longer-work/3440/1 "2011-10-15T13:03:05Z")
Hey guys, I just upgraded to 7.3 and everything looks good except all of my tables that query a tag history. I keep getting a Java date exception and I’m not sure if I need to change something or if this is just a bug. Here’s the tag history query and the associated error: ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/c98dadd81e577a65e1c3dc4dc407bdf5388eb0f5.PNG) Let me know what I can do, thanks! ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [October 17, 2011, 4:12pm UTC](https://forum.inductiveautomation.com/t/table-tag-history-queries-no-longer-work/3440/2 "2011-10-17T16:12:52Z")
Can you paste the “full” details of the error message here? (your screenshot only shows the compact info) ---
**Author:** ![Duffanator](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/duffanator/32/3560_2.png) [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Post date:** [October 17, 2011, 4:15pm UTC](https://forum.inductiveautomation.com/t/table-tag-history-queries-no-longer-work/3440/3 "2011-10-17T16:15:47Z")
Sure, here you go: [quote]java.lang.Exception: Error running query: TagHistory(paths=[pump house/pump 4 status], start=Sat Oct 15 00:00:00 EDT 2011, end=Mon Oct 17 23:59:59 EDT 2011, flags=0)@30000ms On: PumpPopup.Root Container.Table.data at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:316) 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:697) at com.inductiveautomation.factorypmi.application.gateway.QueryManager$Query.access$500(QueryManager.java:670) at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:314) … 1 more Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to java.util.Date at com.inductiveautomation.ignition.common.sqltags.history.cache.TimeMaskedDataset.locateRow(TimeMaskedDataset.java:62) at com.inductiveautomation.ignition.common.sqltags.history.cache.TimeMaskedDataset.(TimeMaskedDataset.java:38) at com.inductiveautomation.ignition.common.sqltags.history.cache.TimeMaskedDataset.(TimeMaskedDataset.java:31) at com.inductiveautomation.ignition.common.sqltags.history.cache.SubCache.wrapDS(SubCache.java:191) at com.inductiveautomation.ignition.common.sqltags.history.cache.SubCache$BucketHit.getData(SubCache.java:213) at com.inductiveautomation.ignition.common.sqltags.history.cache.SubCache.getData(SubCache.java:150) at com.inductiveautomation.ignition.common.sqltags.history.cache.TagHistoryCache.query(TagHistoryCache.java:231) at com.inductiveautomation.factorypmi.application.gateway.TagHistoryQuery.execute(TagHistoryQuery.java:34) … 4 more Ignition v7.3.0 (b460) Java: Sun Microsystems Inc. 1.6.0\_24 [/quote] ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [October 17, 2011, 5:47pm UTC](https://forum.inductiveautomation.com/t/table-tag-history-queries-no-longer-work/3440/4 "2011-10-17T17:47:52Z")
Hi, It appears to be a problem with the tag query cache and “tall” return formats. We should be able to get it fixed for the 7.3.1 update (we’ll try to get a beta 4 up this afternoon). In the mean time, you could turn off the query cache by going to Configuration\>Properties\>General in the designer. It looks like there might be some other things going on with “tall” mode (I’m getting an incorrect quality value), but at least the values come in. Regards, ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [October 17, 2011, 8:37pm UTC](https://forum.inductiveautomation.com/t/table-tag-history-queries-no-longer-work/3440/5 "2011-10-17T20:37:49Z")
Ok, just to confirm: this will be fixed in 7.3.1. You can turn off the history cache for now, if you want. The “quality issue” isn’t so bad- it wasn’t quite correct, but it shouldn’t make much of an impact. It was returning “Good, Provisional”, which basically means a “good” value that shouldn’t be cached. Anyhow, that’s been fixed as well. I suspect a beta will be up this afternoon (beta 4). Regards, ---
**Author:** ![Duffanator](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/duffanator/32/3560_2.png) [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Post date:** [October 21, 2011, 1:35pm UTC](https://forum.inductiveautomation.com/t/table-tag-history-queries-no-longer-work/3440/6 "2011-10-21T13:35:39Z")
The 7.3.1 update fixed this issue as well. Thanks again!