Reindex error : "type":"mapper_parsing_exception","reason":"failed to parse field [date] of type [date]

Elastic Stack Elasticsearch
1

Hello,

While using the reindexing API, I am running into 4 indices that are giving me errors.
It seems like the date in the document matches the template but I guess it is not.

I don't really know how to tackle this. I looked for a template for that index but there's nothing that seems related.

Preview of field's value: '2019-04-15T18:33:05Z'","caused_by":{"type":"illegal_argument_exception","reason":"failed to parse date field [2019-04-15T18:33:05Z] with format [yyyy-MM-dd'T'HH:mm:ssZ]","caused_by":{"type":"date_time_parse_exception","reason":"date_time_parse_exception: Text '2019-04-15T18:33:05Z' could not be parsed at index 19"}}},"status":400},{"index":"reindexed-v7-hpcarchive","type":"_doc","id":"xbRGImoBl-KJ5-6JLaQg","cause":

2

@GenSSC What is the date mapping for your source and destination indices? It sounds like a mapping mismatch.

3

I'm thinking it has something to do with the T being in bracket...or maybe the Z needs to have brackets?

"hpcarchive" : {
"aliases" : { },
"mappings" : {
"properties" : {
"date" : {
"type" : "date",
"format" : "yyyy-MM-dd'T'HH:mm:ssZ"
},

4

@GenSSC

The format looks incorrect. Try the following format.

"format": "yyyy-MM-dd HH:mm:ss"

See Date field type | Elasticsearch Guide [8.7] | Elastic for more details.

5

@dhondup How can I change it?

6

@GenSSC

Create the destination index with correct mappings and settings before reindexing

The destination should be configured as wanted before calling _reindex . Reindex does not copy the settings from the source or its associated template.

See Reindex API | Elasticsearch Guide [8.11] | Elastic

7

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