# Historical value writing over itself in SQL

**URL:** <https://forum.inductiveautomation.com/t/historical-value-writing-over-itself-in-sql/79537>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [September 23, 2023, 12:07am UTC](https://forum.inductiveautomation.com/t/historical-value-writing-over-itself-in-sql/79537 "2023-09-23T00:07:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Asya\_Sergoyan](https://avatars.discourse-cdn.com/v4/letter/a/3bc359/32.png) [@Asya\_Sergoyan](https://forum.inductiveautomation.com/u/Asya_Sergoyan)\
**Post date:** [September 23, 2023, 12:07am UTC](https://forum.inductiveautomation.com/t/historical-value-writing-over-itself-in-sql/79537/1 "2023-09-23T00:07:35Z")

</div>

We are running Ignition 8.1 and have been collecting tag history on many tags. At 12:51 we randomly stopped collecting tag history and I can't understand why. See below for the historical export for every minute of a temperature tag. Notice how we have a fresh value at every minute until 12:51, then after the next historical value is the current value (I ran the export at 6PM). Every time I run it, it just writes over itself. Any ideas what could be causing this?

 ![Historical Expo](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/1/e148945e27ba30ea76889816b3ab9ef92d08f408.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:** [September 23, 2023, 12:21am UTC](https://forum.inductiveautomation.com/t/historical-value-writing-over-itself-in-sql/79537/2 "2023-09-23T00:21:53Z")

</div>

Hmm. Never seen anything like that. You should contact support.