# Rollup fails with: ElasticsearchParseException: failed to parse date field \[0\] with format \[date\_time\]

**URL:** <https://discuss.elastic.co/t/rollup-fails-with-elasticsearchparseexception-failed-to-parse-date-field-0-with-format-date-time/145098>\
**Category:** Elasticsearch\
**Created:** [August 20, 2018, 6:45am UTC](https://discuss.elastic.co/t/rollup-fails-with-elasticsearchparseexception-failed-to-parse-date-field-0-with-format-date-time/145098 "2018-08-20T06:45:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![cawoodm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cawoodm/32/14083_2.png) [@cawoodm](https://discuss.elastic.co/u/cawoodm)\
**Post date:** [August 20, 2018, 6:45am UTC](https://discuss.elastic.co/t/rollup-fails-with-elasticsearchparseexception-failed-to-parse-date-field-0-with-format-date-time/145098/1 "2018-08-20T06:45:56Z")

</div>

We are using the RollUp API to process tomcat access logs. The logs have a "timestamp" field formatted as follows (mapping):  
"timestamp": {  
"type": "date",  
"format": "date\_time"  
}

The Rollup fails with the following message:

> ElasticsearchParseException: failed to parse date field [0] with format `[date_time]`

We don't have any other problems with the field timestamp (e.g. in Kibana).

```
[2018-08-20T08:32:00,021][WARN][o.e.x.r.j.RollupJobTask] Rollup job [accessPerformance5] failed with an exception: 
    org.elasticsearch.action.search.SearchPhaseExecutionException: all shards failed
        at org.elasticsearch.action.search.AbstractSearchAsyncAction.onPhaseFailure(AbstractSearchAsyncAction.java:288) ~[elasticsearch-6.3.1.jar:6.3.1]
        at org.elasticsearch.action.search.AbstractSearchAsyncAction.executeNextPhase(AbstractSearchAsyncAction.java:128) ~[elasticsearch-6.3.1.jar:6.3.1]
        at org.elasticsearch.action.search.AbstractSearchAsyncAction.onPhaseDone(AbstractSearchAsyncAction.java:249) ~[elasticsearch-6.3.1.jar:6.3.1]
    ...
        at java.lang.Thread.run(Thread.java:745) [?:1.8.0_45]
    Caused by: org.elasticsearch.ElasticsearchParseException: failed to parse date field [0] with format [date_time]
        at org.elasticsearch.common.joda.DateMathParser.parseDateTime(DateMathParser.java:213) ~[elasticsearch-6.3.1.jar:6.3.1]
        at org.elasticsearch.common.joda.DateMathParser.parse(DateMathParser.java:66) ~[elasticsearch-6.3.1.jar:6.3.1]
        at org.elasticsearch.index.mapper.DateFieldMapper$DateFieldType.parseToMilliseconds(DateFieldMapper.java:318) ~[elasticsearch-6.3.1.jar:6.3.1]
        at org.elasticsearch.index.mapper.DateFieldMapper$DateFieldType.isFieldWithinQuery(DateFieldMapper.java:331) ~[elasticsearch-6.3.1.jar:6.3.1]
    ...
        at org.elasticsearch.search.SearchService$2.onResponse(SearchService.java:333) ~[elasticsearch-6.3.1.jar:6.3.1]

```

---

<div class="post-metadata">

**Author:** ![polyfractal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/polyfractal/32/48162_2.png) [@polyfractal](https://discuss.elastic.co/u/polyfractal)\
**Post date:** [August 21, 2018, 10:02pm UTC](https://discuss.elastic.co/t/rollup-fails-with-elasticsearchparseexception-failed-to-parse-date-field-0-with-format-date-time/145098/2 "2018-08-21T22:02:58Z")

</div>

@cawoodm Hmm, I'm not sure off the top of my head. Could you open an issue on Github with the full stack trace (if available) and your rollup config? It'll be easier to track this on github than on the forums.

It might be related to this bug ([https://github.com/elastic/elasticsearch/pull/31890](https://github.com/elastic/elasticsearch/pull/31890)) but I'm not positive.

---

<div class="post-metadata">

**Author:** ![cawoodm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cawoodm/32/14083_2.png) [@cawoodm](https://discuss.elastic.co/u/cawoodm)\
**Post date:** [August 22, 2018, 6:17am UTC](https://discuss.elastic.co/t/rollup-fails-with-elasticsearchparseexception-failed-to-parse-date-field-0-with-format-date-time/145098/3 "2018-08-22T06:17:53Z")

</div>

Done:

> <https://github.com/elastic/elasticsearch/issues/33048>

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 19, 2018, 6:18am UTC](https://discuss.elastic.co/t/rollup-fails-with-elasticsearchparseexception-failed-to-parse-date-field-0-with-format-date-time/145098/4 "2018-09-19T06:18:00Z")

</div>

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