# Data Storage Issue

**URL:** <https://forum.inductiveautomation.com/t/data-storage-issue/2648>\
**Category:** Ignition\
**Created:** [February 17, 2011, 2:00pm UTC](https://forum.inductiveautomation.com/t/data-storage-issue/2648 "2011-02-17T14:00:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vdesai](https://avatars.discourse-cdn.com/v4/letter/v/4bbf92/32.png) [@vdesai](https://forum.inductiveautomation.com/u/vdesai)\
**Post date:** [February 17, 2011, 2:00pm UTC](https://forum.inductiveautomation.com/t/data-storage-issue/2648/1 "2011-02-17T14:00:58Z")

</div>

Hello,

I have around 8 transaction groups running. All groups log data into MYSQL using a trigger and for each database entry a timestamp is generated. Timestamp does not come from Ignition, but from MYSQL. Also, I have a serial number generated by MYSQL for each entry.

I am having issue with two of the groups in storing data. The trigger becomes active, database storage is triggered, I see an entry made in the database with a serial number and timestamp which tells me trigger works fine. The other fields in DB populated by OPC tags remain blank.

Also, when I do not run the client and just monitor values in my designer for the OPC tags, they are updated real-time.

I do not understand as to why no data is written into MYSQL.

Thanks,  
Vishal

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/fdb365aae4c0cdddb187259d6262444a3781f163.JPG)

---

<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 17, 2011, 5:09pm UTC](https://forum.inductiveautomation.com/t/data-storage-issue/2648/2 "2011-02-17T17:09:28Z")

</div>

Could you perhaps export the group to xml and post it (right click on the group, export)? Maybe it’s something simple in the configuration.

Regards,

---

<div class="post-metadata">

**Author:** ![vdesai](https://avatars.discourse-cdn.com/v4/letter/v/4bbf92/32.png) [@vdesai](https://forum.inductiveautomation.com/u/vdesai)\
**Post date:** [February 17, 2011, 6:47pm UTC](https://forum.inductiveautomation.com/t/data-storage-issue/2648/3 "2011-02-17T18:47:43Z")

</div>

There you go. File attached. Also, I have tried different update rates but no success.  
Thanks,  
Vishal  
[H\_arm\_Group.xml](https://us1.discourse-cdn.com/inductiveautomation/original/1X/f82553f91d16b15a322389a18e4ee279841658fa.xml) (95.2 KB)

---

<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 18, 2011, 6:17pm UTC](https://forum.inductiveautomation.com/t/data-storage-issue/2648/4 "2011-02-18T18:17:27Z")

</div>

Hello,

Sorry I didn’t get back to you yesterday. As I thought, I believe the problem is a simple configuration mistake- the update mode (second property on the “Action” tab of the group) is set to “bi-directional”. Switch that to “OPC to DB” and the group should log correctly.

Obviously this should be fixed in the software- while bi-directional doesn’t make sense for inserting rows, it should still log the values. Really, it shouldn’t even allow you to set it up like that.

Regards,