# Cannot coerce value into Dataset

**URL:** <https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [March 4, 2020, 6:35pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808 "2020-03-04T18:35:45Z")\
**Posts on this page:** 16\
**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:** [March 4, 2020, 6:35pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/1 "2020-03-04T18:35:45Z")

</div>

Good afternoon.

In Ignition **8.0.9,** when I restart the server I see this error in **logs.** :

_ **Cannot coerce value**'{“columns”:[{“name”:“Fecha\_Hora\_Ejecucion\_Ciclo”,“type”:“java.util.Date”},_  
_{“name”:“Segundos\_Duracion\_Ciclo”,“type”:“java.lang.Float”}],“rows”:[[“Wed Mar 04 18:03:52 GMT 2020”,0.0]]}’ into type: interface com.inductiveautomation.ignition.common.Dataset_

The error is in an instance of this UDT:

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

Best regards.

---

<div class="post-metadata">

**Author:** ![jespinmartin1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jespinmartin1/32/57175_2.png) [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\
**Post date:** [March 4, 2020, 8:07pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/2 "2020-03-04T20:07:29Z")

</div>

Which service are you restarting?  
Do you mean the gateway?

---

<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:** [March 5, 2020, 2:26pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/3 "2020-03-05T14:26:56Z")

</div>

Good afternoon.

The “ **server** ” (OS), no service.

I have done a series of tests that I explain below. I can conclude that there is a serious problem with the data type **“date” in the datasets:**

I have created:

- A tag (data type: dataset) with a **string column** :

- A tag (data type: dataset) with a **date column** :

- A **UDT** with a dataset with a **date column** :

- And an **instance** of the UDT:

As you can see in the images, I have inserted a row in the three datasets.

When I **restart the server** (OS), this happens:

- For the dataset with a **string column** , everything is **correct** :

- For the dataset with a **date column** , its rows and columns are **deleted** (“No Data”):

- For the dataset that is contained in the **UDT** instance, an **error** appears in the **logs** and the dataset **disappears** :

I have verified it in two Gateways: **Windows 10** and **Windows Server 2016**. It is important to know that I am in **Spain** and that the operating systems are configured in **language and format Spanish**. Maybe that is the origin of the incident.

Best Regards.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 5, 2020, 4:47pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/4 "2020-03-05T16:47:02Z")

</div>

I believe this is related to a known bug that’s slated to be fixed pretty soon, but I can’t guarantee that. I would recommend getting in contact with support - they can either confirm it’s the same known issue, or file a new bug ticket for you.

---

<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:** [March 5, 2020, 6:26pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/5 "2020-03-05T18:26:36Z")

</div>

Ok, but it is a serious problem that requires an immediate solution because information is lost when you restart the server.

Thank you.

---

<div class="post-metadata">

**Author:** ![witman](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@witman](https://forum.inductiveautomation.com/u/witman)\
**Post date:** [March 5, 2020, 6:46pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/6 "2020-03-05T18:46:25Z")

</div>

> [@informatica](#):
>
> it is a serious problem that requires an immediate solution

This would be a reason to contact support directly. The forum is great, but not an official support channel so you may or may not get a solution here.

---

<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:** [March 5, 2020, 6:51pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/7 "2020-03-05T18:51:00Z")

</div>

> [@informatica](#):
>
> immediate solution

You should be aware that bug fixes don't happen in hours or even days. They take weeks or sometimes months. If this is code that worked on previous version of Ignition, revert to that version. If this is code that has never worked, you might want to use a work-around (like a string column type) until a bug fix is available. IA doesn't have a stock of magic wands. (It'd sure be nice, though.)

---

<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:** [March 5, 2020, 7:13pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/8 "2020-03-05T19:13:51Z")

</div>

I didn’t want to say “immediate solution,” I wanted to say that you have to be aware that there is a **real bug**.

Sorry for the inconvenience.

---

<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:** [March 31, 2020, 11:28am UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/9 "2020-03-31T11:28:13Z")

</div>

Good Morning.

Is it possible to know when the bug you are referring to will be corrected, in which version?

Best regards.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 31, 2020, 6:08pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/10 "2020-03-31T18:08:21Z")

</div>

The bug I was thinking _might_ be the cause of this is fixed in 8.0.11.

---

<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:** [April 1, 2020, 12:21pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/11 "2020-04-01T12:21:47Z")

</div>

Ok. Thank you.

---

<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:** [April 17, 2020, 5:20pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/12 "2020-04-17T17:20:33Z")

</div>

Good afternoon.

I have upgraded to Ignition **8.0.11** and the issue **continues**.

There is an easier way to reproduce the issue without restarting the server:

- Create a _ **Data Type** _ containing a _ **Dataset** _ with a **date column** and another column of any type.
- Create an **instance** of that _Data Type_ and add some rows with data.
- **Export** the instance to a “.json” file.
- **Delete** the instance.
- **Import** the “.json” file.
- An **error** will occur.

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

Best Regards.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [April 17, 2020, 5:27pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/13 "2020-04-17T17:27:40Z")

</div>

Did you get in contact with support?

---

<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:** [April 17, 2020, 5:34pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/14 "2020-04-17T17:34:34Z")

</div>

Yes, and they referred us to this forum entry. But I am not sure that it is the same issue.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [April 17, 2020, 5:52pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/15 "2020-04-17T17:52:00Z")

</div>

Can you post or PM me the ticket number with support? That’s not what should have happened.

---

<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:** [April 20, 2020, 12:09pm UTC](https://forum.inductiveautomation.com/t/cannot-coerce-value-into-dataset/32808/16 "2020-04-20T12:09:17Z")

</div>

Good Morning.  
I have sent you a private message.
