# Historical Transaction Group Problem

**URL:** <https://forum.inductiveautomation.com/t/historical-transaction-group-problem/9729>\
**Category:** Ignition\
**Created:** [February 19, 2015, 7:19am UTC](https://forum.inductiveautomation.com/t/historical-transaction-group-problem/9729 "2015-02-19T07:19:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dhananjay\_vichare](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dhananjay_vichare/32/74712_2.png) [@dhananjay\_vichare](https://forum.inductiveautomation.com/u/dhananjay_vichare)\
**Post date:** [February 19, 2015, 7:19am UTC](https://forum.inductiveautomation.com/t/historical-transaction-group-problem/9729/1 "2015-02-19T07:19:52Z")

</div>

Hi,  
I am logging some flow total tags to MySQL server database, using Historical transaction group for every one second.

My observations.

1. In Transaction group configuration window, tag value showing “52228501504.000”. Please refer below screen shot “TransctionGroupView.PNG”
2. If I retrieve the records from MySQL server for the same date time i.e. “2015-02-19 12:13:10”, it showing different like “52228500000”. Please refer below screen shot “MySQLWorkbenchView.PNG”
3. I am able to understand why the last five digits of the values change automatically to “0” zero.

Due to this the daily production gets affected.  
Please help me on this. ![:prayer:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e5a7e3b63facc151ea73e3b45db7bdb3d4bdc316.gif ":prayer:")  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/bc95363c5f244140a2dfc927872a2d95f6be8bc2.PNG)

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/7e7f0edf188e2c2b708defd647ea7b9cc0e55a62.PNG)

---

<div class="post-metadata">

**Author:** ![dhananjay\_vichare](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dhananjay_vichare/32/74712_2.png) [@dhananjay\_vichare](https://forum.inductiveautomation.com/u/dhananjay_vichare)\
**Post date:** [February 19, 2015, 8:47am UTC](https://forum.inductiveautomation.com/t/historical-transaction-group-problem/9729/2 "2015-02-19T08:47:46Z")

</div>

Hello,  
I have changed the column data type from FLOAT to FLOAT(24,2) in MySQL and It is working fine. I am getting same values in Ignition and MySQL table.

I want to know is it correct method? ![:prayer:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e5a7e3b63facc151ea73e3b45db7bdb3d4bdc316.gif ":prayer:")

---

<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:** [February 24, 2015, 7:48pm UTC](https://forum.inductiveautomation.com/t/historical-transaction-group-problem/9729/3 "2015-02-24T19:48:15Z")

</div>

Hi,

Yes, I think that’s fine. I was going to suggest looking at the data types in the db. We probably need to look at our default settings to help people avoid this same problem in the future.

Regards,

---

<div class="post-metadata">

**Author:** ![dhananjay\_vichare](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dhananjay_vichare/32/74712_2.png) [@dhananjay\_vichare](https://forum.inductiveautomation.com/u/dhananjay_vichare)\
**Post date:** [March 4, 2015, 8:52am UTC](https://forum.inductiveautomation.com/t/historical-transaction-group-problem/9729/4 "2015-03-04T08:52:15Z")

</div>

Thanks Colby.Clegg 😃