# Transaction group tag values appear N/A

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-tag-values-appear-n-a/5143>\
**Category:** General Discussion\
**Created:** [September 13, 2012, 7:35pm UTC](https://forum.inductiveautomation.com/t/transaction-group-tag-values-appear-n-a/5143 "2012-09-13T19:35:13Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![mikehill100](https://avatars.discourse-cdn.com/v4/letter/m/bcef8e/32.png) [@mikehill100](https://forum.inductiveautomation.com/u/mikehill100)\
**Post date:** [September 13, 2012, 7:35pm UTC](https://forum.inductiveautomation.com/t/transaction-group-tag-values-appear-n-a/5143/1 "2012-09-13T19:35:13Z")

</div>

I am creating a transaction group and when I drag my tags over the values appear as N/A.  
They seem to be working fine in my SQL tag browser.

I have tried recreating the group.  
I have tried recreating the folder the group is in.

I’m not great with transaction groups yet, so it may be a dumb error on my part, it is just puzzling that the tags work fine in the browser and in windows but lose their values in the group.

Any thoughts?

---

<div class="post-metadata">

**Author:** ![James.Lorenz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/james.lorenz/32/3290_2.png) [@James.Lorenz](https://forum.inductiveautomation.com/u/James.Lorenz)\
**Post date:** [September 13, 2012, 7:47pm UTC](https://forum.inductiveautomation.com/t/transaction-group-tag-values-appear-n-a/5143/2 "2012-09-13T19:47:58Z")

</div>

If you enable the transaction group and save the project, you should start seeing values. I imagine that showing the values as N/A when the group is disabled is probably for optimization, and if you’re troubleshooting a transaction group that might not be working the way it should, you’ll be observing the group in its enabled state.

---

<div class="post-metadata">

**Author:** ![mikehill100](https://avatars.discourse-cdn.com/v4/letter/m/bcef8e/32.png) [@mikehill100](https://forum.inductiveautomation.com/u/mikehill100)\
**Post date:** [September 13, 2012, 7:50pm UTC](https://forum.inductiveautomation.com/t/transaction-group-tag-values-appear-n-a/5143/3 "2012-09-13T19:50:41Z")

</div>

Tried it with no success. It reads “Unable to Start.”

---

<div class="post-metadata">

**Author:** ![mikehill100](https://avatars.discourse-cdn.com/v4/letter/m/bcef8e/32.png) [@mikehill100](https://forum.inductiveautomation.com/u/mikehill100)\
**Post date:** [September 13, 2012, 8:29pm UTC](https://forum.inductiveautomation.com/t/transaction-group-tag-values-appear-n-a/5143/4 "2012-09-13T20:29:41Z")

</div>

Also, what does “Warned” mean as a status? They will sometimes appear and then change to “running” a minute later.

---

<div class="post-metadata">

**Author:** ![James.Lorenz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/james.lorenz/32/3290_2.png) [@James.Lorenz](https://forum.inductiveautomation.com/u/James.Lorenz)\
**Post date:** [September 13, 2012, 9:05pm UTC](https://forum.inductiveautomation.com/t/transaction-group-tag-values-appear-n-a/5143/5 "2012-09-13T21:05:44Z")

</div>

I believe the “warned” status indicates the level current log message, something that is not directly an error but lets the user know that something may not be functioning as intended.

If you look at the console logs in the gateway, there should be more information about the error you received.

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [September 14, 2012, 3:42pm UTC](https://forum.inductiveautomation.com/t/transaction-group-tag-values-appear-n-a/5143/6 "2012-09-14T15:42:59Z")

</div>

Down at the bottom of the group display, there is a tab for messages. You should be able to see the warning there.

Warnings usually occur because the table is missing a column or something, and “Create table” is not enabled. Or, perhaps you have multiple items set to write to the same column.

“Unable to start” is caused by similar problems, but more serious. The messages should tell you what’s wrong.

And then, the values are only updated when the group is running. They may be fine in the tag browser, but the value shown is the last value seen by group execution, which is why it’s “not available” until the group runs.

Regards,

---

<div class="post-metadata">

**Author:** ![mikehill100](https://avatars.discourse-cdn.com/v4/letter/m/bcef8e/32.png) [@mikehill100](https://forum.inductiveautomation.com/u/mikehill100)\
**Post date:** [September 14, 2012, 8:07pm UTC](https://forum.inductiveautomation.com/t/transaction-group-tag-values-appear-n-a/5143/7 "2012-09-14T20:07:29Z")

</div>

Works now. Thanks for the help!

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [September 14, 2012, 8:18pm UTC](https://forum.inductiveautomation.com/t/transaction-group-tag-values-appear-n-a/5143/8 "2012-09-14T20:18:04Z")

</div>

For what it’s worth, having the tag values update in realtime even when the group isn’t running has been an outstanding feature request for a while, and will likely be in the next big update of the sql bridge module. So, don’t feel bad for asking 😆

Regards,
