Stored Procedure Transaction Group - reference subset of SP parameters

Ignition
1

I would like to reference just a subset of the SQL Server SP parameters, but SQL Bridge don’t allow me to. If at least one SP parameter isn’t referenced by the Transaction Group Items, the error “index is out of range” is returned during group execution.

2021-02-04 13_30_44-Thu Feb 04 09_51_52 CET 2021

Today I’m getting around this by creating a tag reference item for each unused parameter. Is there a better way?

I’m running Ignition 8.0.14 on Windows Server 2016. The DB server is a SQL Server 2016.

2

It turned out to be a long-standing open issue with the official mssql-jdbc driver. I solved my problem by switching to jTDS.

1 Like