https://answers.axonivy.com/questions/2763/exception-when-querying-business-data-with-sorting<p>Hi ivyTeam</p> <p>Querying data from business data </p> <pre><code>repo().search(getType()).orderBy().textField("processName").ascending().execute().getAll(); </code></pre> <p>It throws the exception:</p> <pre><code>Caused by: ch.ivyteam.ivy.business.data.store.search.internal.elasticsearch.ElasticsearchException: Elasticsearch search documents failed because of: {"root_cause":[{"type":"search_parse_exception","reason":"No mapping found for [processName.ascii] in order to sort on"}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":[{"shard":0,"index":"ivy.businessdata","node":"swxYYakvQMCJMMyVDyQhfA","reason":{"type":"search_parse_exception","reason":"No mapping found for [processName.ascii] in order to sort on"}}]} at ch.ivyteam.ivy.business.data.store.search.internal.elasticsearch.JestOperation.checkStatusAndThrow(JestOperation.java:62) at ch.ivyteam.ivy.business.data.store.search.internal.elasticsearch.JestOperation.execute(JestOperation.java:40) at ch.ivyteam.ivy.business.data.store.search.internal.elasticsearch.JestSearcher.search(JestSearcher.java:32) at ch.ivyteam.ivy.business.data.store.search.internal.ResultImpl.execute(ResultImpl.java:38) at ch.ivyteam.ivy.business.data.store.search.internal.QueryImpl.raw(QueryImpl.java:128) at ch.ivyteam.ivy.business.data.store.search.internal.QueryImpl.executeQuery(QueryImpl.java:174) at ch.ivyteam.ivy.business.data.store.search.internal.QueryImpl.execute(QueryImpl.java:107) at ch.ivyteam.ivy.business.data.store.search.internal.OrderByFieldOrLimitImpl.execute(OrderByFieldOrLimitImpl.java:29) at ch.ivy.addon.portalkit.service.ExpressProcessService.findAllOrderByName(ExpressProcessService.java:11) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at ch.ivyteam.ivy.scripting.internal.types.IvyJavaMethod.invokeImpl(IvyJavaMethod.java:73) ... 280 more </code></pre> <p>It happens on Axon.ivy Engine RC-6.6.2.55064. In designer, sometimes it happens as well. Could you please guide us how to fix the problem?</p>enTue, 18 Jul 2017 03:04:41 -0400https://answers.axonivy.com/questions/2763/exception-when-querying-business-data-with-sorting/2768<p><strong>Axon.ivy &gt;= 6.7</strong></p> <p>This issue has been fixed with the Axon.ivy version &gt;= 6.7. See issue <a href="https://jira.axonivy.com/jira/browse/XIVY-2042">XIVY-2042 Business Data Sorting fails on a field for which no data exists</a></p> <p><strong>Before Axon.ivy 6.7</strong></p> <p>As a workaround add a simple BusinessData existence check query before you do the real query. </p> <pre><code>long totalCount = BusinessDataRepository.get().search(MyBusinessData.class).execute().totalCount(); if (totalCount &gt; 0) { //you query here... } </code></pre>Reguel WermelingerTue, 18 Jul 2017 03:04:41 -0400https://answers.axonivy.com/questions/2763/exception-when-querying-business-data-with-sorting/2768