topic Trouble with DB2 timestamp. in Getting Data In

Trouble with DB2 timestamp.

keithkelley1 — Fri, 03 Jan 2014 20:20:00 GMT

Ive added a new database connection to DB connect. My first actually. the dbx.log has the following message associated with the rows that are being processed.

2014-01-03 20:12:43.640 dbx1434:WARN:ResultSetOutputPayload - Unrecognized timestamp format: '2013-12-08 21:41:17.000'

I have tried various items suggested on the forum but, it does not seem to go away.

Re: Trouble with DB2 timestamp.

araitz — Mon, 06 Jan 2014 18:07:08 GMT

Is the problem just that the warning is being logged, or is the data not being indexed as expected?

Re: Trouble with DB2 timestamp.

keithkelley1 — Wed, 08 Jan 2014 19:41:21 GMT

it looks like the warning is being logged when the data is indexed. Data is getting indexed but not with the preferred date/time stamp that would make it usefule.

Re: Trouble with DB2 timestamp.

araitz — Wed, 08 Jan 2014 20:45:32 GMT

Can you share your configuration for the input? Alternatively, you can open a support case and submit a diag.

Re: Trouble with DB2 timestamp.

btsay_splunk — Wed, 08 Jan 2014 23:57:15 GMT

you may configure the timestamp format for this dbmon/dbtail/dbdump?

The timestamp format expressed as a Java SimpleDateFormat pattern. The default format is configured in the Splunk DB Connect app setup.