Friday, November 23, 2012 2:30 PM
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
Wednesday, November 28, 2012 12:49 PMModerator
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 1:17 PM
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.