https://answers.axonivy.com/questions/3696/how-do-i-change-elastic-search-setting-index-max_result_window<p>For a migration, I need to work with a large set of Elastic Search objects. Setting the limit to 100000, I get the following error:</p> <p>ElasticsearchException: Elasticsearch search documents failed because of: {"root_cause":[{"type":"query_phase_execution_exception","reason":"Result window is too large, from + size must be less than or equal to: [10000] but was [100000]. See the scroll api for a more efficient way to request large data sets. This limit can be set by changing the [index.max_result_window] index level setting."}],...</p> <p>How can the <strong>index.max_result_window</strong> setting be changed. Or - alternatively, how do I access the scroll API?</p> <p>Designer 7.2.1</p> <p>TIA Peter</p>enWed, 27 Feb 2019 08:53:05 -0500https://answers.axonivy.com/questions/3696/how-do-i-change-elastic-search-setting-index-max_result_window/3715<p>This is a limitation of the <code>BusinessDataRepository</code> API. A query like the following will never work with the default elasticsearch index settings:</p> <pre><code>Ivy.repo().search(Data.class).limit(10000, 1000).execute().getAll(); </code></pre> <p>There are two possibilities:</p> <ol> <li> <p>Make some filter condition in your query for your migration now. Query only the first 10000 which are not already migrated. After that you can fire the same query and you will get the next 10000 business data objects.</p> </li> <li> <p>Change the <code>max_result_window</code> size of the index. But the problem is, that the customization of the index is not supported by ivy and must be done manually. <a href="https://stackoverflow.com/questions/35206409/elasticsearch-2-1-result-window-is-too-large-index-max-result-window">https://stackoverflow.com/questions/35206409/elasticsearch-2-1-result-window-is-too-large-index-max-result-window</a></p> </li> </ol> <p>The best solution would be that we provide <strong>the scroll api</strong> for elasticsearch. We'll see how we can make that available.</p>Alex SuterWed, 27 Feb 2019 08:53:05 -0500https://answers.axonivy.com/questions/3696/how-do-i-change-elastic-search-setting-index-max_result_window/3715