# Transaction group pulling false information from SQL Database

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-pulling-false-information-from-sql-database/76590>\
**Category:** Ignition\
**Created:** [July 19, 2023, 3:02pm UTC](https://forum.inductiveautomation.com/t/transaction-group-pulling-false-information-from-sql-database/76590 "2023-07-19T15:02:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Phoebe\_Nguyen](https://avatars.discourse-cdn.com/v4/letter/p/7993a0/32.png) [@Phoebe\_Nguyen](https://forum.inductiveautomation.com/u/Phoebe_Nguyen)\
**Post date:** [July 19, 2023, 3:02pm UTC](https://forum.inductiveautomation.com/t/transaction-group-pulling-false-information-from-sql-database/76590/1 "2023-07-19T15:02:12Z")

</div>

Hi guys, please help me figure out why my transaction group keeps receiving false information from the database.  
I set up a transaction group to transfer data from SQL database to PLC tags. When the trigger executes, we use a spec number to look for all information related to this spec number and send the info to the transaction group tags, which then transfer to PLC tags. Out of 70 tags, there are two binary tags with similar names (CommandHorizontal and Command Vertical). Every once in a while, the information of these tags, after the trigger executes, does not match with the information from the database.

For example:  
\_ SQL database: CommandHorizontal == 0, CommandVerical ==1  
\_ Transaction Group: CommandHorizontal ==1, CommandVertical ==0

I attached some pictures of the Action setting and Trigger setting

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/d/fd0f24740c3845bb84f5d911e4726bc58681a61b.jpeg)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/b/7b3b09911a8fa005ab9a506dd763a8d14c39549f.jpeg)

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [July 21, 2023, 10:46am UTC](https://forum.inductiveautomation.com/t/transaction-group-pulling-false-information-from-sql-database/76590/2 "2023-07-21T10:46:41Z")

</div>

I'd say the issue is trying to run it at 50ms if you trigger before other tags have updated, then you have a race condition, especially if the update rate on SpecNumber is slower than your transaction group.