# History data in trend not working anymore

**URL:** <https://forum.inductiveautomation.com/t/history-data-in-trend-not-working-anymore/80832>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [October 23, 2023, 9:19am UTC](https://forum.inductiveautomation.com/t/history-data-in-trend-not-working-anymore/80832 "2023-10-23T09:19:14Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![samer\_samy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/samer_samy/32/52910_2.png) [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\
**Post date:** [October 23, 2023, 9:19am UTC](https://forum.inductiveautomation.com/t/history-data-in-trend-not-working-anymore/80832/1 "2023-10-23T09:19:14Z")

</div>

Dears,  
Since morning as you see, the history trend is not getting any new reading although the tag is healthy and changes value frequently.

 ![Screenshot 2023-10-23 120123_v2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/c/cc5b238cb14d921adabf749973eb6566dc3928dd.png)

 ![Screenshot 2023-10-23 120123](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/b/6b0d6de4473a76c467fd4b8391e5a1067ad9aebf.png)

 ![Screenshot 2023-10-23 120123_v3](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/3/f39c76e3192c38e0e87e72ca43f9d2f0647a7ce0.png)

I restarted the gateway but still same problem, Any suggestion pls.

---

<div class="post-metadata">

**Author:** ![samer\_samy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/samer_samy/32/52910_2.png) [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\
**Post date:** [October 23, 2023, 11:48am UTC](https://forum.inductiveautomation.com/t/history-data-in-trend-not-working-anymore/80832/2 "2023-10-23T11:48:21Z")

</div>

I found that the disk driver for DB is full ,I deleted some unneeded data to have more space .

but still the data not updated till now

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [October 23, 2023, 12:06pm UTC](https://forum.inductiveautomation.com/t/history-data-in-trend-not-working-anymore/80832/3 "2023-10-23T12:06:52Z")

</div>

Did you restart the DB after that, too?

---

<div class="post-metadata">

**Author:** ![samer\_samy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/samer_samy/32/52910_2.png) [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\
**Post date:** [October 23, 2023, 12:18pm UTC](https://forum.inductiveautomation.com/t/history-data-in-trend-not-working-anymore/80832/4 "2023-10-23T12:18:26Z")

</div>

I just restarted the DB server now,and also restarted sql services ,is that what you mean ?

 ![Screenshot 2023-10-23 120123_v4](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/9/c902cd15f68c46bf29c7357f630eb9276510c5bc.png)  
I can see some transaction groups that were stopped before ,now are working back,But still the historical data not working since 3 am today morning.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [October 23, 2023, 12:28pm UTC](https://forum.inductiveautomation.com/t/history-data-in-trend-not-working-anymore/80832/5 "2023-10-23T12:28:05Z")

</div>

You probably have a pile of data stuck in your store-and-forward subsystem that will have to flush itself out before your system stabilizes. You may have to restart Ignition again now that the DB is working.

Sounds like you need to implement some server status monitoring in an external system. Nagios is popular for such things.

---

<div class="post-metadata">

**Author:** ![samer\_samy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/samer_samy/32/52910_2.png) [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\
**Post date:** [October 23, 2023, 12:37pm UTC](https://forum.inductiveautomation.com/t/history-data-in-trend-not-working-anymore/80832/6 "2023-10-23T12:37:51Z")

</div>

I restarted Ignition server but still same ,history reading stopped at 3 am.

update : I made a new clean DB and change tag history location from old DB to this one and will start record on the new one

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [October 23, 2023, 1:14pm UTC](https://forum.inductiveautomation.com/t/history-data-in-trend-not-working-anymore/80832/7 "2023-10-23T13:14:31Z")

</div>

You could have just gone to the store forward system and told it to retry the cached queries

---

<div class="post-metadata">

**Author:** ![samer\_samy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/samer_samy/32/52910_2.png) [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\
**Post date:** [October 24, 2023, 7:57am UTC](https://forum.inductiveautomation.com/t/history-data-in-trend-not-working-anymore/80832/8 "2023-10-24T07:57:00Z")

</div>

I also needed to change the historical data to be real time data then turn back to historical data to refresh the binding .

 ![Screenshot 2023-10-23 120123_v3](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/3/f39c76e3192c38e0e87e72ca43f9d2f0647a7ce0.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [October 24, 2023, 10:54am UTC](https://forum.inductiveautomation.com/t/history-data-in-trend-not-working-anymore/80832/9 "2023-10-24T10:54:16Z")

</div>

You are using end date = `now(0)`. The zero means no polling. Set it to some non-zero milliseconds to control how often the binding runs (and therefore how often the chart updates).
