1. UNIFYBroker Forum
  2. Bugs
0
Fixed

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

Daniel Walters 14 years ago • updated by anonymous 9 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?

Shane Day (Chief Technology Officer) 14 years ago

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

Tony Sheehy 13 years ago

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

Matthew Clark 13 years ago

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

Daniel Walters 13 years ago

Yup what Matt said.

Adam van Vliet 13 years ago

Closed.

Bob Bradley 13 years ago

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.

Adam van Vliet 13 years ago

Bob, please see IDB-71 for explanation.

Customer support service by UserEcho