none
DataSync: Batch fails to apply 1000 errors

    Întrebare

  • Having an issue with DataSync failing to apply changes and rolling back the batch transaction.

    I have enabled the DSS log and it was not very helpful. Both schemas on Hub and Local match.

    This is the first sync after the initial provision sync to a clean and empty database.

    Any thoughts?

    -Corey

    LocalAgentHost 4/30/2018 4:24:39 PM  id:LocalAgentHost_Info, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Info, agentId:00000000-0000-0000-0000-000000000000, agentInstanceId:00000000-0000-0000-0000-000000000000, version:4.3.6348.1, methodName:Main, message:Microsoft SQL Data Sync Windows service is starting as a Windows Service.
    LocalAgentHost 4/30/2018 4:24:39 PM  id:LocalAgentHost_Info, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Info, agentId:00000000-0000-0000-0000-000000000000, agentInstanceId:00000000-0000-0000-0000-000000000000, version:4.3.6348.1, methodName:OnStart, message:Microsoft SQL Data Sync Windows service starting.
    LocalAgentHost 4/30/2018 4:24:39 PM  id:LocalAgentHost_Info, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Info, agentId:00000000-0000-0000-0000-000000000000, agentInstanceId:00000000-0000-0000-0000-000000000000, version:4.3.6348.1, methodName:OnStart, message:Starting a service worker thread.
    LocalAgentHost 4/30/2018 4:24:39 PM  id:LocalAgentHost_Info, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Info, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:2310d52b-133f-404b-b703-44d3f809555d, version:4.3.6348.1, methodName:OnStart, message:Started a service worker thread.
    LocalAgentHost 4/30/2018 4:24:39 PM  id:LocalAgentHost_Info, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Info, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:2310d52b-133f-404b-b703-44d3f809555d, version:4.3.6348.1, methodName:OnStart, message:Microsoft SQL Data Sync Windows service started successfully.
    LocalAgentHost 4/30/2018 4:24:39 PM  id:LocalAgentHost_Info, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Info, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:2310d52b-133f-404b-b703-44d3f809555d, version:4.3.6348.1, methodName:StartUxWcfService, message: Namedpipe 9d4273fc-5c4e-4502-a0a8-0c6897ef25fd, BaseAddress net.pipe://localhost/9d4273fc-5c4e-4502-a0a8-0c6897ef25fd
    LocalAgentHost 4/30/2018 4:24:40 PM  id:LocalAgentHost_Info, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Info, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:2310d52b-133f-404b-b703-44d3f809555d, version:4.3.6348.1, methodName:StartUxWcfService, message: Opened WCF Host
    LocalAgentHost 4/30/2018 4:24:40 PM  id:LocalAgentHost_Info, rId:, sId:00000000-0000-0000-0000-000000000000, traceLevel:Info, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:2310d52b-133f-404b-b703-44d3f809555d, version:4.3.6348.1, methodName:StartServiceThread, message: GetEntryAssembly().Location: C:\Program Files (x86)\Microsoft SQL Data Sync 2.0\bin\DataSyncLocalAgentHost.exe, GetExecutingAssembly().Location: C:\Program Files (x86)\Microsoft SQL Data Sync 2.0\bin\DataSyncLocalAgentHost.exe, Process.GetCurrentProcess().StartInfo.WorkingDirectory: 
    AgentManagementService 4/30/2018 4:24:44 PM  id:AgentManagementService_InstanceStarted, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, version:4.3.6348.1
    AgentCore 4/30/2018 4:24:45 PM  id:AgentCore_InstanceStarted, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:2310d52b-133f-404b-b703-44d3f809555d, version:4.3.6348.1
    AgentCore 4/30/2018 4:24:45 PM  loggerName:TaskHosting, traceComponent:TaskDispatcher, message:TaskDispatcher is ready to process messages., @logId:TaskDispatcherReady, @level:Information, @eventId:30001, @detail:<Detail><loggerName>TaskHosting</loggerName><traceComponent>TaskDispatcher</traceComponent><message>TaskDispatcher is ready to process messages.</message></Detail>, id:30001
    AgentCore 4/30/2018 4:27:15 PM  jobId:ce634706-d2a4-499f-ae3c-9e7c575976d0, taskId:ff2de022-b852-40fe-975c-637ae11f197a, taskType:2, queueId:6c3e1452-da22-45f4-a0f1-849c9839d188, loggerName:TaskHosting, traceComponent:TaskDispatcher, @logId:PulledOffNewTask, @level:Information, @eventId:30002, @detail:<Detail><jobId>ce634706-d2a4-499f-ae3c-9e7c575976d0</jobId><taskId>ff2de022-b852-40fe-975c-637ae11f197a</taskId><taskType>2</taskType><queueId>6c3e1452-da22-45f4-a0f1-849c9839d188</queueId><loggerName>TaskHosting</loggerName><traceComponent>TaskDispatcher</traceComponent></Detail>, id:30002
    SyncServiceTask 4/30/2018 4:27:15 PM  id:SyncServiceTask_Request, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, taskId:ff2de022-b852-40fe-975c-637ae11f197a, serializedRequest:<?xml version="1.0" encoding="utf-16"?>
    <SyncRequest xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <PostActionSucceededWork xsi:nil="true" />
      <LogInfo>
        <DetailedProviderTraces>false</DetailedProviderTraces>
        <SyncGroupId>15e03a31-faaf-48be-a3be-cf0dbb28c851</SyncGroupId>
        <SyncGroupMemberIdList />
        <HubDbId>9954e9cb-9a24-40ec-a586-c18ef3a509fe</HubDbId>
        <SyncGroupMemberId>d642ec38-d28f-4c01-9cda-4d2d103e6f33</SyncGroupMemberId>
        <AgentId>6c3e1452-da22-45f4-a0f1-849c9839d188</AgentId>
        <AgentInstanceId>00000000-0000-0000-0000-000000000000</AgentInstanceId>
        <TracingId>ff2de022-b852-40fe-975c-637ae11f197a</TracingId>
        <DssServerId>b375b9d2-4596-4a69-9b87-71dc351108bc</DssServerId>
        <DatabaseId>f8abe70b-c140-48fd-bfac-be11a68e3bb4</DatabaseId>
        <SqlAzureActivityId>00000000-0000-0000-0000-000000000000</SqlAzureActivityId>
      </LogInfo>
      <ScopeName>5274B255-03DA-49D0-82C9-625B0319AC84</ScopeName>
      <SyncGroupMemberId>d642ec38-d28f-4c01-9cda-4d2d103e6f33</SyncGroupMemberId>
      <LocalDatabaseId>f8abe70b-c140-48fd-bfac-be11a68e3bb4</LocalDatabaseId>
      <RemoteDatabaseId>9954e9cb-9a24-40ec-a586-c18ef3a509fe</RemoteDatabaseId>
      <ConflictResolutionPolicy>LocalWins</ConflictResolutionPolicy>
      <SyncDirection>Upload</SyncDirection>
      <SqlSyncProviderBatchSizeInMB>24</SqlSyncProviderBatchSizeInMB>
      <SqlSyncProviderMATSizeInMB>25</SqlSyncProviderMATSizeInMB>
      <SqlSyncProviderMatRowCount>50000</SqlSyncProviderMatRowCount>
      <NoInitSync>false</NoInitSync>
    </SyncRequest>
    DatabaseProvider 4/30/2018 4:28:53 PM  id:DbProvider_EnumChanges_NewBatchAvailable, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, syncGroupMemberId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, sqlAzureActivityId:00000000-0000-0000-0000-000000000000, totalBatchesSpooled:1, batchDetails:
    		Version                   :3.1
    		BatchId                   :b3a5fbaf-70cf-4554-86ee-015b281f08c8
    		Batch Number              :1
    		Is Last Batch             :False
    		Data Cache Size           :27682177
    		Table Watermarks          :[Core.PendingDataHistory,127435856],[Core.PendingItemDataHistory,127437786],[Core.QuoteDataHistory,127444475],[Core.QuoteItemDataHistory,127444558],[dbo.Agency,127320791],[dbo.CashReceipt,127443481],[dbo.CashReceiptBatch,127443483],[dbo.CashReceiptEPayment,127443484],[dbo.CashReceiptPolicies,127443482],[dbo.CashReceiptVoid,127421909],[dbo.ClaimMaster,127347651],[dbo.ClaimMasterHistory,127347649],[dbo.ClaimPayment,127374603],[dbo.ClaimPaymentDetail,127350384],[dbo.ClaimReserve,127447227],[dbo.InspectionReportData,127394465],[dbo.InvoiceDueDetail,127448755],[dbo.LogLexisNexis,127448550],[dbo.Payment,127422330],[dbo.PaymentVoid,127285925],[dbo.Pending,127448824],[dbo.PendingAdditionalInsured,127448674],[dbo.PendingBuildingHO,127448738],[dbo.PendingCancelReasons,127394623],[dbo.PendingCoApplicant,127448737],[dbo.PendingCoverage,127448744],[dbo.PendingCoverageSelectionsHO,127448739],[dbo.PendingErrors,127448752],[dbo.PendingInsured,127448735],[dbo.PendingLossHistory,127357264],[dbo.PendingMortgagee,127448691],[dbo.PendingProperty,127448740],[dbo.PendingPropertyHO,127448741],[dbo.PendingRatingWorksheetHO3LA,127446465],[dbo.PendingRatingWorksheetHO3TX,127448723],[dbo.PendingScheduledProperty,127410918],[dbo.Policy,127243292],
    SyncController 4/30/2018 4:28:53 PM  id:SyncController_BatchSpooledEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, memberDbId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, currentBatchNumber:1, totalBatchesSpooled:1, batchFileName:b3a5fbaf-70cf-4554-86ee-015b281f08c8.batch
    SyncBatchStatistics 4/30/2018 4:28:53 PM  id:SyncBatchStatistics_BatchFileSize_AfterSpooled, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, taskId:ff2de022-b852-40fe-975c-637ae11f197a, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, memberDbId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, sizeInBytes:21385269, dataSizeInBytes:21385269, time:04/30/2018 16:28:53
    SyncBatchStatistics 4/30/2018 4:28:53 PM  id:SyncBatchStatistics_BatchFileSize_BeforeApplied, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, taskId:ff2de022-b852-40fe-975c-637ae11f197a, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, memberDbId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, sizeInBytes:21385269, dataSizeInBytes:21385269, time:04/30/2018 16:28:53
    DatabaseProvider 4/30/2018 4:29:04 PM  id:DbProvider_EnumChanges_NewBatchAvailable, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, syncGroupMemberId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, sqlAzureActivityId:00000000-0000-0000-0000-000000000000, totalBatchesSpooled:2, batchDetails:
    		Version                   :3.1
    		BatchId                   :b22a4cda-cd7a-4736-977b-6b20a85b90f5
    		Batch Number              :2
    		Is Last Batch             :False
    		Data Cache Size           :27682304
    		Table Watermarks          :[Core.PendingDataHistory,127435856],[Core.PendingItemDataHistory,127437786],[Core.QuoteDataHistory,127444475],[Core.QuoteItemDataHistory,127444558],[dbo.Agency,127320791],[dbo.CashReceipt,127443481],[dbo.CashReceiptBatch,127443483],[dbo.CashReceiptEPayment,127443484],[dbo.CashReceiptPolicies,127443482],[dbo.CashReceiptVoid,127421909],[dbo.ClaimMaster,127347651],[dbo.ClaimMasterHistory,127347649],[dbo.ClaimPayment,127374603],[dbo.ClaimPaymentDetail,127350384],[dbo.ClaimReserve,127447227],[dbo.InspectionReportData,127394465],[dbo.InvoiceDueDetail,127448755],[dbo.LogLexisNexis,127448550],[dbo.Payment,127422330],[dbo.PaymentVoid,127285925],[dbo.Pending,127448824],[dbo.PendingAdditionalInsured,127448674],[dbo.PendingBuildingHO,127448738],[dbo.PendingCancelReasons,127394623],[dbo.PendingCoApplicant,127448737],[dbo.PendingCoverage,127448744],[dbo.PendingCoverageSelectionsHO,127448739],[dbo.PendingErrors,127448752],[dbo.PendingInsured,127448735],[dbo.PendingLossHistory,127357264],[dbo.PendingMortgagee,127448691],[dbo.PendingProperty,127448740],[dbo.PendingPropertyHO,127448741],[dbo.PendingRatingWorksheetHO3LA,127446465],[dbo.PendingRatingWorksheetHO3TX,127448723],[dbo.PendingScheduledProperty,127410918],[dbo.Policy,127447826],[dbo.PolicyActionItemManual,127445053],[dbo.PolicyActionItems,127448751],[dbo.PolicyAdditionalInsured,127104898],[dbo.PolicyAdjustment,126937209],[dbo.PolicyBalance,127448756],
    SyncController 4/30/2018 4:29:04 PM  id:SyncController_BatchSpooledEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, memberDbId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, currentBatchNumber:2, totalBatchesSpooled:2, batchFileName:b22a4cda-cd7a-4736-977b-6b20a85b90f5.batch
    SyncBatchStatistics 4/30/2018 4:29:04 PM  id:SyncBatchStatistics_BatchFileSize_AfterSpooled, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, taskId:ff2de022-b852-40fe-975c-637ae11f197a, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, memberDbId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, sizeInBytes:30134515, dataSizeInBytes:30134515, time:04/30/2018 16:29:04
    SyncBatchStatistics 4/30/2018 4:29:04 PM  id:SyncBatchStatistics_BatchFileSize_BeforeApplied, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, taskId:ff2de022-b852-40fe-975c-637ae11f197a, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, memberDbId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, sizeInBytes:30134515, dataSizeInBytes:30134515, time:04/30/2018 16:29:04
    DatabaseProvider 4/30/2018 4:30:41 PM  id:DbProvider_EnumChanges_NewBatchAvailable, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, syncGroupMemberId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, sqlAzureActivityId:00000000-0000-0000-0000-000000000000, totalBatchesSpooled:3, batchDetails:
    		Version                   :3.1
    		BatchId                   :4ae1bb3e-1b7d-406d-99bc-40bbf7f74b4a
    		Batch Number              :3
    		Is Last Batch             :False
    		Data Cache Size           :27681996
    		Table Watermarks          :[Core.PendingDataHistory,127435856],[Core.PendingItemDataHistory,127437786],[Core.QuoteDataHistory,127444475],[Core.QuoteItemDataHistory,127444558],[dbo.Agency,127320791],[dbo.CashReceipt,127443481],[dbo.CashReceiptBatch,127443483],[dbo.CashReceiptEPayment,127443484],[dbo.CashReceiptPolicies,127443482],[dbo.CashReceiptVoid,127421909],[dbo.ClaimMaster,127347651],[dbo.ClaimMasterHistory,127347649],[dbo.ClaimPayment,127374603],[dbo.ClaimPaymentDetail,127350384],[dbo.ClaimReserve,127447227],[dbo.InspectionReportData,127394465],[dbo.InvoiceDueDetail,127448755],[dbo.LogLexisNexis,127448550],[dbo.Payment,127422330],[dbo.PaymentVoid,127285925],[dbo.Pending,127448824],[dbo.PendingAdditionalInsured,127448674],[dbo.PendingBuildingHO,127448738],[dbo.PendingCancelReasons,127394623],[dbo.PendingCoApplicant,127448737],[dbo.PendingCoverage,127448744],[dbo.PendingCoverageSelectionsHO,127448739],[dbo.PendingErrors,127448752],[dbo.PendingInsured,127448735],[dbo.PendingLossHistory,127357264],[dbo.PendingMortgagee,127448691],[dbo.PendingProperty,127448740],[dbo.PendingPropertyHO,127448741],[dbo.PendingRatingWorksheetHO3LA,127446465],[dbo.PendingRatingWorksheetHO3TX,127448723],[dbo.PendingScheduledProperty,127410918],[dbo.Policy,127447826],[dbo.PolicyActionItemManual,127445053],[dbo.PolicyActionItems,127448751],[dbo.PolicyAdditionalInsured,127104898],[dbo.PolicyAdjustment,126937209],[dbo.PolicyBalance,127448756],[dbo.PolicyBilling,127448747],[dbo.PolicyBuildingHO,127405925],[dbo.PolicyCancelReasons,127239002],[dbo.PolicyCoApplicant,127405916],[dbo.PolicyCommissionablePremium,127418821],[dbo.PolicyCoverage,127405922],[dbo.PolicyCoverageSelectionsHO,127405923],[dbo.PolicyDocumentsAttached,127448600],[dbo.PolicyDocumentsAttachedDetail,127448599],[dbo.PolicyErrors,127448336],[dbo.PolicyHeader,127447824],[dbo.PolicyInsured,127416787],[dbo.PolicyLossHistory,127100662],[dbo.PolicyMortgagee,127405927],[dbo.PolicyNonRenewal,127270177],[dbo.PolicyProperty,127416788],[dbo.PolicyPropertyHO,127405924],[dbo.PolicyRatingWorksheetHO3LA,127269013],[dbo.PolicyRatingWorksheetHO3TX,127405926],[dbo.PolicyScheduledProperty,127392882],[dbo.PolicyScheduledPropertySummary,127392878],[dbo.Quote,127448823],[dbo.QuoteAdditionalInsured,127448267],[dbo.QuoteBuildingHO,127448806],[dbo.QuoteCoApplicant,127448261],[dbo.QuoteCoverage,127448822],[dbo.QuoteCoverageSelectionsHO,127448807],[dbo.QuoteErrors,127448639],[dbo.QuoteInsured,127445735],
    SyncController 4/30/2018 4:30:41 PM  id:SyncController_BatchSpooledEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, memberDbId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, currentBatchNumber:3, totalBatchesSpooled:3, batchFileName:4ae1bb3e-1b7d-406d-99bc-40bbf7f74b4a.batch
    SyncBatchStatistics 4/30/2018 4:30:41 PM  id:SyncBatchStatistics_BatchFileSize_AfterSpooled, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, taskId:ff2de022-b852-40fe-975c-637ae11f197a, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, memberDbId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, sizeInBytes:24916078, dataSizeInBytes:24916078, time:04/30/2018 16:30:41
    SyncBatchStatistics 4/30/2018 4:30:41 PM  id:SyncBatchStatistics_BatchFileSize_BeforeApplied, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, taskId:ff2de022-b852-40fe-975c-637ae11f197a, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, memberDbId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, sizeInBytes:24916078, dataSizeInBytes:24916078, time:04/30/2018 16:30:41
    DatabaseProvider 4/30/2018 4:36:36 PM  id:DbProvider_EnumChanges_CompleteEnumForAllTables, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, syncGroupMemberId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, sqlAzureActivityId:00000000-0000-0000-0000-000000000000, totalBatches:3
    DatabaseProvider 4/30/2018 4:36:39 PM  id:DbProvider_EnumChanges_NewBatchAvailable, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, syncGroupMemberId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, sqlAzureActivityId:00000000-0000-0000-0000-000000000000, totalBatchesSpooled:4, batchDetails:
    		Version                   :3.1
    		BatchId                   :ab38bd70-6dc2-40ec-8ea4-f7fb5594aa4d
    		Batch Number              :4
    		Is Last Batch             :True
    		Data Cache Size           :21830117
    		Table Watermarks          :[Core.PendingDataHistory,127435856],[Core.PendingItemDataHistory,127437786],[Core.QuoteDataHistory,127444475],[Core.QuoteItemDataHistory,127444558],[dbo.Agency,127320791],[dbo.CashReceipt,127443481],[dbo.CashReceiptBatch,127443483],[dbo.CashReceiptEPayment,127443484],[dbo.CashReceiptPolicies,127443482],[dbo.CashReceiptVoid,127421909],[dbo.ClaimMaster,127347651],[dbo.ClaimMasterHistory,127347649],[dbo.ClaimPayment,127374603],[dbo.ClaimPaymentDetail,127350384],[dbo.ClaimReserve,127447227],[dbo.InspectionReportData,127394465],[dbo.InvoiceDueDetail,127448755],[dbo.LogLexisNexis,127448550],[dbo.Payment,127422330],[dbo.PaymentVoid,127285925],[dbo.Pending,127448824],[dbo.PendingAdditionalInsured,127448674],[dbo.PendingBuildingHO,127448738],[dbo.PendingCancelReasons,127394623],[dbo.PendingCoApplicant,127448737],[dbo.PendingCoverage,127448744],[dbo.PendingCoverageSelectionsHO,127448739],[dbo.PendingErrors,127448752],[dbo.PendingInsured,127448735],[dbo.PendingLossHistory,127357264],[dbo.PendingMortgagee,127448691],[dbo.PendingProperty,127448740],[dbo.PendingPropertyHO,127448741],[dbo.PendingRatingWorksheetHO3LA,127446465],[dbo.PendingRatingWorksheetHO3TX,127448723],[dbo.PendingScheduledProperty,127410918],[dbo.Policy,127447826],[dbo.PolicyActionItemManual,127445053],[dbo.PolicyActionItems,127448751],[dbo.PolicyAdditionalInsured,127104898],[dbo.PolicyAdjustment,126937209],[dbo.PolicyBalance,127448756],[dbo.PolicyBilling,127448747],[dbo.PolicyBuildingHO,127405925],[dbo.PolicyCancelReasons,127239002],[dbo.PolicyCoApplicant,127405916],[dbo.PolicyCommissionablePremium,127418821],[dbo.PolicyCoverage,127405922],[dbo.PolicyCoverageSelectionsHO,127405923],[dbo.PolicyDocumentsAttached,127448600],[dbo.PolicyDocumentsAttachedDetail,127448599],[dbo.PolicyErrors,127448336],[dbo.PolicyHeader,127447824],[dbo.PolicyInsured,127416787],[dbo.PolicyLossHistory,127100662],[dbo.PolicyMortgagee,127405927],[dbo.PolicyNonRenewal,127270177],[dbo.PolicyProperty,127416788],[dbo.PolicyPropertyHO,127405924],[dbo.PolicyRatingWorksheetHO3LA,127269013],[dbo.PolicyRatingWorksheetHO3TX,127405926],[dbo.PolicyScheduledProperty,127392882],[dbo.PolicyScheduledPropertySummary,127392878],[dbo.Quote,127448823],[dbo.QuoteAdditionalInsured,127448267],[dbo.QuoteBuildingHO,127448806],[dbo.QuoteCoApplicant,127448261],[dbo.QuoteCoverage,127448822],[dbo.QuoteCoverageSelectionsHO,127448807],[dbo.QuoteErrors,127448639],[dbo.QuoteInsured,127448781],[dbo.QuoteMortgagee,127448269],[dbo.QuoteProperty,127448808],[dbo.QuotePropertyHO,127448785],[dbo.QuoteRatingWorksheetHO3LA,127448809],[dbo.QuoteRatingWorksheetHO3TX,127448654],[dbo.UserProfile,127339001],[Core.PendingData,127436059],[Core.PendingItem,127437766],[Core.PendingItemData,127437785],[Core.PolicyData,127416912],[Core.PolicyItem,127418392],[Core.PolicyItemData,127418817],[Core.QuoteData,127444459],[Core.QuoteItem,127444411],[Core.QuoteItemData,127444548],[Core.PendingRaterFactor,127437922],[Core.PendingRaterItemFactor,127439215],[Core.PolicyRaterFactor,127416855],[Core.PolicyRaterItemFactor,127418814],[Core.QuoteRaterFactor,127432852],[Core.QuoteRaterItemFactor,127434173],
    SyncController 4/30/2018 4:36:39 PM  id:SyncController_BatchSpooledEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, memberDbId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, currentBatchNumber:4, totalBatchesSpooled:4, batchFileName:ab38bd70-6dc2-40ec-8ea4-f7fb5594aa4d.batch
    SyncBatchStatistics 4/30/2018 4:36:39 PM  id:SyncBatchStatistics_BatchFileSize_AfterSpooled, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, taskId:ff2de022-b852-40fe-975c-637ae11f197a, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, memberDbId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, sizeInBytes:22666954, dataSizeInBytes:22666954, time:04/30/2018 16:36:39
    SyncBatchStatistics 4/30/2018 4:36:39 PM  id:SyncBatchStatistics_BatchFileSize_BeforeApplied, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, taskId:ff2de022-b852-40fe-975c-637ae11f197a, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, memberDbId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, sizeInBytes:22666954, dataSizeInBytes:22666954, time:04/30/2018 16:36:39
    SyncController 4/30/2018 4:36:49 PM  id:SyncController_BatchAppliedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, memberDbId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, currentBatchNumber:1, totalBatches:4
    SyncController 4/30/2018 4:37:01 PM  id:SyncController_BatchAppliedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, memberDbId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, currentBatchNumber:2, totalBatches:4
    SyncController 4/30/2018 4:37:14 PM  id:SyncController_BatchAppliedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, memberDbId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, currentBatchNumber:3, totalBatches:4
    SyncController 4/30/2018 4:37:33 PM  id:SyncController_BatchAppliedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, memberDbId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, currentBatchNumber:4, totalBatches:4
    SyncController 4/30/2018 4:38:47 PM  id:SyncController_ChangeConflictedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, changesFailedTillNow:100
    SyncController 4/30/2018 4:39:18 PM  id:SyncController_ChangeConflictedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, changesFailedTillNow:200
    SyncController 4/30/2018 4:40:02 PM  id:SyncController_ChangeConflictedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, changesFailedTillNow:300
    SyncController 4/30/2018 4:51:21 PM  id:SyncController_ChangeFailedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, changesFailedTillNow:100
    SyncController 4/30/2018 4:51:41 PM  id:SyncController_ChangeFailedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, changesFailedTillNow:200
    SyncController 4/30/2018 4:51:59 PM  id:SyncController_ChangeFailedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, changesFailedTillNow:300
    SyncController 4/30/2018 4:52:18 PM  id:SyncController_ChangeFailedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, changesFailedTillNow:400
    SyncController 4/30/2018 4:52:37 PM  id:SyncController_ChangeFailedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, changesFailedTillNow:500
    SyncController 4/30/2018 4:52:55 PM  id:SyncController_ChangeFailedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, changesFailedTillNow:600
    SyncController 4/30/2018 4:53:15 PM  id:SyncController_ChangeFailedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, changesFailedTillNow:700
    SyncController 4/30/2018 4:53:34 PM  id:SyncController_ChangeFailedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, changesFailedTillNow:800
    SyncController 4/30/2018 4:53:50 PM  id:SyncController_ChangeFailedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, changesFailedTillNow:900
    SyncController 4/30/2018 4:54:06 PM  id:SyncController_ChangeFailedEvent, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, changesFailedTillNow:1000
    DatabaseProvider 4/30/2018 4:54:06 PM  id:DbProvider_RelationalSyncProvider_Exception, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, syncGroupMemberId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, sqlAzureActivityId:32b1dbca-58fb-4c14-9694-19e31c597593, e:'Type=Microsoft.SqlAzureDataSync.ClientServerCommon.SyncAbortedDueToLargeErrorCountException,Message=,Source=Microsoft.SqlAzureDataSync.SyncControllerLib,StackTrace=   at Microsoft.SqlAzureDataSync.SyncControllerLib.SyncController.ResolveConflict(DbApplyChangeFailedEventArgs e&#44; ProviderType providerType)
       at Microsoft.SqlAzureDataSync.SyncControllerLib.SyncController.RemoteProvider_ApplyChangeFailed(Object sender&#44; DbApplyChangeFailedEventArgs e)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.OnApplyChangeFailed(DbApplyChangeFailedEventArgs value)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.GetConflictAction(DbSyncConflict conflict&#44; Exception error&#44; IDbTransaction transaction)
       at Microsoft.Synchronization.Data.ChangeHandlerBase.ApplyChange(FailedDeleteDelegate_type failedDeleteDelegate)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.ApplyChangesInternal(DbSyncScopeMetadata scopeMetadata&#44; IDbTransaction transaction&#44; FailedDeleteDelegate_type failedDeleteDelegate&#44; DataSet dataSet&#44; ChangeApplicationType applyType)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.ApplyChanges(DbSyncScopeMetadata scopeMetadata&#44; IDbTransaction applyTransaction&#44; DataSet dataSet&#44; Int64 dataSetSize&#44; Int64 dataSetDataSize&#44; DbSyncSession DbSyncSession&#44; Boolean commitTransaction&#44; FailedDeleteDelegate_type failedDeleteDelegate&#44; String batchFileName&#44; ChangeApplicationAction&amp; action),', eType:'Type=Microsoft.SqlAzureDataSync.ClientServerCommon.SyncAbortedDueToLargeErrorCountException', eMessage:'Message=', eTypeInner:, eMessageInner:
    DatabaseProvider 4/30/2018 4:54:06 PM  id:DbProvider_MultiTransactionApplyChangesAdapter_Exception, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, syncGroupMemberId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, sqlAzureActivityId:32b1dbca-58fb-4c14-9694-19e31c597593, e:'Type=Microsoft.SqlAzureDataSync.ClientServerCommon.SyncAbortedDueToLargeErrorCountException,Message=,Source=Microsoft.SqlAzureDataSync.SyncControllerLib,StackTrace=   at Microsoft.SqlAzureDataSync.SyncControllerLib.SyncController.ResolveConflict(DbApplyChangeFailedEventArgs e&#44; ProviderType providerType)
       at Microsoft.SqlAzureDataSync.SyncControllerLib.SyncController.RemoteProvider_ApplyChangeFailed(Object sender&#44; DbApplyChangeFailedEventArgs e)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.OnApplyChangeFailed(DbApplyChangeFailedEventArgs value)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.GetConflictAction(DbSyncConflict conflict&#44; Exception error&#44; IDbTransaction transaction)
       at Microsoft.Synchronization.Data.ChangeHandlerBase.ApplyChange(FailedDeleteDelegate_type failedDeleteDelegate)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.ApplyChangesInternal(DbSyncScopeMetadata scopeMetadata&#44; IDbTransaction transaction&#44; FailedDeleteDelegate_type failedDeleteDelegate&#44; DataSet dataSet&#44; ChangeApplicationType applyType)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.ApplyChanges(DbSyncScopeMetadata scopeMetadata&#44; IDbTransaction applyTransaction&#44; DataSet dataSet&#44; Int64 dataSetSize&#44; Int64 dataSetDataSize&#44; DbSyncSession DbSyncSession&#44; Boolean commitTransaction&#44; FailedDeleteDelegate_type failedDeleteDelegate&#44; String batchFileName&#44; ChangeApplicationAction&amp; action)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.SingleTransactionApplyChangesAdapter.Apply(DataSet dataSet&#44; Boolean commitTransaction&#44; FailedDeleteDelegate_type failedDeleteDelegate&#44; String batchFileName&#44; ChangeApplicationAction&amp; action)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.MultiTransactionApplyChangesAdapter.CommitChanges(ChangeApplicationAction&amp; continueAction),', eType:'Type=Microsoft.SqlAzureDataSync.ClientServerCommon.SyncAbortedDueToLargeErrorCountException', eMessage:'Message=', eTypeInner:, eMessageInner:
    DatabaseProvider 4/30/2018 4:54:06 PM  id:DbProvider_SingleTransactionApplyChangesAdapter_Error, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:00000000-0000-0000-0000-000000000000, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, syncGroupMemberId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, sqlAzureActivityId:32b1dbca-58fb-4c14-9694-19e31c597593, message:Rolling back application transaction.
    SyncServiceTask 4/30/2018 4:54:10 PM  id:SyncServiceTask_ExceptionProcessingRequest, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, taskId:ff2de022-b852-40fe-975c-637ae11f197a, e:'Type=Microsoft.Synchronization.Data.DbSyncException,Message=An unexpected error occurred when applying batch file C:\Users\SQLENG~1\AppData\Local\Temp\DSS2_ff2de022-b852-40fe-975c-637ae11f197a\sync_6b9e1311234c4655ad47dbf7e062e513c2aa4918a8044a62b3f8c5bfe9e0135d\ab38bd70-6dc2-40ec-8ea4-f7fb5594aa4d.batch. See the inner exception for more details.,Source=Microsoft.Synchronization,StackTrace=   at Microsoft.Synchronization.Data.DbSyncBatchConsumer.ApplyBatches(DbSyncScopeMetadata scopeMetadata&#44; DbSyncSession syncSession&#44; SyncSessionStatistics sessionStatistics)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.ProcessChangeBatch(ConflictResolutionPolicy resolutionPolicy&#44; ChangeBatch sourceChanges&#44; Object changeDataRetriever&#44; SyncCallbacks syncCallbacks&#44; SyncSessionStatistics sessionStatistics)
       at Microsoft.Synchronization.KnowledgeProviderProxy.ProcessChangeBatch(CONFLICT_RESOLUTION_POLICY resolutionPolicy&#44; ISyncChangeBatch pSourceChangeManager&#44; Object pUnkDataRetriever&#44; ISyncCallback pCallback&#44; _SYNC_SESSION_STATISTICS&amp; pSyncSessionStatistics)
       at Microsoft.Synchronization.CoreInterop.ISyncSession.Start(CONFLICT_RESOLUTION_POLICY resolutionPolicy&#44; _SYNC_SESSION_STATISTICS&amp; pSyncSessionStatistics)
       at Microsoft.Synchronization.KnowledgeSyncOrchestrator.DoOneWaySyncHelper(SyncIdFormatGroup sourceIdFormats&#44; SyncIdFormatGroup destinationIdFormats&#44; KnowledgeSyncProviderConfiguration destinationConfiguration&#44; SyncCallbacks DestinationCallbacks&#44; ISyncProvider sourceProxy&#44; ISyncProvider destinationProxy&#44; ChangeDataAdapter callbackChangeDataAdapter&#44; SyncDataConverter conflictDataConverter&#44; Int32&amp; changesApplied&#44; Int32&amp; changesFailed)
       at Microsoft.Synchronization.KnowledgeSyncOrchestrator.DoOneWayKnowledgeSync(SyncDataConverter sourceConverter&#44; SyncDataConverter destinationConverter&#44; SyncProvider sourceProvider&#44; SyncProvider destinationProvider&#44; Int32&amp; changesApplied&#44; Int32&amp; changesFailed)
       at Microsoft.Synchronization.KnowledgeSyncOrchestrator.Synchronize()
       at Microsoft.Synchronization.SyncOrchestrator.Synchronize()
       at Microsoft.SqlAzureDataSync.SyncControllerLib.SyncController.SyncInternal(SyncJobParams syncJobParams&#44; SyncDirectionOrder syncDirectionOrder&#44; String batchingDirectoryPath)
       at Microsoft.SqlAzureDataSync.LocalAgentHost.LocalAgentSyncControllerService.ExecuteSync(SyncJobParams syncJobParams&#44; SyncDirectionOrder syncDirection&#44; String batchingDir&#44; LogInfo logInfo&#44; Func`4 syncInternal)
       at Microsoft.SqlAzureDataSync.SyncControllerLib.SyncController.Sync(String scopeName&#44; SyncJobParams syncJobParams&#44; SyncDirectionOrder syncDirection&#44; String batchingDir)
       at Microsoft.SqlAzureDataSync.SyncControllerLib.SyncTask.&lt;&gt;c__DisplayClass6.&lt;Execute&gt;b__1()
       at Microsoft.Practices.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Microsoft.SqlAzureDataSync.ClientServerCommon.CommonHelperMethods.ExecuteAction[T](Func`1 func&#44; ITransientErrorDetectionStrategy errorDetectionStrategy&#44; RetryStrategy retryStrategy&#44; Action`1 onRetryAction)
       at Microsoft.SqlAzureDataSync.SyncControllerLib.SyncTask.Execute(),'
    'Type=Microsoft.SqlAzureDataSync.ClientServerCommon.SyncAbortedDueToLargeErrorCountException,Message=,Source=Microsoft.SqlAzureDataSync.SyncControllerLib,StackTrace=   at Microsoft.SqlAzureDataSync.SyncControllerLib.SyncController.ResolveConflict(DbApplyChangeFailedEventArgs e&#44; ProviderType providerType)
       at Microsoft.SqlAzureDataSync.SyncControllerLib.SyncController.RemoteProvider_ApplyChangeFailed(Object sender&#44; DbApplyChangeFailedEventArgs e)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.OnApplyChangeFailed(DbApplyChangeFailedEventArgs value)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.GetConflictAction(DbSyncConflict conflict&#44; Exception error&#44; IDbTransaction transaction)
       at Microsoft.Synchronization.Data.ChangeHandlerBase.ApplyChange(FailedDeleteDelegate_type failedDeleteDelegate)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.ApplyChangesInternal(DbSyncScopeMetadata scopeMetadata&#44; IDbTransaction transaction&#44; FailedDeleteDelegate_type failedDeleteDelegate&#44; DataSet dataSet&#44; ChangeApplicationType applyType)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.ApplyChanges(DbSyncScopeMetadata scopeMetadata&#44; IDbTransaction applyTransaction&#44; DataSet dataSet&#44; Int64 dataSetSize&#44; Int64 dataSetDataSize&#44; DbSyncSession DbSyncSession&#44; Boolean commitTransaction&#44; FailedDeleteDelegate_type failedDeleteDelegate&#44; String batchFileName&#44; ChangeApplicationAction&amp; action)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.SingleTransactionApplyChangesAdapter.Apply(DataSet dataSet&#44; Boolean commitTransaction&#44; FailedDeleteDelegate_type failedDeleteDelegate&#44; String batchFileName&#44; ChangeApplicationAction&amp; action)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.MultiTransactionApplyChangesAdapter.CommitChanges(ChangeApplicationAction&amp; continueAction)
       at Microsoft.Synchronization.Data.DbSyncBatchConsumer.ApplyBatches(DbSyncScopeMetadata scopeMetadata&#44; DbSyncSession syncSession&#44; SyncSessionStatistics sessionStatistics),', eType:'Type=Microsoft.Synchronization.Data.DbSyncException', eMessage:'Message=An unexpected error occurred when applying batch file C:\Users\SQLENG~1\AppData\Local\Temp\DSS2_ff2de022-b852-40fe-975c-637ae11f197a\sync_6b9e1311234c4655ad47dbf7e062e513c2aa4918a8044a62b3f8c5bfe9e0135d\ab38bd70-6dc2-40ec-8ea4-f7fb5594aa4d.batch. See the inner exception for more details.', eTypeInner:'Type=Microsoft.SqlAzureDataSync.ClientServerCommon.SyncAbortedDueToLargeErrorCountException', eMessageInner:'Message='
    CommandAndControlService 4/30/2018 4:54:10 PM  id:CommandAndControlService_ServerResponseHandler_SyncResponse, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, taskId:ff2de022-b852-40fe-975c-637ae11f197a, taskState:Failed, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, memberDbId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDbId:9954e9cb-9a24-40ec-a586-c18ef3a509fe
    CommandAndControlService_SyncTasks 4/30/2018 4:54:10 PM  id:CommandAndControlService_TaskDetails, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, tracingId:ff2de022-b852-40fe-975c-637ae11f197a, taskId:ff2de022-b852-40fe-975c-637ae11f197a, actionId:ce634706-d2a4-499f-ae3c-9e7c575976d0, taskState:Failed, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:99479731-2518-4710-a08d-6898c6d09c86, databaseId:f8abe70b-c140-48fd-bfac-be11a68e3bb4, hubDatabaseId:9954e9cb-9a24-40ec-a586-c18ef3a509fe, syncGroupId:15e03a31-faaf-48be-a3be-cf0dbb28c851, syncGroupMemberId:d642ec38-d28f-4c01-9cda-4d2d103e6f33, creationTime:4/30/2018 4:27:33 PM, pickupTime:4/30/2018 4:27:15 PM, completedTime:4/30/2018 4:54:10 PM, lastResetTime:4/30/2018 4:27:33 PM, priority:0, taskType:2, version:3, failureLog:Sync was aborted because more than 1000 changes failed to apply. Examine your table schemas to look for conflicting constraints or incompatible data types that may prevent sync from succeeding.
    SyncServiceTask 4/30/2018 4:54:10 PM  id:SyncServiceTask_Response, rId:, sId:b375b9d2-4596-4a69-9b87-71dc351108bc, agentId:6c3e1452-da22-45f4-a0f1-849c9839d188, agentInstanceId:99479731-2518-4710-a08d-6898c6d09c86, taskId:ff2de022-b852-40fe-975c-637ae11f197a, serializedResponse:<?xml version="1.0" encoding="utf-16"?>
    <SyncResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <State>Failed</State>
      <LogInfo>
        <DetailedProviderTraces>false</DetailedProviderTraces>
        <SyncGroupId>15e03a31-faaf-48be-a3be-cf0dbb28c851</SyncGroupId>
        <SyncGroupMemberIdList />
        <HubDbId>9954e9cb-9a24-40ec-a586-c18ef3a509fe</HubDbId>
        <SyncGroupMemberId>d642ec38-d28f-4c01-9cda-4d2d103e6f33</SyncGroupMemberId>
        <AgentId>6c3e1452-da22-45f4-a0f1-849c9839d188</AgentId>
        <AgentInstanceId>99479731-2518-4710-a08d-6898c6d09c86</AgentInstanceId>
        <TracingId>ff2de022-b852-40fe-975c-637ae11f197a</TracingId>
        <DssServerId>b375b9d2-4596-4a69-9b87-71dc351108bc</DssServerId>
        <DatabaseId>f8abe70b-c140-48fd-bfac-be11a68e3bb4</DatabaseId>
        <SqlAzureActivityId>00000000-0000-0000-0000-000000000000</SqlAzureActivityId>
      </LogInfo>
      <FailureLog>Sync was aborted because more than 1000 changes failed to apply. Examine your table schemas to look for conflicting constraints or incompatible data types that may prevent sync from succeeding.</FailureLog>
      <PostActionSucceededWork xsi:nil="true" />
      <TaskId>ff2de022-b852-40fe-975c-637ae11f197a</TaskId>
      <JobId>ce634706-d2a4-499f-ae3c-9e7c575976d0</JobId>
      <TaskCreationTime>2018-04-30T16:27:33.733</TaskCreationTime>
      <TaskPickupTime>2018-04-30T16:27:15.712391Z</TaskPickupTime>
      <TaskResetTime>2018-04-30T16:27:33.733</TaskResetTime>
      <TaskVersion>3</TaskVersion>
      <SyncGroupMemberId>d642ec38-d28f-4c01-9cda-4d2d103e6f33</SyncGroupMemberId>
      <DownloadChangesTotal>0</DownloadChangesTotal>
      <DownloadChangesApplied>0</DownloadChangesApplied>
      <DownloadChangesFailed>0</DownloadChangesFailed>
      <UploadChangesTotal>0</UploadChangesTotal>
      <UploadChangesApplied>0</UploadChangesApplied>
      <UploadChangesFailed>0</UploadChangesFailed>
      <StartTime>0001-01-01T00:00:00</StartTime>
      <EndTime>0001-01-01T00:00:00</EndTime>
      <FailureType>Generic</FailureType>
    </SyncResponse>
    AgentCore 4/30/2018 4:54:10 PM  jobId:ce634706-d2a4-499f-ae3c-9e7c575976d0, taskId:ff2de022-b852-40fe-975c-637ae11f197a, queueId:6c3e1452-da22-45f4-a0f1-849c9839d188, loggerName:TaskHosting, traceComponent:ThreadTaskWorker, @logId:MessageDeleted, @level:Information, @eventId:30011, @detail:<Detail><jobId>ce634706-d2a4-499f-ae3c-9e7c575976d0</jobId><taskId>ff2de022-b852-40fe-975c-637ae11f197a</taskId><queueId>6c3e1452-da22-45f4-a0f1-849c9839d188</queueId><loggerName>TaskHosting</loggerName><traceComponent>ThreadTaskWorker</traceComponent></Detail>, id:30011


    30 aprilie 2018 17:39

Răspunsuri

  • I was able to track this down to a couple poorly designed tables that had their Primary Key's being updated.

    This is not supported by Azure Data Sync.

    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-sync-data

    General requirements: Each table must have a primary key. Don't change the value of the primary key in any row.

    If you have to change a primary key value, delete the row and recreate it with the new primary key value.



    15 mai 2018 15:09

Toate mesajele

  • Hello,

    Could you please verify again the schemas are the same? Use SSDT to verify.

    https://msdn.microsoft.com/en-us/library/hh272690%28v=vs.103%29.aspx?f=255&MSPPError=-2147217396


    How many tables you added to the job? Did you add many tables at once? Could you try to delete the sync group, run the deprovisionutil.exe and distribute tables among more Sync Groups?

    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com


    30 aprilie 2018 20:23
  • Hello,

    Could you please verify again the schemas are the same? Use SSDT to verify.

    https://msdn.microsoft.com/en-us/library/hh272690%28v=vs.103%29.aspx?f=255&MSPPError=-2147217396


    How many tables you added to the job? Did you add many tables at once? Could you try to delete the sync group, run the deprovisionutil.exe and distribute tables among more Sync Groups?

    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com


    There are 236 tables in the sync group, they were all added at once. The initial synchronization completes without error, the error starts showing on the first triggered sync post initial synchronization. I have tried rebuilding the sync group several times with the de-provision successfully completely between provisions. I have used Schema Compare in Visual Studio SSDT to compare the tables and they are all the same definition local and hub.

    Thanks.

    30 aprilie 2018 21:23
  • Another note: This same sync configuration works on our development environment without issues. It's only failing in 1 environment.

    Also, As for the schema's needing to be the same: We are using SSDT DACPAC's to perform deployments to the servers. This process more-or-less guarantees the schema's being the same.

    30 aprilie 2018 21:26
  • I was able to track this down to a couple poorly designed tables that had their Primary Key's being updated.

    This is not supported by Azure Data Sync.

    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-sync-data

    General requirements: Each table must have a primary key. Don't change the value of the primary key in any row.

    If you have to change a primary key value, delete the row and recreate it with the new primary key value.



    15 mai 2018 15:09