Getting sql search query limit error on azure cosmos db for mongo db when trying to search through multiple fields

Sumit Mahto 20 Reputation points
2024-03-20T06:06:39.0733333+00:00

{"level":"info","message":"error while searching alerts: MongoServerError: Error=2, Details='Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: ; Reason: ({"errors":[{"severity":"Error","location":{"start":0,"end":60},"code":"SC3020","message":"The SQL query text exceeded the maximum limit of 524288 characters."}]});

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,431 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,765 questions
{count} votes

Accepted answer
  1. Amira Bedhiafi 14,251 Reputation points
    2024-03-20T08:43:30.4266667+00:00

    Based on the documentation, Azure Cosmos DB supports querying items using SQL. The following table describes restrictions in query statements, for example in terms of number of clauses or query length.

    User's image

    You can increase any of these SQL query limits by creating an Azure Support request.


0 additional answers

Sort by: Most helpful