# Transaction Groups: Expression Item: A tag executor could not be created for the Item **URL:** \ **Category:** Ignition\ **Tags:** ignition80\ **Created:** [June 15, 2021, 10:17am UTC](https://forum.inductiveautomation.com/t/transaction-groups-expression-item-a-tag-executor-could-not-be-created-for-the-item/47777 "2021-06-15T10:17:27Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![iain.blackwood](https://avatars.discourse-cdn.com/v4/letter/i/ea5d25/32.png) [@iain.blackwood](https://forum.inductiveautomation.com/u/iain.blackwood)\ **Post date:** [June 15, 2021, 10:17am UTC](https://forum.inductiveautomation.com/t/transaction-groups-expression-item-a-tag-executor-could-not-be-created-for-the-item/47777/1 "2021-06-15T10:17:27Z")
Hi Guys, I am having some issues with a transaction group, in particular a run-always expression item. When I try to start the transaction group I get the following messages in the status & events tab: ![Status](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/e/be7192d424598fdadb34c4d4cadb37c202ec934f.png) I have removed all items from the group so only the offending item is in the transaction group. The target table has been adjusted so that only the ID, TimeStamp and item are columns. The item is set up as a run always expression item that gets its value from a named query. The named query is simply a count of records. I want the transaction group to record the initial count at the time the transaction group is started and every subsequent change in the count. The timer section of the transaction group is configured as so: ![Timer](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/1/218320a6ee656eeeffa6db00ca24acdd893402c3.png) The trigger section of the transaction group is configured as so: ![Trigger](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/2/02c85e84fb482b8e4cfa3b44961297ba56e8e95b.png) Anyone have any ideas what I am doing wrong? Cheers, Iain ---
**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 15, 2021, 11:14am UTC](https://forum.inductiveautomation.com/t/transaction-groups-expression-item-a-tag-executor-could-not-be-created-for-the-item/47777/2 "2021-06-15T11:14:12Z")
Well, you’ve shown us everything except for the setup of the offending item. 😉 If I was to guess though, the column you’re wanting to write to doesn’t exist in your table. ---
**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 15, 2021, 11:52am UTC](https://forum.inductiveautomation.com/t/transaction-groups-expression-item-a-tag-executor-could-not-be-created-for-the-item/47777/3 "2021-06-15T11:52:03Z")
Also, if you are looking for it for it to run on a value change, then get rid of both ‘execute once’ and ‘reset trigger’ options. ---
**Author:** ![iain.blackwood](https://avatars.discourse-cdn.com/v4/letter/i/ea5d25/32.png) [@iain.blackwood](https://forum.inductiveautomation.com/u/iain.blackwood)\ **Post date:** [June 15, 2021, 2:51pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-expression-item-a-tag-executor-could-not-be-created-for-the-item/47777/4 "2021-06-15T14:51:29Z")
Hi Jordan, Thanks for the quick response. So the table is in MSSQL and all the columns exist: ![DBTable](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/a/1ad1a56bea7cc3ae33b4ab27e2411d1ec5647ec2.png) The named query looks like this. SELECT COUNT(\*) AS “Value” FROM SEAS\_APP.SEAS\_MATERIAL\_HISTORY WHERE SHOP\_ORDER = :ShopOrder And testing with a valid shop order returns a value. The Run Always Expression Item is set up like so: ![item_gen](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/d/6d16931aa5d62cf4e3043db02f51d5f6a295a5d2.png) ![itemSQL](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/0/8077cbdae9eb31379af7bfb5b3e928cbd4d1def8.png) I have verified that the value passed into the named query is actually a shop order value by showing the tag in my perspective client. I adjusted the trigger settings as suggested but am still getting this issue. Cheers, Iain ---
**Author:** ![iain.blackwood](https://avatars.discourse-cdn.com/v4/letter/i/ea5d25/32.png) [@iain.blackwood](https://forum.inductiveautomation.com/u/iain.blackwood)\ **Post date:** [July 2, 2021, 10:04am UTC](https://forum.inductiveautomation.com/t/transaction-groups-expression-item-a-tag-executor-could-not-be-created-for-the-item/47777/5 "2021-07-02T10:04:53Z")
Hi Guys, In the end I could not get this to work as I wanted. I made a work around by creating a Memory Tag from Query (Query Tag). I can then just add this tag to my transaction group in the normal manner. Actually this way seems much cleaner that what I was trying to do in the first place. Cheers, Iain ---
**Author:** ![dwoo](https://avatars.discourse-cdn.com/v4/letter/d/bbce88/32.png) [@dwoo](https://forum.inductiveautomation.com/u/dwoo)\ **Post date:** [October 29, 2022, 8:42pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-expression-item-a-tag-executor-could-not-be-created-for-the-item/47777/6 "2022-10-29T20:42:36Z")
I'm encountering the same error message in the log when trying to execute a Named Query from a Transaction Group ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/f/9fb778ec2027594d8a664fe384dc7603b5965ddd.png) I think it's then causing my other issues, as seen in the log. Here are my Transaction settings ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/c/1c3c156c7143ece087eb9dfd625425ce947679b6.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/4/2411047d843ec9b51d23df1427d30c8aec5a5e06.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/4/4418f1937e56bb005c8ecd66b9e4dc5fff1ddb59.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/3/535acde45f839331f98c883188f258789615536c.png) All of the VALUE column data are tags selected via the tag browser Also, if you look at the details for the "ERROR FORWARDING DATA" log, it's complaining about a NULL string write ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/e/3e24f61fb9cf44dd2fb91d81b0b91e7a6977d403.png) But tag ShopOrderNumber has a string in it...I've tried with and without "" or '' or no quotes ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/e/7e60430315852ed3b24c36f074454cb7968b132d.png) ---
**Author:** ![dwoo](https://avatars.discourse-cdn.com/v4/letter/d/bbce88/32.png) [@dwoo](https://forum.inductiveautomation.com/u/dwoo)\ **Post date:** [October 29, 2022, 8:43pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-expression-item-a-tag-executor-could-not-be-created-for-the-item/47777/7 "2022-10-29T20:43:28Z")
I'm using v 8.1.17