Discover: Failed to parse date field in case of milli seconds

Elastic Stack Kibana
1

I am getting an error when I am trying to use Discover tab.
The format of my time_stamp field is " YYYY-MM-DD'T'hh:mm:ss.SSS ". The data gets parsed in the discovery tab from hours to mins to secs, but fails to show milliseconds. Shows parsing error when it needs to plot milli seconds. If somebody could help me with it.

Capture
Capture.PNG1380×1030 176 KB

And the error message displayed is:-

Error

Discover: failed to parse date field [-764144999835] with format [epoch_millis]: [failed to parse date field [-764144999835] with format [epoch_millis]]

Error: Request to Elasticsearch failed: {"error":{"root_cause":[{"type":"parse_exception","reason":"failed to parse date field [-764144999835] with format [epoch_millis]: [failed to parse date field [-764144999835] with format [epoch_millis]]"}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":[{"shard":0,"index":"t35","node":"A0ujHj3wQdWxBlO0l0eLwA","reason":{"type":"parse_exception","reason":"failed to parse date field [-764144999835] with format [epoch_millis]: [failed to parse date field [-764144999835] with format [epoch_millis]]","caused_by":{"type":"illegal_argument_exception","reason":"failed to parse date field [-764144999835] with format [epoch_millis]","caused_by":{"type":"date_time_parse_exception","reason":"Failed to parse with all enclosed parsers"}}}}]},"status":400}
KbnError@http://localhost:5601/bundles/commons.bundle.js:3:14844
RequestFailure@http://localhost:5601/bundles/commons.bundle.js:3:15283
callResponseHandlers/<@http://localhost:5601/bundles/commons.bundle.js:3:1388766
Promise.try@http://localhost:5601/bundles/commons.bundle.js:3:1065789
Promise.map/<@http://localhost:5601/bundles/commons.bundle.js:3:1065150
Promise.map@http://localhost:5601/bundles/commons.bundle.js:3:1065115
callResponseHandlers@http://localhost:5601/bundles/commons.bundle.js:3:1387770
fetchSearchResults/<@http://localhost:5601/bundles/commons.bundle.js:3:1369738
processQueue@http://localhost:5601/built_assets/dlls/vendors.bundle.dll.js:427:199687
scheduleProcessQueue/<@http://localhost:5601/built_assets/dlls/vendors.bundle.dll.js:427:200650
$digest@http://localhost:5601/built_assets/dlls/vendors.bundle.dll.js:427:210412
$evalAsync/<@http://localhost:5601/built_assets/dlls/vendors.bundle.dll.js:427:212933
completeOutstandingRequest@http://localhost:5601/built_assets/dlls/vendors.bundle.dll.js:427:64422
Browser/self.defer/timeoutId<@http://localhost:5601/built_assets/dlls/vendors.bundle.dll.js:427:67267

2

Looks like this is the same question as Problem in displaying milli seconds in discovery tab?

3

Yes, it is the same thing.
I get that epoch_milli doesn't belong here but how do i solve this error?

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.