Table Tag History Queries No Longer Work

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:


Let me know what I can do, thanks!

Can you paste the “full” details of the error message here? (your screenshot only shows the compact info)

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]

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,

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,

The 7.3.1 update fixed this issue as well. Thanks again!