Security

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

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?

0 Karma

jcoates_splunk
Splunk Employee
Splunk Employee

is this the rising column?

0 Karma

KindaWorking
Path Finder

Yes it is.

0 Karma

jcoates_splunk
Splunk Employee
Splunk Employee

I think that has to be an integer... maybe try adding a CAST to your SQL statement?

0 Karma
Get Updates on the Splunk Community!

Fueling your curiosity with new Splunk ILT and eLearning courses

At Splunk Education, we’re driven by curiosity—both ours and yours! That’s why we’re committed to delivering ...

Splunk AI Assistant for SPL 1.1.0 | Now Personalized to Your Environment for Greater ...

Splunk AI Assistant for SPL has transformed how users interact with Splunk, making it easier than ever to ...

Unleash Unified Security and Observability with Splunk Cloud Platform

     Now Available on Microsoft AzureOn Demand Now Step boldly into the AI revolution with enhanced security ...