# Error "type": "query\_shard\_exception" while running below query in dev tools

**URL:** <https://discuss.elastic.co/t/error-type-query-shard-exception-while-running-below-query-in-dev-tools/186666>\
**Category:** Elasticsearch\
**Created:** [June 20, 2019, 11:12am UTC](https://discuss.elastic.co/t/error-type-query-shard-exception-while-running-below-query-in-dev-tools/186666 "2019-06-20T11:12:08Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![gabriel\_tessier](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gabriel_tessier/32/27911_2.png) [@gabriel\_tessier](https://discuss.elastic.co/u/gabriel_tessier)\
**Post date:** [June 25, 2019, 4:10am UTC](https://discuss.elastic.co/t/error-type-query-shard-exception-while-running-below-query-in-dev-tools/186666/4 "2019-06-25T04:10:08Z")

</div>

Hi,

The problem is here:

```
"caused_by": {
"type": "number_format_exception",
"reason": "For input string: "Geosolutions""
}

```

You try to search for text inside integer mapped fields.  
Can you check your mapping, certainly "contentid" field is integer.

There's similar question here that may help you:

> [@Number format Exception For string type](https://discuss.elastic.co/t/number-format-exception-for-string-type/59175/6):
>
> Hi, did you create the new index before running the reindex? Please follow the example below. This worked fine for me on Elasticsearch 2.4.5 (as your talking about "string" I assumed you are on 2.x; in 5.x "string" type has been split into "text" and "keyword"). Let's start fresh and delete all involved indices for this example: DELETE /old\_books DELETE /new\_books Then create the old index and add a document to it. PUT /old\_books { "mappings": { "author": { "properties": {…

---

_[View the full topic](https://discuss.elastic.co/t/error-type-query-shard-exception-while-running-below-query-in-dev-tools/186666)._