I am using DB connect to access a table that has the rising column set as an Unsigned Integer.
If I look at the table using Database Info, the type is correctly identified as INT UNSIGNED.
This column contains numbers larger than a normal INT would allow.
When I attempt to view information for this column I get the following error:
03-09-2015 08:36:24.402 +1100 ERROR AdminManagerExternal - Received malformed XML from external handler:\nFailed to validate: com.splunk.config.SplunkConfigurationException: Error validating dbmonTail for monitor=dbmon-tail://DBNAME/TABLENAME: '2.813426101E9' in column '1' is outside valid range for the datatype INTEGER.
So it looks like it is viewing this as a normal integer. Is there a reason for this? Is this something I can fix without modifying the SQL database?
is this the rising column?
Yes it is.
I think that has to be an integer... maybe try adding a CAST to your SQL statement?