question

Developer-1906 avatar image
0 Votes"
Developer-1906 asked GeethaThatipatri-MSFT commented

Unable to load any document in mongodb from data explorer

Unable to load any document in mongodb from data explorer, I'm able to view the database and collection but when I click on any of the documents, it doesn't load and there's an error.

Error reading document: , Payload: {"db":"*","coll":"*","resourceUrl":"*","rid":"*","rtype":"docs","sid":"*","rg":"*","dba":"*","pk":"*"}

It's working fine few days ago, I tried to create a new collection/database and incognito mode but the problem persist. Could anyone confirm if this is a problem on my end or Azure's end, and if there's solution?

Thanks in advance.


azure-cosmos-dbazure-data-explorer
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Same here. I'm unable to use the Data Explorer to list the documents, because I get very similar error.

However I'm able to use the shell for the commands (using MongoDB underneath) - if that is any help :)

I also don't see any incident report in Azure Service Health as of yet, so it's probably some fresh issue.

0 Votes 0 ·
GeethaThatipatri-MSFT avatar image
1 Vote"
GeethaThatipatri-MSFT answered GeethaThatipatri-MSFT commented

Hi @Developer-1906 and Dear All,
Sorry for the inconvenience caused that you are seeing issues loading any document in MongoDB from the data explorer.
The previous release of data explorer for Cosmos DB introduced a regression where Mongo documents failed to load for some customers. A hotfix to address this issue was released this morning.
now you should be able to load the document from Data explorer.

Please let us know if you still find any issues.

Regards
Geetha

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, @Developer-1906 We haven't heard back from you. Just wanted to check if you are still facing the issue? Please do click on 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to the answer as the issue is fixed,

Regards
Geetha

0 Votes 0 ·

Thank you for visiting the Microsoft QA forums! Have a great day!

Regards
Geetha

0 Votes 0 ·
Ruchika-1578 avatar image
0 Votes"
Ruchika-1578 answered Ruchika-1578 published

We are having the same issue since this morning

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MartinGarciaJuanDiego-6030 avatar image
0 Votes"
MartinGarciaJuanDiego-6030 answered

We are having the same issue since this morning. Any update?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MartinGarciaJuanDiego-6030 avatar image
0 Votes"
MartinGarciaJuanDiego-6030 answered RodolfoWagner-2651 commented

I think that must be related. It doesnt work if collection is sharded
200189-image.png



It works If collection is unsharded


image.png (7.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

my collection is unsharded and it does not work

1 Vote 1 ·
LucianoCanales-6194 avatar image
0 Votes"
LucianoCanales-6194 answered LucianoCanales-6194 edited

Having same issue. Just with some collections that were created the same day. But there is no problem with other collection in the database.
Collection can be accessed using shell, the problem is just with de explorer

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Ruchika-1578 avatar image
0 Votes"
Ruchika-1578 answered

Here's a workaround as suggested by Microsoft:

  1. Double click to select the document Id and copy

  2. Copy the document Id to a query as below and execute the query to view the data:
    200444-image.png



image.png (117.8 KiB)
image.png (76.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.