Transaction Group with Named Query Not Getting Output Param

Ignition
1

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:

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
image1029×202 23.7 KB

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.

2

Did you define which tag to use in the trigger settings?

3

Can you post a screenshot of the trigger tab?

image
image364×237 11.5 KB

4

image
image422×454 25.2 KB

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.

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
image693×622 25.9 KB

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?

5

OK, got it! I missed one parameter! And set tag datatype to LONG, used INT4 (32-bit) instead of INT8 (8-bit ) :man_facepalming:
And now all is good! For the time being.

2 Likes