Unable to create Index Patterns

[aash_dhariya]

I am setting up kibana on local that connects to remote elasticsearch. I changed the url in data/kibana.conf. However, when I want to create index pattern to start visualising the data, I get an error

Index pattern url details:
url : http://localhost:5601/api/saved_objects/index-pattern
request params: {"attributes":{"title":"sales-*","timeFieldName":"issue_date"}}

response status: 400
response msg error:
{"message":"Rejecting mapping update to [.kibana] as the final mapping would have more than 1 type: [_doc, doc]: [illegal_argument_exception] Rejecting mapping update to [.kibana] as the final mapping would have more than 1 type: [_doc, doc]","statusCode":400,"error":"Bad Request"}

Please help me understand why the error occurs and how to fix it.

[cjcenizal]

Hi there, in 6.x we removed the ability for indices to contain multiple mapping types (https://www.elastic.co/guide/en/elasticsearch/reference/6.0/removal-of-types.html). This problem is happening because you have indices which are captured by the sales-* index pattern which have different types (_doc and doc). You can resolve this by narrowing your pattern to only apply to one or the other index or if you want to capture both indices, reindex one or both to have the same type.

Hope this helps,
CJ