Synapse : Resolving CosmosDB path has failed with error 'Unable to find Root.Metadata timestamp.'.

Tata, Sai Abhinav 6 Reputation points
2023-01-09T13:10:39.173+00:00

Hi Team,

I am getting the following error when trying to access a database from CosmosDB inside Synapse. It was working fine and is happening only with a single collection in CosmosDB. 277688-277473-image.png

Any help is appreciated.

Thank You Abhinav

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,175 questions
{count} vote

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,602 Reputation points Microsoft Employee
    2023-01-21T00:03:09.6266667+00:00

    Hello @TataSaiAbhinav-6768,

    Thanks for your response. If there is no harm is deleting and recreating it, then I would definitely give a try. First try to create a new with same data and try if throws the same error or it works fine. If it works fine, then try deleting and recreating it and see how it goes.

    If you notice the same behavior even after deleting and recreating it, then I would recommend filing a support ticket for deeper investigation. If you have a support plan and to create a support ticket, you can follow the steps described in this document: Create an Azure support request

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.