All Apps and Add-ons

Splunk DB Connect: Why am I unable to use DateTime column as the Index Time?

harshal_chakran
Builder

Hi,
I am using the Splunk DB Connect to connect to an Oracle Database and I want to use the DateTime from one column as the index time.
My SQL search generates a column named "Timestamp_TZ" with sample value as "2016-10-26 05:30:12.0 +1:00" which is in TIMESTAMP format.
At DB-Input settings , I mentioned this column as 'Timestamp Column', 'DateTime Format' is kept blank and Output Timestamp format as "Epoch Time.
I see no errors in dbx2.log but still no data is indexed.
Where I can find this error logs AND is the above configuration correct?

I tried applying other Output Timestamp formats as well, but they all showed error like:

error=ERROR: java.lang.Exception: The datatype of output timestamp column number [2] is invalid as [TIMESTAMP WITH TIME ZONE]..

0 Karma

VioletaJanciuke
New Member

Try to add Timestamp format as "yyyy-MM-dd HH:mm:ss.S Z"

0 Karma

harshal_chakran
Builder

DBConnect is not taking it as Timestamp format.
I have also tried : yyyy-MM-dd HH:mm:ss.S XXX as the timezone used is in +1:00 format, but still doesn't work

0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...