This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 7.000000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEP%3C/text%3E%3C/svg%3E)
Hi, after trying to query data from cosmos db (configured for mongo), but I got error on .sort({"at": -1})
Everything works on localhost mongo db very well, but not in azure.
Trace back from python is:
2024-04-09T13:02:08.1267872Z Traceback (most recent call last):
2024-04-09T13:02:08.1306576Z File "/tmp/8dc58941c15dbc9/Infinity/Server/_returns.py", line 18, in innerRegistration
2024-04-09T13:02:08.1315265Z tmpValue = f(*args, **kwargs)
2024-04-09T13:02:08.1348454Z ^^^^^^^^^^^^^^^^^^
2024-04-09T13:02:08.1355683Z File "/tmp/8dc58941c15dbc9/Infinity/Api/analysis.py", line 19, in _GetRunningAnalyses
2024-04-09T13:02:08.1389641Z return AnalysisController.GetAnalyses()
2024-04-09T13:02:08.1397553Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-04-09T13:02:08.1432439Z File "/tmp/8dc58941c15dbc9/Infinity/Analysis/analysis.py", line 64, in GetAnalyses
2024-04-09T13:02:08.1439683Z for i in DB.QueryEntitiesCursor(cls.CT_REQUESTS, {}).sort({"at": -1}):
2024-04-09T13:02:08.1505329Z File "/tmp/8dc58941c15dbc9/antenv/lib/python3.11/site-packages/pymongo/cursor.py", line 1264, in next
2024-04-09T13:02:08.1513024Z if len(self.__data) or self._refresh():
2024-04-09T13:02:08.1520545Z ^^^^^^^^^^^^^^^
2024-04-09T13:02:08.1529464Z File "/tmp/8dc58941c15dbc9/antenv/lib/python3.11/site-packages/pymongo/cursor.py", line 1181, in _refresh
2024-04-09T13:02:08.1537585Z self.__send_message(q)
2024-04-09T13:02:08.1616121Z File "/tmp/8dc58941c15dbc9/antenv/lib/python3.11/site-packages/pymongo/cursor.py", line 1060, in __send_message
2024-04-09T13:02:08.1624920Z response = client._run_operation(
2024-04-09T13:02:08.1632082Z ^^^^^^^^^^^^^^^^^^^^^^
2024-04-09T13:02:08.1700891Z File "/tmp/8dc58941c15dbc9/antenv/lib/python3.11/site-packages/pymongo/_csot.py", line 107, in csot_wrapper
2024-04-09T13:02:08.1715095Z return func(self, *args, **kwargs)
2024-04-09T13:02:08.1723368Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-04-09T13:02:08.1730873Z File "/tmp/8dc58941c15dbc9/antenv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1394, in _run_operation
2024-04-09T13:02:08.1796623Z return self._retryable_read(
2024-04-09T13:02:08.1803733Z ^^^^^^^^^^^^^^^^^^^^^
2024-04-09T13:02:08.1811626Z File "/tmp/8dc58941c15dbc9/antenv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1492, in _retryable_read
2024-04-09T13:02:08.1818927Z return self._retry_internal(
2024-04-09T13:02:08.1827725Z ^^^^^^^^^^^^^^^^^^^^^
2024-04-09T13:02:08.1894053Z File "/tmp/8dc58941c15dbc9/antenv/lib/python3.11/site-packages/pymongo/_csot.py", line 107, in csot_wrapper
2024-04-09T13:02:08.1902563Z return func(self, *args, **kwargs)
2024-04-09T13:02:08.1910010Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-04-09T13:02:08.1917169Z File "/tmp/8dc58941c15dbc9/antenv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1462, in _retry_internal
2024-04-09T13:02:08.1924926Z ).run()
2024-04-09T13:02:08.1995756Z ^^^^^
2024-04-09T13:02:08.2004565Z File "/tmp/8dc58941c15dbc9/antenv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 2315, in run
2024-04-09T13:02:08.2012439Z return self._read() if self._is_read else self._write()
2024-04-09T13:02:08.2020872Z ^^^^^^^^^^^^
2024-04-09T13:02:08.2087296Z File "/tmp/8dc58941c15dbc9/antenv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 2444, in _read
2024-04-09T13:02:08.2095610Z return self._func(self._session, self._server, conn, read_pref) # type: ignore
2024-04-09T13:02:08.2103908Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-04-09T13:02:08.2110885Z File "/tmp/8dc58941c15dbc9/antenv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1390, in _cmd
2024-04-09T13:02:08.2117842Z return server.run_operation(
2024-04-09T13:02:08.2181787Z ^^^^^^^^^^^^^^^^^^^^^
2024-04-09T13:02:08.2190476Z File "/tmp/8dc58941c15dbc9/antenv/lib/python3.11/site-packages/pymongo/helpers.py", line 322, in inner
2024-04-09T13:02:08.2198087Z return func(*args, **kwargs)
2024-04-09T13:02:08.2206177Z ^^^^^^^^^^^^^^^^^^^^^
2024-04-09T13:02:08.2214347Z File "/tmp/8dc58941c15dbc9/antenv/lib/python3.11/site-packages/pymongo/server.py", line 167, in run_operation
2024-04-09T13:02:08.2280454Z _check_command_response(first, conn.max_wire_version)
2024-04-09T13:02:08.2289686Z File "/tmp/8dc58941c15dbc9/antenv/lib/python3.11/site-packages/pymongo/helpers.py", line 230, in _check_command_response
2024-04-09T13:02:08.2297918Z raise OperationFailure(errmsg, code, response, max_wire_version)
2024-04-09T13:02:08.2306330Z pymongo.errors.OperationFailure: Error=2, Details='Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: d9d6af32-94d7-45fc-9da8-2204a6bc5471; Reason: (Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: d9d6af32-94d7-45fc-9da8-2204a6bc5471; Reason: (Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: d9d6af32-94d7-45fc-9da8-2204a6bc5471; Reason: (Message: {"Errors":["The index path corresponding to the specified order-by item is excluded."]}
2024-04-09T13:02:08.2313918Z ActivityId: d9d6af32-94d7-45fc-9da8-2204a6bc5471, Request URI: /apps/ccadfd1a-514d-45de-8701-00c2650cc8e5/services/ac5cdff8-1e51-4471-ac45-1d216ccdf14d/partitions/ab2e4e06-278f-46d7-88c2-ba0284788e8f/replicas/133571385087626579s/, RequestStats: Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, SDK: Windows/10.0.20348 cosmos-netstandard-sdk/3.18.0);););, full error: {'ok': 0.0, 'errmsg': 'Error=2, Details='Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: d9d6af32-94d7-45fc-9da8-2204a6bc5471; Reason: (Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: d9d6af32-94d7-45fc-9da8-2204a6bc5471; Reason: (Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: d9d6af32-94d7-45fc-9da8-2204a6bc5471; Reason: (Message: {"Errors":["The index path corresponding to the specified order-by item is excluded."]}\r\nActivityId: d9d6af32-94d7-45fc-9da8-2204a6bc5471, Request URI: /apps/ccadfd1a-514d-45de-8701-00c2650cc8e5/services/ac5cdff8-1e51-4471-ac45-1d216ccdf14d/partitions/ab2e4e06-278f-46d7-88c2-ba0284788e8f/replicas/133571385087626579s/, RequestStats: Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, SDK: Windows/10.0.20348 cosmos-netstandard-sdk/3.18.0);););', 'code': 2, 'codeName': 'BadValue'}
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi @Erik Palenčík ,
Just checking in to see if the provided suggestion helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know. Thanks
One common cause is that an index path corresponding to the specified order-by item is excluded or the order by query does not have a corresponding composite index that it can be served from. The query requests a sort on a field that is not indexed.
Hi @Sajeetharan ,
1.
in classic mongo (on my windows localhost) sort works well without manual creation of index. Is there any specific reason why azure cosmos mongo don't ?
2.
i created index with mongo shell, and I have still totally same error
(I also tested code on C#, error is not on side of python driver)
pymongo.errors.OperationFailure: Error=2, Details='Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: c5b89d1c-11b6-4622-b35d-993cda61bd03; Reason: (Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: c5b89d1c-11b6-4622-b35d-993cda61bd03; Reason: (Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: c5b89d1c-11b6-4622-b35d-993cda61bd03; Reason: (Message: {"Errors":["This query requires an index on ORDER BY attribute. The index is currently being built. You can track indexing progress: http://aka.ms/track-index-progress."]}
ActivityId: c5b89d1c-11b6-4622-b35d-993cda61bd03, Request URI: /apps/b528bb94-2f2a-4b37-bc4b-5d14e492cff3/services/9f8229d7-8743-4436-b5db-4fdf4987f6c4/partitions/c14941b3-1a6a-4313-832d-5ec0fe068036/replicas/133553289012018219s/, RequestStats: Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, SDK: Windows/10.0.20348 cosmos-netstandard-sdk/3.18.0);););, full error: {'ok': 0.0, 'errmsg': 'Error=2, Details='Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: c5b89d1c-11b6-4622-b35d-993cda61bd03; Reason: (Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: c5b89d1c-11b6-4622-b35d-993cda61bd03; Reason: (Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: c5b89d1c-11b6-4622-b35d-993cda61bd03; Reason: (Message: {"Errors":["This query requires an index on ORDER BY attribute. The index is currently being built. You can track indexing progress: http:\/\/aka.ms\/track-index-progress."]}\r\nActivityId: c5b89d1c-11b6-4622-b35d-993cda61bd03, Request URI: /apps/b528bb94-2f2a-4b37-bc4b-5d14e492cff3/services/9f8229d7-8743-4436-b5db-4fdf4987f6c4/partitions/c14941b3-1a6a-4313-832d-5ec0fe068036/replicas/133553289012018219s/, RequestStats: Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, SDK: Windows/10.0.20348 cosmos-netstandard-sdk/3.18.0);););', 'code': 2, 'codeName': 'BadValue'}
Hi @Erik Palenčík ,
This is strange and not expected. I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you.
Thanks
@Sajeetharan I posted ticket :)
Hi @Erik Palenčík ,
Thanks for your reply.
Please share the solution here on the Q&A forum so that others facing similar issue could be benefitted.
Thank you!