# 'Data truncated' for timestamp in block transaction group

**URL:** <https://forum.inductiveautomation.com/t/data-truncated-for-timestamp-in-block-transaction-group/5256>\
**Category:** Ignition\
**Created:** [October 10, 2012, 2:25pm UTC](https://forum.inductiveautomation.com/t/data-truncated-for-timestamp-in-block-transaction-group/5256 "2012-10-10T14:25:39Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![chi](https://avatars.discourse-cdn.com/v4/letter/c/0ea827/32.png) [@chi](https://forum.inductiveautomation.com/u/chi)\
**Post date:** [October 10, 2012, 2:25pm UTC](https://forum.inductiveautomation.com/t/data-truncated-for-timestamp-in-block-transaction-group/5256/1 "2012-10-10T14:25:39Z")

</div>

Hi,

i get a 'java.sql.BatchUpdateException: Data truncated for column ‘t\_stamp’ error in a block transaction group.  
The value for the t\_stamp column is a OPC timestamp set to datatype ‘Int 8’, the target column is a mySQL bigint.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/ce271f17d5de121c3b09fe4e026447c94de85e21.PNG)  
  
In a standard transaction group, the same configuration works. Is there something different when converting a timestamp to ‘Int 8’ in a block group, or is there any better way to get an UTC millisecond timestamp into the database?

---

<div class="post-metadata">

**Author:** ![Michael.Stofan](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/michael.stofan/32/3342_2.png) [@Michael.Stofan](https://forum.inductiveautomation.com/u/Michael.Stofan)\
**Post date:** [October 15, 2012, 4:48pm UTC](https://forum.inductiveautomation.com/t/data-truncated-for-timestamp-in-block-transaction-group/5256/2 "2012-10-15T16:48:25Z")

</div>

There might be a difference in how it’s handled internally. I’ll look into it.

What version of Ignition are you running?

---

<div class="post-metadata">

**Author:** ![chi](https://avatars.discourse-cdn.com/v4/letter/c/0ea827/32.png) [@chi](https://forum.inductiveautomation.com/u/chi)\
**Post date:** [October 15, 2012, 7:36pm UTC](https://forum.inductiveautomation.com/t/data-truncated-for-timestamp-in-block-transaction-group/5256/3 "2012-10-15T19:36:14Z")

</div>

I’m using 7.5.4 beta1.  
I just found out the difference to the standard group now. There i used a SQLTag and referenced the ‘LastChange’ property (tag\_LastChange). This property is converted to Int8 without problems.  
The conversion seems to be ignored, if the ‘LastChange’ property is selected under ‘Value Mode’ in the group tag configuration, but this happens for all types of groups.  
Sorry for the confusion in my first post.

---

<div class="post-metadata">

**Author:** ![Michael.Stofan](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/michael.stofan/32/3342_2.png) [@Michael.Stofan](https://forum.inductiveautomation.com/u/Michael.Stofan)\
**Post date:** [October 16, 2012, 4:59pm UTC](https://forum.inductiveautomation.com/t/data-truncated-for-timestamp-in-block-transaction-group/5256/4 "2012-10-16T16:59:01Z")

</div>

I’ve been trying to reproduce this problem without success. Would you be able to post or email an export of your transaction group?

---

<div class="post-metadata">

**Author:** ![chi](https://avatars.discourse-cdn.com/v4/letter/c/0ea827/32.png) [@chi](https://forum.inductiveautomation.com/u/chi)\
**Post date:** [October 16, 2012, 8:12pm UTC](https://forum.inductiveautomation.com/t/data-truncated-for-timestamp-in-block-transaction-group/5256/5 "2012-10-16T20:12:49Z")

</div>

Ok, forget my last post, it is only reproducable for block groups.  
Here is the group export and a screenshot of the error.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/d7f95dd1d39a770a939c2c59f6372cae8152959e.PNG)  
  
[block\_group.xml](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/70be508a53f9739e617bb0c85388ae259e405e6f.xml) (2.22 KB)

---

<div class="post-metadata">

**Author:** ![Michael.Stofan](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/michael.stofan/32/3342_2.png) [@Michael.Stofan](https://forum.inductiveautomation.com/u/Michael.Stofan)\
**Post date:** [October 16, 2012, 10:12pm UTC](https://forum.inductiveautomation.com/t/data-truncated-for-timestamp-in-block-transaction-group/5256/6 "2012-10-16T22:12:29Z")

</div>

Thanks for the group export. I was able to reproduce the problem. It does appear that the standard group is casting the timestamp to a INT8, whereas the block group is not. I’ll make a ticket for it in our system.

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [October 18, 2012, 8:52pm UTC](https://forum.inductiveautomation.com/t/data-truncated-for-timestamp-in-block-transaction-group/5256/7 "2012-10-18T20:52:06Z")

</div>

Hi,

This will be fixed for 7.5.4, however, in researching it I noticed that this is only a problem with the block group when using store and forward. You can get around the issue until the next release by going to “Options” on the group and selecting “bypass store and forward”.

Regards,