# Elastic Search integration with Magneto 2.3.3 Version **URL:** \ **Category:** Elasticsearch\ **Created:** [May 28, 2020, 7:35am UTC](https://discuss.elastic.co/t/elastic-search-integration-with-magneto-2-3-3-version/234680 "2020-05-28T07:35:06Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![parthipan\_p](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/parthipan_p/32/68337_2.png) [@parthipan\_p](https://discuss.elastic.co/u/parthipan_p)\ **Post date:** [May 28, 2020, 7:35am UTC](https://discuss.elastic.co/t/elastic-search-integration-with-magneto-2-3-3-version/234680/1 "2020-05-28T07:35:06Z")
I am getting empty results while searching for the frontend. Got the below error in log file. main.CRITICAL: {"error":{"root\_cause":[{"type":"query\_shard\_exception","reason":"No mapping found for [position~asc] in order to sort on","index\_uuid":"rJsF6r3yS5OPrTn7iUcIkg","index":"tc\_dev\_product\_1\_v2"}],"type":"search\_phase\_execution\_exception","reason":"all shards failed","phase":"query","grouped":true,"failed\_shards":[{"shard":0,"index":"tc\_dev\_product\_1\_v2","node":"kA6-CxIIQ\_KGdGAKF5mgGA","reason":{"type":"query\_shard\_exception","reason":"No mapping found for [position~asc] in order to sort on","index\_uuid":"rJsF6r3yS5OPrTn7iUcIkg","index":"tc\_dev\_product\_1\_v2"}}]},"status":400} {"exception":"[object] (Elasticsearch\Common\Exceptions\BadRequest400Exception(code: 400): {"error":{"root\_cause":[{"type":"query\_shard\_exception","reason":"No mapping found for [position~asc] in order to sort on","index\_uuid":"rJsF6r3yS5OPrTn7iUcIkg","index":"tc\_dev\_product\_1\_v2"}],"type":"search\_phase\_execution\_exception","reason":"all shards failed","phase":"query","grouped":true,"failed\_shards":[{"shard":0,"index":"tc\_dev\_product\_1\_v2","node":"kA6-CxIIQ\_KGdGAKF5mgGA","reason":{"type":"query\_shard\_exception","reason":"No mapping found for [position~asc] in order to sort on","index\_uuid":"rJsF6r3yS5OPrTn7iUcIkg","index":"tc\_dev\_product\_1\_v2"}}]},"status":400} at /var/app/current/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Connections/Connection.php:636)"} I checked the below commands in the elastic search server and got like this, Command : curl [http://localhost:9200/index/\_mapping?pretty](http://localhost:9200/index/_mapping?pretty) Output : { "error" : { "root\_cause" : [ { "type" : "index\_not\_found\_exception", "reason" : "no such index", "resource.type" : "index\_or\_alias", "resource.id" : "index", "index\_uuid" : "_na_", "index" : "index" } ], "type" : "index\_not\_found\_exception", "reason" : "no such index", "resource.type" : "index\_or\_alias", "resource.id" : "index", "index\_uuid" : "_na_", "index" : "index" }, "status" : 404 } Elastic suite server verison : 6.8.5 What could be the issue? Can someone please help to solve this issue. Thanks in advance. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [May 28, 2020, 8:33am UTC](https://discuss.elastic.co/t/elastic-search-integration-with-magneto-2-3-3-version/234680/2 "2020-05-28T08:33:16Z")
> [@parthipan\_p](#): > > Command : curl [http://localhost:9200/index/\_mapping?pretty](http://localhost:9200/index/_mapping?pretty) The index name is `tc_dev_product_1_v2` not `index`. Call: ``` curl http://localhost:9200/tc_dev_product_1_v2/_mapping?pretty ``` If you want to share the output, please format your code, logs or configuration files using `` icon as explained in [this guide](https://discuss.elastic.co/t/about-the-elasticsearch-category/21) and not the citation button. It will make your post more readable. Or use markdown style like: ```` ``` CODE ``` ```` This is the icon to use if you are not using markdown format: ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/e/7e6e239431ec2d71cbf1beef741f2e93e7cc762c.jpg) There's a live preview panel for exactly this reasons. Lots of people read these forums, and many of them will simply skip over a post that is difficult to read, because it's just too large an investment of their time to try and follow a wall of badly formatted text. If your goal is to get an answer to your questions, it's in your interest to make it as easy to read and understand as possible. ---
**Author:** ![parthipan\_p](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/parthipan_p/32/68337_2.png) [@parthipan\_p](https://discuss.elastic.co/u/parthipan_p)\ **Post date:** [May 28, 2020, 9:00am UTC](https://discuss.elastic.co/t/elastic-search-integration-with-magneto-2-3-3-version/234680/3 "2020-05-28T09:00:43Z")
Hi David, Thanks for your response and sorry for the inconvenience caused. I will follow your comment in further query. I will check this and let you know. Thanks, ---
**Author:** ![parthipan\_p](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/parthipan_p/32/68337_2.png) [@parthipan\_p](https://discuss.elastic.co/u/parthipan_p)\ **Post date:** [May 28, 2020, 10:44am UTC](https://discuss.elastic.co/t/elastic-search-integration-with-magneto-2-3-3-version/234680/4 "2020-05-28T10:44:08Z")
Hi David, I tried the curl command which you have shared and getting the same issue. Please find screenshot for your reference. ![turfcare](https://us1.discourse-cdn.com/elastic/original/3X/f/d/fdb6815b9e2ad2bdbe92753f744b6b00df52b000.png) Thanks, ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [May 28, 2020, 12:56pm UTC](https://discuss.elastic.co/t/elastic-search-integration-with-magneto-2-3-3-version/234680/5 "2020-05-28T12:56:56Z")
Please don't post images of text as they are hard to read, may not display correctly for everyone, and are not searchable. Instead, paste the text and format it with `` icon or pairs of triple backticks (```), and check the preview window to make sure it's properly formatted before posting it. This makes it more likely that your question will receive a useful answer. What is the output of: ```auto GET /_cat/indices?v ``` Note that you can run this command in Kibana Dev Console. Otherwise transform it to curl command like: ```auto curl -XGET http://localhost:9200/_cat/indices?v ``` ---
**Author:** ![parthipan\_p](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/parthipan_p/32/68337_2.png) [@parthipan\_p](https://discuss.elastic.co/u/parthipan_p)\ **Post date:** [May 29, 2020, 8:08am UTC](https://discuss.elastic.co/t/elastic-search-integration-with-magneto-2-3-3-version/234680/6 "2020-05-29T08:08:07Z")
While running the following command, I got the below result **Command :** ```auto curl -XGET http://localhost:9200/_cat/indices?v ``` **Result :** ``` ubuntu@ip-172-31-19-11:~$ curl -XGET http://localhost:9200/_cat/indices?v health status index uuid pri rep docs.count docs.deleted store.size pri.store.size yellow open tc_dev_product_3_v8 17H7wt8mRL6QVSz_KkkBUg 5 1 144068 0 21.4mb 21.4mb yellow open tc_dev_product_1_v8 _KpItME4RkynV_ZXse-tGQ 5 1 144068 0 21.6mb 21.6mb yellow open adam_turfcare_product_1_v2 5cX7njCfRc6fJqVcVWnxbQ 5 1 10001 0 1.6mb 1.6mb green open magento2_default_thesaurus_20200527_201730 ndgMX27LTC2n1y5cX6bS3w 1 0 0 0 261b 261b green open magento2_default_catalog_category_20200527_201727 i7WKdIqjQ7iCYETrNUm9Vw 1 0 35 0 27.2kb 27.2kb ``` Then I try the below command and get some outputs (its too large one). **Command:** ```auto curl http://localhost:9200/tc_dev_product_3_v8/_mapping?pretty ``` Thanks ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [May 29, 2020, 9:17am UTC](https://discuss.elastic.co/t/elastic-search-integration-with-magneto-2-3-3-version/234680/7 "2020-05-29T09:17:41Z")
Share it on [gist.github.com](http://gist.github.com) if too large. ---
**Author:** ![parthipan\_p](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/parthipan_p/32/68337_2.png) [@parthipan\_p](https://discuss.elastic.co/u/parthipan_p)\ **Post date:** [May 29, 2020, 9:32am UTC](https://discuss.elastic.co/t/elastic-search-integration-with-magneto-2-3-3-version/234680/8 "2020-05-29T09:32:00Z")
Please find below the gist link here, [Gist GitHub URL](https://gist.github.com/parthipanpargunan/9ff3283719f50c91e5b2ea88ea6d654f) Thanks, ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [June 2, 2020, 1:20pm UTC](https://discuss.elastic.co/t/elastic-search-integration-with-magneto-2-3-3-version/234680/9 "2020-06-02T13:20:43Z")
There's no field named `position~asc` in your mapping. That explains why you can not sort on this field. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 30, 2020, 1:20pm UTC](https://discuss.elastic.co/t/elastic-search-integration-with-magneto-2-3-3-version/234680/10 "2020-06-30T13:20:43Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.