# Missing Data from Transaction Group Queries

**URL:** <https://forum.inductiveautomation.com/t/missing-data-from-transaction-group-queries/60314>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [June 2, 2022, 6:48pm UTC](https://forum.inductiveautomation.com/t/missing-data-from-transaction-group-queries/60314 "2022-06-02T18:48:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AIO](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/aio/32/87549_2.png) [@AIO](https://forum.inductiveautomation.com/u/AIO)\
**Post date:** [June 2, 2022, 6:48pm UTC](https://forum.inductiveautomation.com/t/missing-data-from-transaction-group-queries/60314/1 "2022-06-02T18:48:37Z")

</div>

Hey folks,

I’ve got a bit of a quandary here.

Working on a site with a series of transaction groups for logging and pruning historical data on tanks. Effectively we have a table with the current status of all tanks in the facility that is constantly updated.

From here, there is a transaction group that runs every 10 minutes with a triggered expression that copies the “current status” table above and inserts that data into a “historical table”. Should be roughly 200 rows every 10 minutes.

We’re seeing 5-15 missing entries (an entry being 200 rows) over the course of the month, but I have no indication of what is causing the failure.

Is there a better way to execute these queries? Is this better served in a scripting block? Are there other changes we could implement to increase reliability?

Many thanks.

---

<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:** [June 2, 2022, 6:57pm UTC](https://forum.inductiveautomation.com/t/missing-data-from-transaction-group-queries/60314/2 "2022-06-02T18:57:51Z")

</div>

Is the transaction group set to automatically delete rows? That works asyncronously from the group.

I’d say scripting the transfer and purge wqould be the way to go.

---

<div class="post-metadata">

**Author:** ![AIO](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/aio/32/87549_2.png) [@AIO](https://forum.inductiveautomation.com/u/AIO)\
**Post date:** [June 2, 2022, 7:40pm UTC](https://forum.inductiveautomation.com/t/missing-data-from-transaction-group-queries/60314/3 "2022-06-02T19:40:47Z")

</div>

So in this specific instance, the data being fed into the “current status” table is an update query. I misspoke, there is no pruning of the table occurring here, and delete records is not checked.

We have another table (unrelated to this one) that copies / prunes data via a series of queries in transaction group triggered expressions. I suspect the copy and prune are not occurring in the same order consistently, leading to the missing data, but I can’t be sure.

I’ll try moving the function to a gateway script and see if performance improves.

Thanks, Jordan.