I added history to a tag so that it may be used on an Easy Chart. I set up the Easy Chart and tested everything. I didn’t receive a quick response from the the query, so I checked the gateway’s Database Connections status. There was one query stuck in execution. I was able to clear it by editing the database connection and saving. I played around with the Easy Chart and found that its query would get ‘stuck’ every time the Easy Chart time frame included a time prior to the tag being historized. For example, I added history to the tag at about 3PM today. When the Easy Chart time window extended before 3PM the query would get stuck and I’d have to clear it. If I let the query continue to run I’ll get an eror pop-up box with a Gateway Error 500 stating the datasource is faulted. This also occurs on Easy Charts for other tags when I extend the time frame back prior to the tag being historized.
Is there a fix/work around for this?