I am at a loss to solve a problem. I have a SQL stored procedure with 114 +/- variables. Whatever the last variable is, when I try to let Ignition execute it, I get the error “Error registering parameter ‘xxxxxx’. Verify that the parameter name and type are correct. The index 114 is out of range.”
The values from the PLC are currently 0. I removed the last one and the new last one becomes the issue (index 113). I added it back plus another variable and it became the issue (index 115).
Those 3 are:
@Status smallint OUTPUT,
@NothingHere int OUTPUT
Is there a limit to how many variables or characters can be sent from Ignition to a stored procedure? I have several strings in the beginning.
My stored procedure doesn’t seem to even start (first command is an update which doesn’t happen). Shouldn’t be permission problem because the 2 I setup before it have the same permissions and I used them to create this one. I run the stored procedure in SQL Management Studio and it works and shows no errors.
Ignition 7.9.1 & SQL Server 2012