- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Splunk DB Connect: Why am I getting error that a value is "outside the valid range for the dataype INTEGER" in an Unsigned Integer column?
KindaWorking
Path Finder
03-09-2015
02:02 PM
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?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

jcoates_splunk

Splunk Employee
03-28-2015
02:20 PM
is this the rising column?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
KindaWorking
Path Finder
03-28-2015
03:39 PM
Yes it is.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

jcoates_splunk

Splunk Employee
03-28-2015
04:36 PM
I think that has to be an integer... maybe try adding a CAST to your SQL statement?
