0
Fixed

What should I set the validator to so that I can import a smallint from a SQL table?

Daniel Walters 8 years ago • updated by anonymous 3 years ago 7

I'm configuring a connector that connects to SQL database. There's a field in the table whose type is smallint.

When I try to import the unifylog.csv file returns this line for each row.
Type ShortValue of value 1 in field Status is invalid. Expected type SingleValue.,Normal

I got the list of valid validators below from an Event Log error when I tried setting the validator to short.

boolean, binary, timestamp, date, decimal, dn, guid, int, long, double, single, string, boolean.multi, timestamp.multi, date.multi, decimal.multi, dn.multi, guid.multi, int.multi, long.multi, double.multi, single.multi, string.multi.

I've tried setting the validator in the connector config for the status field to int, long and string and none of them have worked.

What should I set the validator to so that I can import a smallint from a SQL table?

Affected Versions:
Fixed by Version:

Discussed with Daniel, short is missing from the built in validators. Showed him how to use a short validator.

Hey Daniel - has this been confirmed as resolved, and can it be closed?

IDB-71 addresses the issue raised in this question, although the above workaround is in place and working in the SAFE connector.

I had problems with a SQL smallint column (Identity Broker for DEEWR Claims 3.0.6) throwing IdB errors on export @ DEEWR, but because I am already up to my ears in troubleshooting here I changed the SQL column to int so that it just worked. I think there needs to be some further testing with this data type ... various errors experienced. Tried using "single" (exeption when I tried using "short" told me that "The valid validator names are boolean, binary, timestamp, date, decimal, dn, guid, int, long, double, single, string, boolean.multi, timestamp.multi, date.multi, decimal.multi, dn.multi, guid.multi, int.multi, long.multi, double.multi, single.multi, string.multi.") ... however this didn't work either. Please treat this comment as a note for regression testing with the smallint data type.