yes.
This is the mapping of the index of the env which is not working
{
"apiman_metrics": {
"mappings": {
"properties": {
"apiDuration": {
"type": "long"
},
"apiEnd": {
"type": "long"
},
"apiId": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"apiOrgId": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"apiStart": {
"type": "long"
},
"apiVersion": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"attributes": {
"type": "object"
},
"bytesDownloaded": {
"type": "long"
},
"bytesUploaded": {
"type": "long"
},
"error": {
"type": "boolean"
},
"errorMessage": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"failure": {
"type": "boolean"
},
"failureCode": {
"type": "long"
},
"method": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"requestDuration": {
"type": "long"
},
"requestEnd": {
"type": "long"
},
"requestStart": {
"type": "long"
},
"resource": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"responseCode": {
"type": "long"
},
"responseMessage": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"url": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
}
}
}
And this is the mapping of the other env of which the mapping is working
{
"apiman_metrics": {
"mappings": {
"properties": {
"apiDuration": {
"type": "long"
},
"apiEnd": {
"type": "date"
},
"apiId": {
"type": "keyword"
},
"apiOrgId": {
"type": "keyword"
},
"apiStart": {
"type": "date"
},
"apiVersion": {
"type": "keyword"
},
"attributes": {
"type": "object"
},
"bytesDownloaded": {
"type": "long"
},
"bytesUploaded": {
"type": "long"
},
"clientId": {
"type": "keyword"
},
"clientOrgId": {
"type": "keyword"
},
"clientVersion": {
"type": "keyword"
},
"contractId": {
"type": "keyword"
},
"error": {
"type": "boolean"
},
"errorMessage": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"failure": {
"type": "boolean"
},
"failureCode": {
"type": "long"
},
"failureReason": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"method": {
"type": "keyword"
},
"planId": {
"type": "keyword"
},
"remoteAddr": {
"type": "ip"
},
"requestDuration": {
"type": "long"
},
"requestEnd": {
"type": "date"
},
"requestStart": {
"type": "date"
},
"resource": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"responseCode": {
"type": "long"
},
"responseMessage": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"url": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"user": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
}
}
}
here in the above mappings of an apiman_metrics index
the one which is working in that
"requestEnd": {
"type": "date"
},
"requestStart": {
"type": "date"
},
is in date
and
in the mapping of env which is not working
in that it is
"requestEnd": {
"type": "long"
},
"requestStart": {
"type": "long"
},
that's why it is giving exception as in the query the data is in string format
but previously it working on that env as well but suddenly it stopped and during analysis got this that mapping is different as I compared both env's