We are pulling data from a historian to display daily totals by looking at an on change of a daily snapshot. The tag is updating each day as it should. We have it filtered to look between the date our system went live following commissioning and [System]Gateway/CurrentDateTime. This was working find over 1.5 years and then stopped showing new information. I updated the End Date Binding to be 100 years out and that worked. However my customer recently showed me that we have no new data from a few days after we left, it stopped updating again.
The gateway is 8.1.4 and our SQL database is MySQL. Any limitations we may be running into?
I would start by contacting our support department officially; there are a lot of things that are easier to troubleshoot live.
The obvious first step is to check whether the issue is with the gateway or database, and the actual storage of history data, vs just focusing on the client.
One possible explanation is a drift in local system time; mostly supported by it "working" when you set the end time far out in the future.