# Transaction Group with Named Query Not Getting Output Param **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [March 24, 2026, 6:44pm UTC](https://forum.inductiveautomation.com/t/transaction-group-with-named-query-not-getting-output-param/114649 "2026-03-24T18:44:15Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\ **Post date:** [March 24, 2026, 6:44pm UTC](https://forum.inductiveautomation.com/t/transaction-group-with-named-query-not-getting-output-param/114649/1 "2026-03-24T18:44:15Z")
Hey all, I am running a Stored Procedure Group, using a boolean tag as a trigger. There are two run-always Expression Items that each pull a value from a Named Query. The last item is a read-only basic tag reference item bound to the output of the Stored Procedure, which is supposed to take the output value and write to a memory tag. The first time I tried to run this Trans Group, I got an error in the logs: ```python Group is set to use a trigger, but a source tag has not been specified. ``` But I have not seen this error since. Here is a screen shot of the group: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/f/bfc6b5f8248ef1e58a3225b2586c12696f52f26b.png) The status shows no executions, no tag writes, no DB writes. Not sure what to look at now. I've watched the vids on Stored Procedure TGs, and SQL Query Expression Items and of course theirs works, lol. - Why does the proc not get run? - Where can I find any error info if any is available? - The Tag Reference Item should write the output from the Proc to the tag, correct? Thanks for the help. ---
**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\ **Post date:** [March 24, 2026, 7:39pm UTC](https://forum.inductiveautomation.com/t/transaction-group-with-named-query-not-getting-output-param/114649/2 "2026-03-24T19:39:08Z")
Did you define which tag to use in the trigger settings? > **[Trigger Settings​ - Understanding Transaction Groups | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/ignition-modules/sql-bridge-transaction-groups/understanding-transaction-groups#trigger-settings)** > > Transaction Groups are edited through the Ignition Designer. When a group is selected, you are presented with the transaction group workspace. The workspace is broken into several parts: | Transaction Group Workspace ---
**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\ **Post date:** [March 24, 2026, 7:39pm UTC](https://forum.inductiveautomation.com/t/transaction-group-with-named-query-not-getting-output-param/114649/3 "2026-03-24T19:39:41Z")
Can you post a screenshot of the trigger tab? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/9/79378e13325b1022806a718b1784bde3e56f61e4.png) ---
**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\ **Post date:** [March 24, 2026, 8:26pm UTC](https://forum.inductiveautomation.com/t/transaction-group-with-named-query-not-getting-output-param/114649/4 "2026-03-24T20:26:15Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/c/1cd8f5790c636c6e5875f43529303c846198bb03.png) I manually flag the tag to test fire the TG. Edit: I found this error by dbl-clicking on the error message in the TG Events window. ```python Error during group execution. Error registering parameter 'BlockID'. Verify that the parameter name and type are correct. The index 6 is out of range. ``` Also, `BlockID` is a `bigint` type, so I went with the largest integer type in the TG. Edit 2: I created a new Proc with no output, deleted the Item that referenced the output param. Not sure if this makes any difference, but here is a pic of one of the run-always items: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/a/daeaccacb5e9d4917404abba2edd21491049651b.png) So all i have now are the trigger item and two run-always items. Hm, turns out I have to name all the input params for the proc, even though there are NULL defaults. Now it seems as though Ignition does not have a datatype to match a SQL Server bigint? (I tried INT8, INT4 with the tag's datatype as LONG.) Is this right, no bigint for Ignition? ---
**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\ **Post date:** [March 24, 2026, 9:36pm UTC](https://forum.inductiveautomation.com/t/transaction-group-with-named-query-not-getting-output-param/114649/5 "2026-03-24T21:36:45Z")
OK, got it! I missed one parameter! And set tag datatype to LONG, used INT4 (32-bit) instead of INT8 (8-bit ) 🤦‍♂️ And now all is good! For the time being.