none
Exception while Syncing Databases

    Question

  • Hello,

    We are using Microsoft Sync Framework 2.0 with .Net Freamwork 3.5 to Synchronize databases.

    For very first time provisioning(when no tracking tables present on both source and destination databases) all tables get successfully downloaded. But after that if some data changes are made in Source database, below exception occurs (No schema changes)

    The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error. ---> System.ServiceModel.CommunicationException: The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error.

    Exception occurs at

    SyncService.RelationalProviderProxy.GetChangeBatch(UInt32 batchSize, SyncKnowledge destinationKnowledge, Object& changeDataRetriever)

    It is observed that, within the given scope, all tables except 1(consider name as 'MedicalDrugs') are downloaded. Source database holds records in MedicalDrugs_tracking table but destination database doesn't hold any record in MedicalDrugs_tracking.

    I deleted records from scope_config, scope_info, scope_parameters, scope_templates and MedicalDrugs_tracking tables from Source database; recreated destination database, but still same error persist.

    Do we need to clean up metadata at destination database? How and when to clean up metadata?

    Please advise.

    Thanks,

    Priyanka

    Thursday, May 26, 2016 12:13 PM