# Still having transaction group error issues

**URL:** <https://forum.inductiveautomation.com/t/still-having-transaction-group-error-issues/6469>\
**Category:** Ignition\
**Created:** [May 14, 2013, 3:32pm UTC](https://forum.inductiveautomation.com/t/still-having-transaction-group-error-issues/6469 "2013-05-14T15:32:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\
**Post date:** [May 14, 2013, 3:32pm UTC](https://forum.inductiveautomation.com/t/still-having-transaction-group-error-issues/6469/1 "2013-05-14T15:32:27Z")

</div>

At customer’s site after installing V7.5.7 to resolve PLC communication errors, and I still have this occassional error pop up:

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a619d0601eda6fdd7fa8e14632622e9360d53c52.jpg)  

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/9/9fa8205efb702cc168171333693e4393b9b7a43a.jpg)  

This is a Mission Critical application using MySQL 5.1 with replication enabled

---

<div class="post-metadata">

**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\
**Post date:** [May 14, 2013, 3:48pm UTC](https://forum.inductiveautomation.com/t/still-having-transaction-group-error-issues/6469/2 "2013-05-14T15:48:17Z")

</div>

I may have answered my own question. I think I have a timing issue between the the time the OPC items update and the trigger fires. I have a 2 second delay in the PLC program to move data into all the OPC items , then fire the trigger bit. I think 2 seconds may be borderline, as in a recent install at another location I noticed a 2 -3 second delay in update time for all tags in the Basic OPC items.

In this case because my OPC group did not get an updated Primary Key (Batchnumber) in time before the trigger fired, the duplicate primary key error was generated.

---

<div class="post-metadata">

**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\
**Post date:** [May 15, 2013, 4:23am UTC](https://forum.inductiveautomation.com/t/still-having-transaction-group-error-issues/6469/3 "2013-05-15T04:23:32Z")

</div>

as a general rule of thumb I found that If i have a delay to set the trigger of at least 3 times the transaction group update time I will always see the proper updated data to be recorded.