Cannot deserialize a 'Guid' from BsonType 'ObjectId' in azure cosmos documentdb

95132786 2

I am using Azure mongo db collection and accessing it via dotnet application. I am getting error for some of the documents "Cannot deserialize a 'Guid' from BsonType 'ObjectId'" while retrieving. In dotnet, model class having Id property of type guid and In document db, _id is stored as binary format. Mongo db version which we are using is MongoDB.Driver-"2.27.0". I am trying to access documents via findasync method and filtering using key property. Can you please help me to get out of this issue?

ShaktiSingh-MSFT 14,276 Reputation points Microsoft Employee

2024-07-02T10:22:17.9533333+00:00

Hi 95132786 •,

Welcome to Microsoft Q&A forum.

As I understand, you Cannot deserialize a 'Guid' from BsonType 'ObjectId' in azure cosmos documentdb via dotnet application.

Please refer to the below posts with similar error if that helps:

https://stackoverflow.com/questions/65402783/formatexception-cannot-deserialize-a-guid-from-bsontype-objectid

https://www.mongodb.com/community/forums/t/cannot-deserialize-a-list-string-from-bsontype-string/222464

Let us know if this helped, if not, please share configuration details of your database and sample dotnet code so that we can further look.

Thanks
95132786 2 Reputation points

2024-07-02T10:28:54.96+00:00

This issue I am getting for only few documents in collection. I fixed it by removing filter on key property(which is the partition key). if i add filter on individual property, it is working fine. but filter using key is not working for certain documents.
ShaktiSingh-MSFT 14,276 Reputation points Microsoft Employee

2024-07-03T13:33:17.88+00:00

Hi 95132786 •,

Thanks for the reply.

Could you please ensure that the document has valid Guids?

If this is not issue, we recommend you to raise support case for deeper investigation.

Let us know if you need assistance in doing the same.

Thanks

Share via

Cannot deserialize a 'Guid' from BsonType 'ObjectId' in azure cosmos documentdb