Azure SQL Database
An Azure relational database service.
4,315 questions
Content
1 answer
Azure Hyperscale (i.e Citus) (now Azure cosmosDB) to stop support for Posgresql 11 in Nov'23 - what this means for customers like us ?
Hi, We are customer of Azure Hyperscale (Citus) DB for postgresql and currently using postgresql 11 under the hood. We are informed by Microsoft that support for Hyperscale on postgresql 11 will be stopped in Nov'23 and we need to upgrade to postgresql…
asked 2023-09-27T14:26:57.36+00:00
![](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(224.00000000000003, 53%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Deole, Pushkar (Pushkar)
20
Reputation points
answered 2023-09-27T21:10:21.6133333+00:00
Oury Ba-MSFT
13,346
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
DatabaseAccount is in a failed provisioning state because the previous attempt to create it was not successful. Please delete the previous instance before attempting to recreate this account.
While deploying Azure cosmos DB, it is ending up in failed state and all the other following operations related to it are ending up in Bad requests.
asked 2023-09-26T01:36:50.1666667+00:00
![](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(192, 67%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
Manisha Jakkula
20
Reputation points Microsoft Employee
accepted 2023-09-27T20:50:04.5666667+00:00
Manisha Jakkula
20
Reputation points Microsoft Employee
1 answer
Limited or No Access upon signing up for 30 day Cosmos DB trial
You are not a member of this tenant and do not have access to this directory or any subscriptions/resources within. Your interactions will be limited to directory switching or passthrough scenarios only. Click 'I acknowledge' to continue to as a…
asked 2023-09-09T16:11:44.1033333+00:00
![](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(51.2, 84%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDF%3C/text%3E%3C/svg%3E)
David Friedel
6
Reputation points
commented 2023-09-27T20:13:10.6566667+00:00
David Friedel
6
Reputation points
2 answers
How to solve this Invalid/Missing environment variable error while build
Getting Error: Invalid/Missing environment variable: "MONGODB_URL" while deploying nextjs mongodb app in azure. i have added env variables on configuration - Application settings, but still deployment getting failed.
![](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(297.6, 2%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
1 answer
cosmosSearch vector search aggregation pipeline filtering on an id
Trying out the new vector search feature in Mongodb vCore. Not able to find a lot of documentation in usage but basically trying to search on vector content but filter on or have exact match on a specific id in addition to the vector search. The below…
asked 2023-06-30T11:06:03.9766667+00:00
![](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(86.4, 93%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Reza S
10
Reputation points
edited an answer 2023-09-27T16:45:45.9566667+00:00
![](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(259.20000000000005, 95%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHG%3C/text%3E%3C/svg%3E)
Hunt, Gabe
0
Reputation points
1 answer
How to backup and restore Cosmos DB with Postgres and Citus?
Hello, We are using Azure Cosmos DB with Postgres using Citus. We would like to know how we can do proper backup and restore to be safe in case of a disaster for business continuity reasons. We have read…
asked 2023-09-08T11:50:35.1133333+00:00
![](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(115.19999999999999, 20%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEB%3C/text%3E%3C/svg%3E)
Eric Bergqvist
0
Reputation points
commented 2023-09-27T14:43:42.8266667+00:00
GeethaThatipatri-MSFT
21,476
Reputation points Microsoft Employee
0 answers
CosmosDB order by issue
When we add order by in the sql statement, the results of the query are inconsistent with those without adding order by. Thanks we created composite index: FILENAME and FIELID. SELECT DISTINCT…
asked 2023-09-26T09:28:27.8166667+00:00
![](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(268.8, 68%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXK%3C/text%3E%3C/svg%3E)
Xu, Kyson K
121
Reputation points
edited a comment 2023-09-27T01:52:25.4933333+00:00
Xu, Kyson K
121
Reputation points
2 answers
What should I do about the Azure Function Http trigger not connecting to Cosmos DB?
I am learning the module called "Chain Azure Functions together using input and output bindings". The previous modules are learning without any problem and can successfully access the http trigger via url. But in this module, I have…
asked 2023-08-23T07:28:10.7166667+00:00
![](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(294.40000000000003, 90%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWK%3C/text%3E%3C/svg%3E)
Wang Kangli
30
Reputation points
edited a comment 2023-09-26T17:59:43.9933333+00:00
![](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(198.4, 34%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENW%3C/text%3E%3C/svg%3E)
Nathan Wilson (ITSCo - US)
5
Reputation points
1 answer
Can Stream Analytics Update values in an existing table in Cosmos DB PostgreSQL?
Hi, I was wondering if I could update data in Cosmos DB for PostgreSQL table using Stream Analytics. I receive data through IOTHub and instead of adding rows of data I need to update values in different rows and columns. It seems that Stream Analytics…
asked 2023-09-25T00:36:43.08+00:00
![](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(25.6, 76%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Ben Rad
0
Reputation points
commented 2023-09-26T16:40:28.31+00:00
ShaikMaheer-MSFT
34,536
Reputation points Microsoft Employee
0 answers
how to log into azure cosmos db
i tried to create an account to azure cosmos db but i wont able to log in azure cosmos db, why?
asked 2023-09-21T20:13:51.6633333+00:00
![](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(169.60000000000002, 59%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Masuku Thabile
0
Reputation points
commented 2023-09-25T21:26:27.9633333+00:00
GeethaThatipatri-MSFT
21,476
Reputation points Microsoft Employee
1 answer
Azure CosmosDb for MongoDb - vCore // manage users
Hi Does anyone know when support for managing users in CosmosDb for MongoDb vCore will become available ? We are not really happy with giving admin credentials to users and RU model is way too expensive at the moment. thanks AndyB
asked 2023-09-22T13:19:33.5+00:00
![](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(57.599999999999994, 63%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Andy Buckley - CAI
0
Reputation points
commented 2023-09-25T21:24:55.9633333+00:00
GeethaThatipatri-MSFT
21,476
Reputation points Microsoft Employee
0 answers
Cant find keys in cosmos db. Account Key needed for looker studio connection
When I access Cosmos DB through Azure portal, my settings don't contain a keys section so I am unable to find an Account Key to connect my DB to a BI platform.
asked 2023-09-22T10:26:57.21+00:00
![](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(182.40000000000003, 92%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MakiPan
0
Reputation points
commented 2023-09-25T21:20:56.7133333+00:00
Oury Ba-MSFT
13,346
Reputation points Microsoft Employee
1 answer
Add Vectors / Hybrid Search with Cognitive Search on (NOSQL) Cosmos DB Data
Hello, Trying to set up semantic search on a cosmos db (nosql). A) How to add vectors to cosmos db content ? The simple way for me would be to compute them myself and add a "vector" key to each database item. Is there another way ? Maybe…
asked 2023-09-21T15:00:10.0966667+00:00
![](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(172.8, 6%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAO%3C/text%3E%3C/svg%3E)
Adrien O'Hana
0
Reputation points
answered 2023-09-25T19:54:42.5266667+00:00
Azar
2,365
Reputation points
2 answers
One of the answers was accepted by the question author.
NullPointerException on the save method when id is specified with optimistic concurrency
Description My team is attempting to set the id field on a document and are running into a NullPointerException from the ReactiveCosmosTemplate when saving the document off to the DB. We're utilizing optimistic concurrency with the use of @Version on an…
asked 2023-09-21T19:11:32.34+00:00
![](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(240, 23%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Murillo, Antonio J
20
Reputation points
accepted 2023-09-25T19:42:10.6333333+00:00
Murillo, Antonio J
20
Reputation points
0 answers
i am unable to connect and access azure cosmos for mongo db using its private end point ip. address.
i have created an azure cosmos for mongo. in network setting only private end point is enabled. i am able to telnet private end point ip from vm in same vnet but not able to connect mongo db using its private end point ip address. why we can not…
asked 2023-09-21T18:30:00.05+00:00
![](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(268.8, 85%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHP%3C/text%3E%3C/svg%3E)
Harish Poshangir
0
Reputation points
edited a comment 2023-09-25T15:59:41.1166667+00:00
Harish Poshangir
0
Reputation points
1 answer
How to separate the some of the execution tree logs to show on transaction search on application Insights?
I've have multiple application has let say 20 apps in a sequence(both rest and non rest), out 14 apps are in the loop per each record process. If I Process 1000 records it will loop 14 apps. if any of the record failed to process in any application, I…
asked 2023-09-21T07:17:31.9633333+00:00
![](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(92.8, 88%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Prasanna Kumar T
0
Reputation points
answered 2023-09-25T08:25:37.8533333+00:00
![](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(275.2, 41%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AnuragSingh-MSFT
16,011
Reputation points
0 answers
Hangfire is not working for CosmosDB after migrating from MongoDB giving error: A bulk write operation resulted in one or more errors. WriteErrors: [ { Category : "DuplicateKey", Code : 11000, Message : "E11000 duplicate key error collection: Hangfire
We were using MongoDb in our project and Hangfire was working perfectly fine over there but after we have shifted to CosmosDb Hangfire has stopped working, we are using MongoClient only to connect to CosmosDB by passing CosmosDB connection string to…
asked 2023-09-06T10:25:26.57+00:00
![](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(169.60000000000002, 20%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Murtuza Pithawala
0
Reputation points
commented 2023-09-22T17:18:31.4166667+00:00
Oury Ba-MSFT
13,346
Reputation points Microsoft Employee
0 answers
Ideal RUs for Cosmos DB Container
I have a container in cosmos db which is getting used frequently in the application, i have provided Throughput as 400 Rus as of now along with required indexing policy , i want to know how can i give the correct number of RUs to container so that the…
asked 2023-09-19T10:45:11.1233333+00:00
![](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(12.8, 72%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
siddharth bansal
221
Reputation points
commented 2023-09-21T19:47:45.8166667+00:00
GeethaThatipatri-MSFT
21,476
Reputation points Microsoft Employee
2 answers
Long running 101 responses when querying Cosmos using Gremlin
Trying to diagnose some odd behaviour from CosmosDB when querying using Gremlin: I've got a Blazor site that is querying Cosmos. It's regularly timing out, or taking a long time to pull back results from Cosmos. I've reduced the code down to: var…
asked 2023-09-18T07:37:53.4533333+00:00
![](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(188.79999999999998, 88%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chris Bampton
0
Reputation points
answered 2023-09-21T09:32:12.88+00:00
ShaktiSingh-MSFT
9,481
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Partial indexes support is currently not enabled, please reach out to Cosmos DB support to enable this feature.
How can I contact the support to enable this feature without paying for a support plan? Shouldn't it be a feature flag to be enabled?
asked 2023-01-21T13:10:53.4466667+00:00
Rhuan Barreto
20
Reputation points
commented 2023-09-20T18:02:42.6366667+00:00
António Lima
0
Reputation points