# Delete records older then - Transaction Group

**URL:** <https://forum.inductiveautomation.com/t/delete-records-older-then-transaction-group/21189>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [December 3, 2018, 9:52am UTC](https://forum.inductiveautomation.com/t/delete-records-older-then-transaction-group/21189 "2018-12-03T09:52:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![c.bertulli](https://avatars.discourse-cdn.com/v4/letter/c/f19dbf/32.png) [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\
**Post date:** [December 3, 2018, 9:52am UTC](https://forum.inductiveautomation.com/t/delete-records-older-then-transaction-group/21189/1 "2018-12-03T09:52:02Z")

</div>

Hi All,

I have a Transaction Group set as follow:  
-Execution Scheduling: “Timer ( 450 ms )”  
-Update Mode: “OPC to DB”  
-Data Source: “MyDatabase”  
-Table Name: “MyTable”  
-Automatically create table: TRUE  
-Use custom index column: FALSE  
-Store Timestamp to: TRUE (“DateAndTime”)  
-Store quality code to: FALSE  
-Delete records older than: 60 minutes  
-Table Action: Insert New Row

This transaction group is not deleting records older than 60 minutes. I have left this Transaction Group “alone” for a week and when I came up today, it had more than 11 million rows…  
I know I can easily create a script for deleting records, but why is this option not working? Am I missing something?

---

<div class="post-metadata">

**Author:** ![ethomason](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ethomason/32/43338_2.png) [@ethomason](https://forum.inductiveautomation.com/u/ethomason)\
**Post date:** [December 3, 2018, 3:19pm UTC](https://forum.inductiveautomation.com/t/delete-records-older-then-transaction-group/21189/2 "2018-12-03T15:19:09Z")

</div>

Could be a bug, could be a permissions issue. Is there anything in the log?

---

<div class="post-metadata">

**Author:** ![c.bertulli](https://avatars.discourse-cdn.com/v4/letter/c/f19dbf/32.png) [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\
**Post date:** [December 3, 2018, 4:00pm UTC](https://forum.inductiveautomation.com/t/delete-records-older-then-transaction-group/21189/3 "2018-12-03T16:00:22Z")

</div>

Nothing inside the logs.  
I’ve checked the database permission and I can delete stuff 🙂  
Do you suggest to make a script for “delete records older than…”?

---

<div class="post-metadata">

**Author:** ![ethomason](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ethomason/32/43338_2.png) [@ethomason](https://forum.inductiveautomation.com/u/ethomason)\
**Post date:** [December 3, 2018, 4:14pm UTC](https://forum.inductiveautomation.com/t/delete-records-older-then-transaction-group/21189/4 "2018-12-03T16:14:48Z")

</div>

> [@c.bertulli](#):
>
> Do you suggest to make a script for "delete records older than.."?

Only as a last resort, I suggest contacting support first.

---

<div class="post-metadata">

**Author:** ![c.bertulli](https://avatars.discourse-cdn.com/v4/letter/c/f19dbf/32.png) [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\
**Post date:** [December 3, 2018, 4:22pm UTC](https://forum.inductiveautomation.com/t/delete-records-older-then-transaction-group/21189/5 "2018-12-03T16:22:39Z")

</div>

Ok, I’ll do that.  
In the meantime I’ll go with the script.

Thanks for the support 🙂