[getConversationTags] Error getting conversation tags Error=2, Details='Response status code does not indicate success: BadRequest (400)

[kbeaugrand]

What happened?

I have the application deployed on Azure, using Azure Cosmos DB for Mongo as the database backend.

Application seems to work fine, but I cannot create any bookmark and observe some errors in the backend:

error message is:

[getConversationTags] Error getting conversation tags Error=2, Details='Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: 7a6c112d-c5bf-4e00-890b-8224349dc446; Reason: (Message: {"Errors":["The index path corresponding to the specified order-by item is excluded."]}

Version Information

0.7.8

Steps to Reproduce

1. Login to instance
2. Start a new conversation

What browsers are you seeing the problem on?

No response

Relevant log output

N/A

Screenshots

No response

Code of Conduct

• I agree to follow this project's Code of Conduct

[danny-avila]

Azure CosmosDB is not officially supported, as we do not test or maintain for this integration.

However, that being said, users report almost no issues when using vCore vs RU-based CosmosDB:

https://learn.microsoft.com/en-us/azure/cosmos-db/mongodb/choose-model

[benverhees]

@danny-avila @kbeaugrand I have seen this issue as well on my RU-based CosmosDB. It seems indexes are not added correctly at first startup. After restarting the api container about 3-4 times, the problem seems to be solved for me.

[kbeaugrand]

Yes, this was exactly the problem, thank you.

[benverhees]

@danny-avila @kbeaugrand the problem here is that RU-based CosmosDB encounters rate-limiting while initializing the database and indexes, resulting in errors.
I just tested that with Server Side Retry enabled on the CosmosDB resource, the database is initialized correctly at first startup without issues: https://learn.microsoft.com/en-us/azure/cosmos-db/mongodb/prevent-rate-limiting-errors. For those deploying using Terraform, this is the DisableRateLimitingResponses capability.