# DataTypes attributes take the value NULL

**URL:** <https://forum.inductiveautomation.com/t/datatypes-attributes-take-the-value-null/30133>\
**Category:** Ignition\
**Created:** [November 21, 2019, 11:27am UTC](https://forum.inductiveautomation.com/t/datatypes-attributes-take-the-value-null/30133 "2019-11-21T11:27:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\
**Post date:** [November 21, 2019, 11:27am UTC](https://forum.inductiveautomation.com/t/datatypes-attributes-take-the-value-null/30133/1 "2019-11-21T11:27:49Z")

</div>

Good morning.

It describes the incident that is currently happening to us in version **7.9.9** of Ignition:

We have created a _DataType_ called “ **Moldeadora** ” composed of other _DataTypes_ (“Alarmas”, “Ciclo”, “Estado”, etc.). These “DataTypes” have attributes of different types: OPC, Memory, SQL Query, etc.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/f54bf60a26892c64c9ffdcb40a1b86891ba2853f.png)

Next we have created **several instances** of the “Moldeadora” _DataType_:

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/1/1f02a145f15972ef02f98dedbe00e57bae7b5158.png)

The **problem** is when you **edit and save** some of the _DataTypes_ that make up the “Moldeadora” _DataType_: OPC and SQL Query type attributes take the _ **NULL** _ value **momentarily** , so that there is a **temporary disconnection** in the clients and in the historical ones.  
For example, if I edit the _DataType_ “Ciclo” and click on “_Apply_”:

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/9/9a6af7225cccab7f065a75e3385f2f7e3834922e.png)

… it happens that all the attributes of all the “Moldeadoras” that are of type _ **OPC** _ or _ **SQL Query** _ pass to _ **NULL** _ momentarily, as if the instances were **being reloaded** , and during that reconnection the values ​​were in _NULL_.

- **Tags** (pass to NULL for a few seconds):

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/262a25761373215d0f689cc45e1083f83b167b9f.png)

- **Client** (loss of connection for a few seconds):

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/d5d534aa35d80b1f723ab4b8e2a0813d481f6288.png)

- **Historical** (loss of records):

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/238c8650c67956487bfc9c4bd7913bb5a1ea2036.png)

It is a serious problem because information is **lost** every time we edit and save a _DataType_.

Best Regards.

---

<div class="post-metadata">

**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\
**Post date:** [November 25, 2019, 1:52pm UTC](https://forum.inductiveautomation.com/t/datatypes-attributes-take-the-value-null/30133/2 "2019-11-25T13:52:35Z")

</div>

Any help please?

---

<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:** [November 25, 2019, 2:05pm UTC](https://forum.inductiveautomation.com/t/datatypes-attributes-take-the-value-null/30133/3 "2019-11-25T14:05:10Z")

</div>

> [@informatica](#):
>
> as if the instances were **being reloaded** , and during that reconnection the values ​​were in _NULL_ .

The instances _ **are** _ being reloaded, and are therefore null briefly. If your process can't handle that, don't edit those data types during production. You can also manually clean up the tag history's nulls if you know you can't avoid an edit.

---

<div class="post-metadata">

**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\
**Post date:** [November 25, 2019, 6:24pm UTC](https://forum.inductiveautomation.com/t/datatypes-attributes-take-the-value-null/30133/4 "2019-11-25T18:24:40Z")

</div>

Ok. Thank you.