Stored Procedure->string length

Ignition
1

I’m trying to do a stored procedure with defined nvarchar outputs.
I’ve run into the issue that if I declare the procedure using nvarchar(x) outputs, I get an error “string or binary data truncated”. If I declare the procedure using nvarchar outputs, it works, but I get a single character(as it should). It seems as though Ignition isn’t respecting the output length parameter definition, or the tag that it is targeting isn’t able to expand. My outputs are memory tags, type string.
I’m using ignition 7.9.8, SQL Express 2014, and the MS SQL JDBC driver 7.4
Any suggestions are appreciated.

2

Update, I’m even more confused. I get string or binary data truncated even on a simple script operation,
as follows:
Database has two int columns, station and station_id, in the table aa_station
Doing the very simple script below:
query = “update AA_Station set Station=55 where station_ID=22”
system.db.runPrepUpdate(query)
also gives the string or binary data truncated.

3

Ok, I’ve updated to 7.9.12, and created a debugging SP that just gets a single string parameter in, set as nvarchar(300) on the declaration. I still get the 'string or binary data truncated error".
How do I debug this? How do I see the query that the transaction group is preparing to understand what is going on?

4

You should get in contact with support, if you’re not already. Stored procedure preparation is somewhat opaque - it’s handled by JDBC and the individual JDBC drivers, for the most part, but if nothing else we can see whether a different version of the driver works properly.

5

Thanks Paul, I did do a support e-mail on Tuesday. Just sent a reply as well.