Trouble with DB2 timestamp.

[keithkelley1]

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.

[btsay_splunk]

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.

[araitz]

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

[keithkelley1]

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.

[araitz]

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