# Terms list is incomplete because the request is taking too long in controls visualization

**URL:** <https://discuss.elastic.co/t/terms-list-is-incomplete-because-the-request-is-taking-too-long-in-controls-visualization/231282>\
**Category:** Kibana\
**Created:** [May 6, 2020, 7:21am UTC](https://discuss.elastic.co/t/terms-list-is-incomplete-because-the-request-is-taking-too-long-in-controls-visualization/231282 "2020-05-06T07:21:45Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jaishree\_Pal](https://avatars.discourse-cdn.com/v4/letter/j/f475e1/32.png) [@Jaishree\_Pal](https://discuss.elastic.co/u/Jaishree_Pal)\
**Post date:** [May 6, 2020, 7:21am UTC](https://discuss.elastic.co/t/terms-list-is-incomplete-because-the-request-is-taking-too-long-in-controls-visualization/231282/1 "2020-05-06T07:21:46Z")

</div>

I was trying to use controls for my visualizations, but it does not load all the values from the selected field. The list doesn't even show half of them.

I've tried increasing the kibana.autocompleteTerminateAfter and kibana.autocompleteTimeout values upto a great extent, but it seems like it's not taking this much time to load the list. Is there anything else I need to do to get the full list?

I'm using Kibana 7.6.2. Here is the snapshot of the same.

 ![Controls issue](https://us1.discourse-cdn.com/elastic/original/3X/1/2/1206c63cb8e142d5d911daeddd72c51c6197989c.png)

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [May 6, 2020, 7:26am UTC](https://discuss.elastic.co/t/terms-list-is-incomplete-because-the-request-is-taking-too-long-in-controls-visualization/231282/2 "2020-05-06T07:26:20Z")

</div>

`kibana.autocompleteTerminateAfter` is not a time, but the number of documents considered per shard. What values did you set it to?

You probably did this, but just to make sure: Also, you have to restart Kibana for these changes to take effect.

---

<div class="post-metadata">

**Author:** ![Jaishree\_Pal](https://avatars.discourse-cdn.com/v4/letter/j/f475e1/32.png) [@Jaishree\_Pal](https://discuss.elastic.co/u/Jaishree_Pal)\
**Post date:** [May 6, 2020, 7:30am UTC](https://discuss.elastic.co/t/terms-list-is-incomplete-because-the-request-is-taking-too-long-in-controls-visualization/231282/3 "2020-05-06T07:30:35Z")

</div>

Thanks @flash1293 for your reply.  
I've set these values to  
kibana.autocompleteTerminateAfter: 300000  
kibana.autocompleteTimeout: 1000000

And yes, I restarted Kibana after making these changes.

---

<div class="post-metadata">

**Author:** ![Jaishree\_Pal](https://avatars.discourse-cdn.com/v4/letter/j/f475e1/32.png) [@Jaishree\_Pal](https://discuss.elastic.co/u/Jaishree_Pal)\
**Post date:** [May 6, 2020, 7:41am UTC](https://discuss.elastic.co/t/terms-list-is-incomplete-because-the-request-is-taking-too-long-in-controls-visualization/231282/4 "2020-05-06T07:41:24Z")

</div>

Also, as I got to know that this request is the simulation of what the Controls visualization is doing behind the scenes. I'm getting the complete output here, I guess. Then what might be the issue with Controls visualization?

 ![Controls issue 2](https://us1.discourse-cdn.com/elastic/original/3X/0/2/022f9858aab8a4c1687f5f55ff8100376f1f1715.png)

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [May 6, 2020, 7:44am UTC](https://discuss.elastic.co/t/terms-list-is-incomplete-because-the-request-is-taking-too-long-in-controls-visualization/231282/5 "2020-05-06T07:44:19Z")

</div>

How many documents are in your index? `300000` might be too little. I see you have 3 shards, so if you have more than 900000 documents, that would explain the message.

Also, the options panel will never show you the full list at once, when you start typing it will refetch new data based on the input your already entered.

---

<div class="post-metadata">

**Author:** ![Jaishree\_Pal](https://avatars.discourse-cdn.com/v4/letter/j/f475e1/32.png) [@Jaishree\_Pal](https://discuss.elastic.co/u/Jaishree_Pal)\
**Post date:** [May 6, 2020, 8:39am UTC](https://discuss.elastic.co/t/terms-list-is-incomplete-because-the-request-is-taking-too-long-in-controls-visualization/231282/6 "2020-05-06T08:39:56Z")

</div>

Thanks a lot @flash1293. It's resolved now. 🙂  
I had **6090179** documents in my index.

Plus, I was unaware of the fact that it refetches new data based based on the input. I was considering only the items I could see in the list on the first go.

But, the issue I'm facing now is that the users need to remember everything- the name of the values they are looking for as well as the case, as the search here is case sensitive. And remembering everything is not possible in my case. Can I turn it off from somewhere? And, is it possible to get the full list instead of refetching the values based on the input? Thanks in advance!

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [May 6, 2020, 11:29am UTC](https://discuss.elastic.co/t/terms-list-is-incomplete-because-the-request-is-taking-too-long-in-controls-visualization/231282/7 "2020-05-06T11:29:19Z")

</div>

Configuring the length of the value list is not possible, but it's a known feature request. You can track it here: [https://github.com/elastic/kibana/issues/47453](https://github.com/elastic/kibana/issues/47453)

As for case sensitivity - this depends on how the the Elasticsearch mapping is configured. If you want a field to be case-insensitive, you need to put a "lowercase" filter into your analyzer configuration. It's described pretty well in this blog article: [https://pranavprakash.net/2017/09/13/case-insensitive-exact-match-search-in-elasticsearch/](https://pranavprakash.net/2017/09/13/case-insensitive-exact-match-search-in-elasticsearch/)

---

<div class="post-metadata">

**Author:** ![Jaishree\_Pal](https://avatars.discourse-cdn.com/v4/letter/j/f475e1/32.png) [@Jaishree\_Pal](https://discuss.elastic.co/u/Jaishree_Pal)\
**Post date:** [May 6, 2020, 7:38pm UTC](https://discuss.elastic.co/t/terms-list-is-incomplete-because-the-request-is-taking-too-long-in-controls-visualization/231282/8 "2020-05-06T19:38:16Z")

</div>

Thanks a lot @flash1293 for helping me out!

---

<div class="post-metadata">

**Author:** ![bmbrit](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bmbrit/32/63571_2.png) [@bmbrit](https://discuss.elastic.co/u/bmbrit)\
**Post date:** [May 9, 2020, 8:54am UTC](https://discuss.elastic.co/t/terms-list-is-incomplete-because-the-request-is-taking-too-long-in-controls-visualization/231282/9 "2020-05-09T08:54:49Z")

</div>

I'm not part of this thread, but this solution helped me. Thanks Joe again

---

<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:** [June 6, 2020, 8:55am UTC](https://discuss.elastic.co/t/terms-list-is-incomplete-because-the-request-is-taking-too-long-in-controls-visualization/231282/10 "2020-06-06T08:55:10Z")

</div>

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