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

asked 2023-01-09T13:10:39.173+00:00
Tata, Sai Abhinav 1 Reputation point

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.
2,600 questions
{count} votes

1 answer

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

    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

    No comments