# Transaction Groups (gives Store and Forward error)

**URL:** <https://forum.inductiveautomation.com/t/transaction-groups-gives-store-and-forward-error/67955>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [December 23, 2022, 10:08am UTC](https://forum.inductiveautomation.com/t/transaction-groups-gives-store-and-forward-error/67955 "2022-12-23T10:08:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![iscrac](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/iscrac/32/49757_2.png) [@iscrac](https://forum.inductiveautomation.com/u/iscrac)\
**Post date:** [December 23, 2022, 10:08am UTC](https://forum.inductiveautomation.com/t/transaction-groups-gives-store-and-forward-error/67955/1 "2022-12-23T10:08:19Z")

</div>

Hi Everyone,

I have configured Transaction Group which executes only when tag has changed its value...  
so..  
Somehow not every time, but... the fact is that I get error like

 ![SQL ERROR. Puhvermahuti](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/d/6d817e95da50e8f124aee5471900771ba274d2aa.png)

These data do not change for long time... and I suspect that when I update the project, Ignition tries to insert the data to sql table, but off course, these are duplicated values...

Or... what it might be?  
how to avoid this error?

Any help will be VERY appriciated! 🥰

---

<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:** [December 23, 2022, 1:34pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-gives-store-and-forward-error/67955/2 "2022-12-23T13:34:02Z")

</div>

There's a setting called "prevent trigger due to group start" or similar. Use that.

---

<div class="post-metadata">

**Author:** ![iscrac](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/iscrac/32/49757_2.png) [@iscrac](https://forum.inductiveautomation.com/u/iscrac)\
**Post date:** [December 28, 2022, 10:04am UTC](https://forum.inductiveautomation.com/t/transaction-groups-gives-store-and-forward-error/67955/3 "2022-12-28T10:04:16Z")

</div>

Thanx so much, but I don't use a trigger..  
it's the problem

---

<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:** [December 28, 2022, 1:24pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-gives-store-and-forward-error/67955/4 "2022-12-28T13:24:05Z")

</div>

> [@iscrac](#):
>
> which executes only when tag has changed its value

That's a trigger.