how to fix an issue where records are not syncing from Dataverse to Azure Database intermittently?

Gustavo Mercado (LTIMINDTREE LIMITED) 20 Reputation points Microsoft Vendor
2024-07-02T21:16:35.34+00:00

Successfully generated a summary

I am experiencing an issue where records are not syncing from Dataverse to Azure Database intermittently, specifically for the Payment (evx_payment) entity. The affected records only sync when the customer manually updates them from CRM. I have over a million records in the affected entity. I am using the DataverseCDMToSQL DataFlow in Synapse Analytic Studio to push the data to the Azure DB.

Can anyone please help me with this error? thank you so much in advanced.

Azure SQL Database
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.
4,621 questions
Microsoft Dataverse Training
Microsoft Dataverse Training
Microsoft Dataverse: A Microsoft service that enables secure storage and management of data used by business apps. Previously known as Common Data Service.Training: Instruction to develop new skills.
14 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Gustavo Mercado (LTIMINDTREE LIMITED) 20 Reputation points Microsoft Vendor
    2024-07-02T23:33:25.1+00:00

    No error message

    For example, there are 1,000,000 records in Dataverse but finally in the database when i check 1000 records are missing.

    I really don't know why this happens?

    0 comments