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

Question

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

Sumit Mahto 20

{"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."}]});

ShaktiSingh-MSFT 16,271 Reputation points

2024-03-21T07:34:03.6766667+00:00

Hi Sumit Mahto,

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

Accepted answer

0 additional answers

Your answer

ShaktiSingh-MSFT 16,271 Reputation points

2024-03-21T07:34:03.6766667+00:00

Hi Sumit Mahto,

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

Answer 1

Amira Bedhiafi 31,391

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.

Sumit Mahto 20 Reputation points

2024-03-22T07:09:14.0133333+00:00

Hey looking into the solution that you provided . Will get back with the outcome. Thanks !

Share via

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

0 additional answers

Your answer