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  is invalid as [TIMESTAMP WITH TIME ZONE]..