Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Syncing data between master detail tables RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    We have an application that syncs data between server and clients bidirectionally. The database includes several master - detail tables including Order and OrderDetails tables.Each table belongs to its own sync group. Sometimes, OrderDetails from an Order are not sent to the server but the Order itself is sent. If we try to sync again from the client, the SqlCeClientSyncProvider does not recognize the OrderDetail record as a change and therefore cannot sent it anymore on the server.This does not happen with other master detail tables.

    On the other hand, sometimes, even the Order is not sent along with the OrderDetails.For example:

    Below you can see three Orders.The middle one did not sent on the server.

    93df795a-a92b-420a-9e37-79da8d7b2b06	596006	595642
7e47ce17-e02f-48af-9749-66b82aa8721e	596657	596076
e944815f-bf64-4d8a-9e7b-b89b91dd3211	598235	597911

    The SentAnchor of the tables is, which is the same in all other tables:

    Order	598236
OrderDetail	598236

    Thanks,

    Friday, November 23, 2012 2:30 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    have you confirmed that the change is not sent or is not selected versus it being sent/detected but not applied?

    have you subscribed to the ApplyChangeFailed event to check if there are any issues when applying the change?

    Wednesday, November 28, 2012 12:49 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I have confirmed that the change is not selected from the ChangesSelected event of the client sync provider. Although, I have not subscribed to the ApplyChangeFailed event which I intend to do.

    Thanks,

    Wednesday, November 28, 2012 1:17 PM