# Problem with the Block Transaction Group

**URL:** <https://forum.inductiveautomation.com/t/problem-with-the-block-transaction-group/82209>\
**Category:** Ignition\
**Created:** [November 21, 2023, 5:10pm UTC](https://forum.inductiveautomation.com/t/problem-with-the-block-transaction-group/82209 "2023-11-21T17:10:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Roger\_Denison](https://avatars.discourse-cdn.com/v4/letter/r/e19b73/32.png) [@Roger\_Denison](https://forum.inductiveautomation.com/u/Roger_Denison)\
**Post date:** [November 21, 2023, 5:10pm UTC](https://forum.inductiveautomation.com/t/problem-with-the-block-transaction-group/82209/1 "2023-11-21T17:10:43Z")

</div>

I used to build Block transaction groups back in the days of FactorySQL but now I'm having issues doing the same in Ignition.

I have a table in the database with X, Y, and Z positional data in 10 rows. I want to write those values into the PLC tags. I created a Block xaction group with Items for X, Y, and Z (10 elements each). I also added three boolean tags to the Basic OPC Group collection. These are used to 1) trigger the TG, 2) report a success, and 3) report a failure. Let's call the (1) tag "LoadPosData". The mode is 'DB to OPC' and the Table Action is Update/Select, custom, Where PosID \> 0. PosID is also the Custom Index Column.

When I trigger the TG, I get a failure that states "Invalid column name 'LoadPosData'". But LoadPosData is not part of the Block Group. It's only used in the Basic Group for triggering. I have tried setting it to "Read Only" (not related to anything in the db) but I still keep getting the error.

What am I missing? I used to think Block TGs were awesome. Now they're becoming a pain in the association of Ignition developers...

---

<div class="post-metadata">

**Author:** ![Roger\_Denison](https://avatars.discourse-cdn.com/v4/letter/r/e19b73/32.png) [@Roger\_Denison](https://forum.inductiveautomation.com/u/Roger_Denison)\
**Post date:** [November 21, 2023, 11:12pm UTC](https://forum.inductiveautomation.com/t/problem-with-the-block-transaction-group/82209/2 "2023-11-21T23:12:12Z")

</div>

I figured it out. I went into "Block View" and saw the elusive column requirement. Fixed that and now I'm running, just like in the good ol' days.