elastic / kibana

Your window into the Elastic Stack
https://www.elastic.co/products/kibana
Other
19.82k stars 8.21k forks source link

Courier Fetch Error ElasticsearchParseException[failed to parse date field [2014-12-04T19:03:41.413Z], tried both date format [yyyy-MM-dd HH:mm:ss.SSS zzz], and timestamp number]; nested: IllegalArgumentException[Invalid format: \"2014-12-04T19:03:41.413Z\" is malformed at \"T19:03:41.413Z\"]; }{[QZnhxUCvSuGirC6Ru88uqQ][clickstream] #2703

Closed KaranMuthusamy closed 9 years ago

KaranMuthusamy commented 9 years ago

I have Kibana4 beta2 with elasticsearch 1.4.1 and I got the following error when I try to Date Histogram on X axis also I have kibana advanced tab dataFormat as below MMMM Do YYYY, HH:mm:ss.SSS,yyyy-MM-dd HH:mm:ss.SSS zzz,yyyyMMdd'T'HHmmss.SSSZ

Not sure why this is failing with this message below. Can same one help on this please.

example timestamp data: 2015-01-16T23:10:11.291Z - This is the format of Kibana timestamp as @timestamp and "type" : "date", "format" : "dateOptionalTime" AND 2015-01-04 01:21:54.749 GMT - This is format of date from doc on Elasticsearch and "type" : "date", "format" : "yyyy-MM-dd HH:mm:ss.SSS zzz", it is manually defined on mapping.

Courier Fetch Error: unhandled error Error: Failed to get the doc: {"error":"SearchPhaseExecutionException[Failed to execute phase [query], all shards failed; shardFailures {[QZnhxUCvSuGirC6Ru88uqQ][clickstream][0]: ElasticsearchParseException[failed to parse date field [2014-12-04T19:03:41.413Z], tried both date format [yyyy-MM-dd HH:mm:ss.SSS zzz], and timestamp number]; nested: IllegalArgumentException[Invalid format: \"2014-12-04T19:03:41.413Z\" is malformed at \"T19:03:41.413Z\"]; }{[QZnhxUCvSuGirC6Ru88uqQ][clickstream][1]: ElasticsearchParseException[failed to parse date field [2014-12-04T19:03:41.413Z], tried both date format [yyyy-MM-dd HH:mm:ss.SSS zzz], and timestamp number]; nested: IllegalArgumentException[Invalid format: \"2014-12-04T19:03:41.413Z\" is malformed at \"T19:03:41.413Z\"]; }{[QZnhxUCvSuGirC6Ru88uqQ][clickstream][2]: ElasticsearchParseException[failed to parse date field [2014-12-04T19:03:41.413Z], tried both date format [yyyy-MM-dd HH:mm:ss.SSS zzz], and timestamp number]; nested: IllegalArgumentException[Invalid format: \"2014-12-04T19:03:41.413Z\" is malformed at \"T19:03:41.413Z\"]; }{[QZnhxUCvSuGirC6Ru88uqQ][clickstream][3]: ElasticsearchParseException[failed to parse date field [2014-12-04T19:03:41.413Z], tried both date format [yyyy-MM-dd HH:mm:ss.SSS zzz], and timestamp number]; nested: IllegalArgumentException[Invalid format: \"2014-12-04T19:03:41.413Z\" is malformed at \"T19:03:41.413Z\"]; }{[QZnhxUCvSuGirC6Ru88uqQ][clickstream][4]: ElasticsearchParseException[failed to parse date field [2014-12-04T19:03:41.413Z], tried both date format [yyyy-MM-dd HH:mm:ss.SSS zzz], and timestamp number]; nested: IllegalArgumentException[Invalid format: \"2014-12-04T19:03:41.413Z\" is malformed at \"T19:03:41.413Z\"]; }]"}

KaranMuthusamy commented 9 years ago

Hello, No one got similar error?

rashidkpc commented 9 years ago

This is fixed in master: https://github.com/elasticsearch/kibana/commit/a5b8718b53b53d7ebb196d887b27e8c77cf51f01