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?
Customer support service by UserEcho