Getting error when trying to access Cosmos DB analytical storage

Julius Dietmar 20 Reputation points

When running query against Cosmos DB analytical storage, I am getting the following error:

Msg 15893, Level 16, State 51, Line 30

Resolving CosmosDB path has failed with error 'Cosmos DB analytical storage contains no data.'.

Completion time: 2026-05-31T21:17:15.0337245-07:00

This has been working fine previously - no changes - analytical store is still enabled on this collection.

This is the query I am running: 

 SELECT COUNT(*)
 FROM OPENROWSET(​PROVIDER = 'CosmosDB',

 CONNECTION = 'Account=xxx-prod;Database=xxxhtapdb',

 OBJECT = 'items',

 SERVER_CREDENTIAL = 'xxx-prod'


 

 ) as items
;
  1. Manoj Kumar Boyini 17,060 Reputation points • Microsoft External Staff • Moderator

    Hi @Julius Dietmar

    I kindly request you to please share the details requested in the private message for further investigation.

  2. Manoj Kumar Boyini 17,060 Reputation points • Microsoft External Staff • Moderator

    Hi @Julius Dietmar

    As you requested an RCA, I have shared the link to create an SR. Could you please create it and confirm.

Sign in to comment

1 answer

  1. Manoj Kumar Boyini 17,060 Reputation points • Microsoft External Staff • Moderator

    Hi @Julius Dietmar

    We have reviewed the issue and observed that it was transient in nature. Since the issue has now been resolved and access to the Cosmos DB analytical storage is working again, no further action is required at this time.

    As part of our ongoing service improvements, the engineering team is continuously enhancing automated detection and recovery mechanisms to identify similar situations earlier and minimize potential impact on incoming requests.

    We sincerely apologize for any inconvenience this may have caused.

    If you encounter a similar issue in the future, please feel free to reach out to us.

    0 comments No comments
    Sign in to comment
Sign in to answer

Your answer