# Column reverts to null?

**URL:** <https://forum.inductiveautomation.com/t/column-reverts-to-null/19723>\
**Category:** Ignition\
**Created:** [September 18, 2018, 10:13pm UTC](https://forum.inductiveautomation.com/t/column-reverts-to-null/19723 "2018-09-18T22:13:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![AIO](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/aio/32/87549_2.png) [@AIO](https://forum.inductiveautomation.com/u/AIO)\
**Post date:** [September 18, 2018, 10:13pm UTC](https://forum.inductiveautomation.com/t/column-reverts-to-null/19723/1 "2018-09-18T22:13:05Z")

</div>

Hey folks,

We have a fairly widely used table in MSSQL that we just added several columns to, all REAL. I am writing the data to these columns every 5 seconds with query tags, and am having a funny time with one of them.

One of my columns reverts to NULL between writes. If I disable the query, the entire column reverts to NULL. If I change the column name or create a new column, I don’t have the problem.

As far as I know and intended, I only write to this column from these tag queries. Anyone know why they might be doing this? I suspect it’s a lingering tag query setting in the gateway, but I’m not sure.

7.9.7

Cheers,  
Andrew

---

<div class="post-metadata">

**Author:** ![AIO](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/aio/32/87549_2.png) [@AIO](https://forum.inductiveautomation.com/u/AIO)\
**Post date:** [September 19, 2018, 9:39pm UTC](https://forum.inductiveautomation.com/t/column-reverts-to-null/19723/2 "2018-09-19T21:39:00Z")

</div>

Gateway restart solved the issue.