# Transaction group says 853, DB columns say 1021?

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-says-853-db-columns-say-1021/8985>\
**Category:** Ignition\
**Created:** [September 2, 2014, 3:47pm UTC](https://forum.inductiveautomation.com/t/transaction-group-says-853-db-columns-say-1021/8985 "2014-09-02T15:47:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [September 2, 2014, 3:47pm UTC](https://forum.inductiveautomation.com/t/transaction-group-says-853-db-columns-say-1021/8985/1 "2014-09-02T15:47:37Z")

</div>

I have a transaction group that says I have 853 items in it, But when I try to add items to it, It errors out and states the group contains more than the max 1024 columns.

Today I copied the transaction group on a new table and when its created it shows me that the DB creates 1021 columns but the group says 853?

I did an export of the transaction group and counted 1021 tags

Any suggestions why the Transaction group would be off by 168?

Thanks

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [September 3, 2014, 1:08pm UTC](https://forum.inductiveautomation.com/t/transaction-group-says-853-db-columns-say-1021/8985/2 "2014-09-03T13:08:30Z")

</div>

Bueller…  
Bueller…

---

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [September 3, 2014, 1:18pm UTC](https://forum.inductiveautomation.com/t/transaction-group-says-853-db-columns-say-1021/8985/3 "2014-09-03T13:18:33Z")

</div>

I cant help you with your problem but I can suggest that you move to a tall format instead of wide.

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [September 4, 2014, 6:21pm UTC](https://forum.inductiveautomation.com/t/transaction-group-says-853-db-columns-say-1021/8985/4 "2014-09-04T18:21:16Z")

</div>

I’m working with a legacy system where i cant re-do the whole db. Thanks tho…