# Error Discover:\[number\_format\_exception\] empty String

**URL:** https://discuss.elastic.co/t/error-discover-number-format-exception-empty-string/124068
**Category:** Kibana
**Created:** [March 15, 2018, 10:16am UTC](https://discuss.elastic.co/t/error-discover-number-format-exception-empty-string/124068 "2018-03-15T10:16:49Z")
**Posts on this page:** 12
**Page:** 1

<div class="post-metadata">

### Author: ![r00ting](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@r00ting](https://discuss.elastic.co/u/r00ting)
#### Post date: [March 15, 2018, 10:16am UTC](https://discuss.elastic.co/t/error-discover-number-format-exception-empty-string/124068/1 "2018-03-15T10:16:49Z")

</div>

Hi everyone

I would need some help with this error. See below the description:

In Kibana UI the "More info" displays:  
Error: [number\_format\_exception] empty String  
ErrorAbstract@[http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:111:151667](http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:111:151667)  
StatusCodeError@[http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:111:155038](http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:111:155038)  
respond@[http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:111:161556](http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:111:161556)  
checkRespForFailure@[http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:111:160796](http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:111:160796)  
AngularConnector.prototype.request/\<@[http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:105:285566](http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:105:285566)  
processQueue@[http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:58:132456](http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:58:132456)  
scheduleProcessQueue/\<@[http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:58:133349](http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:58:133349)  
$RootScopeProvider/this.$get\</Scope.prototype.$digest@[http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:58:144239](http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:58:144239)  
$RootScopeProvider/this.$get\</Scope.prototype.$apply@[http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:58:147007](http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:58:147007)  
done@[http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:58:100015](http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:58:100015)  
completeRequest@[http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:58:104697](http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:58:104697)  
createHttpBackend/\</xhr.onload@[http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:58:105435](http://10.100.8.85:5601/bundles/vendors.bundle.js?v=16588:58:105435)

The verbose logs:  
respons [10:05:24.541] GET /app/kibana 200 24ms - 9.0B  
respons [10:05:24.588] GET /bundles/vendors.style.css?v=16588 200 18ms - 9.0B  
respons [10:05:24.591] GET /ui/favicons/favicon-16x16.png 200 16ms - 9.0B  
respons [10:05:24.590] GET /bundles/kibana.style.css?v=16588 200 27ms - 9.0B  
respons [10:05:24.589] GET /bundles/commons.style.css?v=16588 200 40ms - 9.0B  
respons [10:05:24.591] GET /bundles/vendors.bundle.js?v=16588 200 319ms - 9.0B  
respons [10:05:25.266] GET /bundles/commons.bundle.js?v=16588 200 81ms - 9.0B  
respons [10:05:25.425] GET /bundles/kibana.bundle.js?v=16588 200 304ms - 9.0B  
log [10:05:26.280] [debug][plugin] Checking Elasticsearch version  
respons [10:05:26.593] GET /api/console/api\_server?sense\_version=%40%40SENSE\_VERSION&apis=es\_5\_0 200 10ms - 9.0B  
respons [10:05:26.879] GET /api/saved\_objects/?type=index-pattern&per\_page=10000&page=1 200 8ms - 9.0B  
respons [10:05:26.906] GET /plugins/kibana/assets/discover.svg 200 3ms - 9.0B  
respons [10:05:26.910] GET /plugins/kibana/assets/visualize.svg 200 11ms - 9.0B  
respons [10:05:26.913] GET /plugins/kibana/assets/dashboard.svg 200 12ms - 9.0B  
respons [10:05:26.916] GET /plugins/timelion/icon.svg 200 13ms - 9.0B  
respons [10:05:26.924] GET /plugins/kibana/assets/wrench.svg 200 7ms - 9.0B  
respons [10:05:26.930] GET /plugins/kibana/assets/settings.svg 200 4ms - 9.0B  
respons [10:05:27.093] GET /plugins/kibana/assets/play-circle.svg 200 5ms - 9.0B  
respons [10:05:27.113] GET /bundles/ebdca7741674eca4e1fadeca157f3ae6.svg 200 3ms - 9.0B  
respons [10:05:27.119] GET /ui/fonts/open\_sans/open\_sans\_v13\_latin\_regular.woff2 200 3ms - 9.0B  
respons [10:05:27.123] GET /api/saved\_objects/?type=index-pattern&fields=title&per\_page=10000&page=1 200 11ms - 9.0B  
respons [10:05:27.456] POST /api/saved\_objects/bulk\_get 200 10ms - 9.0B  
respons [10:05:27.965] GET /ui/fonts/open\_sans/open\_sans\_v13\_latin\_700.woff2 200 6ms - 9.0B  
respons [10:05:27.966] GET /bundles/4b5a84aaf1c9485e060c503a0ff8cadb.woff2 200 6ms - 9.0B  
respons [10:05:28.151] GET /ui/favicons/favicon-16x16.png 304 4ms - 9.0B  
ops [10:05:28.174] memory: 63.9MB uptime: 0:02:18 load: [0.10 0.05 0.05] delay: 0.322  
respons [10:05:28.303] POST /elasticsearch/\_msearch 400 7

And the full request that causes the problem, ...i think is this:  
Mar 15 10:37:36 s-\*\*\*\*-elastic1 kibana: {"type":"response","@timestamp":"2018-03-15T09:37:36Z","tags":[],"pid":229241,"method":"post","statusCode":400,"req":{"url":"/elasticsearch/\_msearch","method":"post","headers":{"host":"10.100.8.85:5601","user-agent":"Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:52.0) Gecko/20100101 Firefox/52.0","accept":"application/json, text/plain, _/_","accept-language":"en-GB,en;q=0.8,de;q=0.5,fr;q=0.3","accept-encoding":"gzip, deflate","referer":"[http://10.100.8.85:5601/app/kibana","content-type":"application/x-ndjson","kbn-version":"6.2.2","content-length":"550","dnt":"1","connection":"keep-alive"},"remoteAddress":"10.100.24.23","userAgent":"10.100.24.23","referer":"http://10.100.8.85:5601/app/kibana"},"res":{"statusCode":400,"responseTime":5,"contentLength":9},"message":"POST](http://10.100.8.85:5601/app/kibana%22,%22content-type%22:%22application/x-ndjson%22,%22kbn-version%22:%226.2.2%22,%22content-length%22:%22550%22,%22dnt%22:%221%22,%22connection%22:%22keep-alive%22%7D,%22remoteAddress%22:%2210.100.24.23%22,%22userAgent%22:%2210.100.24.23%22,%22referer%22:%22http://10.100.8.85:5601/app/kibana%22%7D,%22res%22:%7B%22statusCode%22:400,%22responseTime%22:5,%22contentLength%22:9%7D,%22message%22:%22POST) /elasticsearch/\_msearch 400 5ms - 9.0B"}

I can't figure it out.  
Thanks

---

<div class="post-metadata">

### Author: ![Bill\_McConaghy](https://avatars.discourse-cdn.com/v4/letter/b/ed655f/32.png) [@Bill\_McConaghy](https://discuss.elastic.co/u/Bill_McConaghy)
#### Post date: [March 15, 2018, 12:17pm UTC](https://discuss.elastic.co/t/error-discover-number-format-exception-empty-string/124068/2 "2018-03-15T12:17:04Z")

</div>

I need some more context on this. What are you trying to do that causes this error?

---

<div class="post-metadata">

### Author: ![r00ting](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@r00ting](https://discuss.elastic.co/u/r00ting)
#### Post date: [March 15, 2018, 12:22pm UTC](https://discuss.elastic.co/t/error-discover-number-format-exception-empty-string/124068/3 "2018-03-15T12:22:49Z")

</div>

It just appears whenever I have any default index pattern is selected. In the Discover tab, when it loads the page, it displays the error.

The indexes are accessible from the Console and the fields are visible in the visualisations as well.

Thanks

---

<div class="post-metadata">

### Author: ![Bill\_McConaghy](https://avatars.discourse-cdn.com/v4/letter/b/ed655f/32.png) [@Bill\_McConaghy](https://discuss.elastic.co/u/Bill_McConaghy)
#### Post date: [March 15, 2018, 12:30pm UTC](https://discuss.elastic.co/t/error-discover-number-format-exception-empty-string/124068/4 "2018-03-15T12:30:48Z")

</div>

What version of Kibana are you using? What is the config of the default index pattern? Are you using any scripted fields?

---

<div class="post-metadata">

### Author: ![r00ting](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@r00ting](https://discuss.elastic.co/u/r00ting)
#### Post date: [March 15, 2018, 12:32pm UTC](https://discuss.elastic.co/t/error-discover-number-format-exception-empty-string/124068/5 "2018-03-15T12:32:54Z")

</div>

Kibana 6.2.2  
No scripted fields  
The default index pattern is an index i have created but with .kibana i get the same behaviour and as for the id I have let kibana get an id for me but also tried to define an id myself. In all cases the same error.

---

<div class="post-metadata">

### Author: ![Bill\_McConaghy](https://avatars.discourse-cdn.com/v4/letter/b/ed655f/32.png) [@Bill\_McConaghy](https://discuss.elastic.co/u/Bill_McConaghy)
#### Post date: [March 15, 2018, 12:40pm UTC](https://discuss.elastic.co/t/error-discover-number-format-exception-empty-string/124068/6 "2018-03-15T12:40:49Z")

</div>

I think the issue may be with the data and mapping in your index. I think that a field that is mapped as a number type in Elasticsearch has some values that are just "" instead of a number. See this post for possible resolutions: [Number format Exception For string type](https://discuss.elastic.co/t/number-format-exception-for-string-type/59175)

---

<div class="post-metadata">

### Author: ![r00ting](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@r00ting](https://discuss.elastic.co/u/r00ting)
#### Post date: [March 15, 2018, 12:43pm UTC](https://discuss.elastic.co/t/error-discover-number-format-exception-empty-string/124068/7 "2018-03-15T12:43:13Z")

</div>

I was looking at that but then I have tried to setup an index without number mappings and I am running into the same issue with the default .kibana index pattern.

---

<div class="post-metadata">

### Author: ![Bill\_McConaghy](https://avatars.discourse-cdn.com/v4/letter/b/ed655f/32.png) [@Bill\_McConaghy](https://discuss.elastic.co/u/Bill_McConaghy)
#### Post date: [March 15, 2018, 12:46pm UTC](https://discuss.elastic.co/t/error-discover-number-format-exception-empty-string/124068/8 "2018-03-15T12:46:23Z")

</div>

Maybe your .kibana index is corrupted. You could try deleting it, as it gets recreated when Kibana starts up and it is not present.

---

<div class="post-metadata">

### Author: ![r00ting](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@r00ting](https://discuss.elastic.co/u/r00ting)
#### Post date: [March 15, 2018, 12:47pm UTC](https://discuss.elastic.co/t/error-discover-number-format-exception-empty-string/124068/9 "2018-03-15T12:47:50Z")

</div>

I will try it now and get back asap

---

<div class="post-metadata">

### Author: ![r00ting](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@r00ting](https://discuss.elastic.co/u/r00ting)
#### Post date: [March 15, 2018, 12:55pm UTC](https://discuss.elastic.co/t/error-discover-number-format-exception-empty-string/124068/10 "2018-03-15T12:55:07Z")

</div>

Fixed! Million thanks

---

<div class="post-metadata">

### Author: ![Bill\_McConaghy](https://avatars.discourse-cdn.com/v4/letter/b/ed655f/32.png) [@Bill\_McConaghy](https://discuss.elastic.co/u/Bill_McConaghy)
#### Post date: [March 15, 2018, 1:17pm UTC](https://discuss.elastic.co/t/error-discover-number-format-exception-empty-string/124068/11 "2018-03-15T13:17:13Z")

</div>

Great, glad you got things working.

---

<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: [April 12, 2018, 1:17pm UTC](https://discuss.elastic.co/t/error-discover-number-format-exception-empty-string/124068/12 "2018-04-12T13:17:26Z")

</div>

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