In a current project we use sychronization between SQL server 2008 and and SQLCE on a windows moblie device. The server runs a WCF service. Due to the possibility of large data to be synchronized we have implemented a batching.
Later I've noticed that the device stops to stops to asks for more batches, even if it isn't done. The times I've counted it have ended after 6 batches, no matter the size of them. The SyncAgent.Synchronize() returns normal with a legit SyncStatistic. And if I do a new call on SyncAgent.Synchronize() more it will resume the synchronization, with another 6 batches.
Further down are the group meta data from the actual communication sent between the client and server. As you can see in both the request and response the batchcount is greater than 1 and the the new anchor differs from the max anchor.
Where should I start to look for errors?
GetChanges:
<groupMetadata><GroupName>WorkOrderDepending</GroupName><NewAnchor><Anchor> AAEAAAD/////AQAAAAAAAAAEAQAAAAxTeXN0ZW0uSW50NjQBAAAAB21fdmFsdWUACUNDAwAAAAAA
Cw==</Anchor></NewAnchor><MaxAnchor><Anchor>AAEAAAD/////AQAAAAAAAAAEAQAAAAxTeXN0ZW0uSW50NjQBAAAAB21fdmFsdWUACW6eAwAAAAAA
Cw==</Anchor></MaxAnchor><BatchCount>6</BatchCount><TablesMetadata><SyncTableMetadata><TableName>ArchiveJetasObjectType</TableName><SyncDirection>DownloadOnly</SyncDirection><LastSentAnchor /><LastReceivedAnchor><Anchor>AAEAAAD/////AQAAAAAAAAAEAQAAAAxTeXN0ZW0uSW50NjQBAAAAB21fdmFsdWUACUNDAwAAAAAA
Cw==</Anchor></LastReceivedAnchor></SyncTableMetadata><SyncTableMetadata><TableName>ArchiveJetasObjectColumn</TableName><SyncDirection>DownloadOnly</SyncDirection><LastSentAnchor /><LastReceivedAnchor><Anchor>AAEAAAD/////AQAAAAAAAAAEAQAAAAxTeXN0ZW0uSW50NjQBAAAAB21fdmFsdWUACUNDAwAAAAAA
Cw==</Anchor></LastReceivedAnchor></SyncTableMetadata><SyncTableMetadata><TableName>ArchiveDropDownListItem</TableName><SyncDirection>DownloadOnly</SyncDirection><LastSentAnchor /><LastReceivedAnchor><Anchor>AAEAAAD/////AQAAAAAAAAAEAQAAAAxTeXN0ZW0uSW50NjQBAAAAB21fdmFsdWUACUNDAwAAAAAA
Cw==</Anchor></LastReceivedAnchor></SyncTableMetadata><SyncTableMetadata><TableName>ArchiveJetasObject</TableName><SyncDirection>Bidirectional</SyncDirection><LastSentAnchor><Anchor>AQAAAAAAAAA=</Anchor></LastSentAnchor><LastReceivedAnchor><Anchor>AAEAAAD/////AQAAAAAAAAAEAQAAAAxTeXN0ZW0uSW50NjQBAAAAB21fdmFsdWUACUNDAwAAAAAA
Cw==</Anchor></LastReceivedAnchor></SyncTableMetadata><SyncTableMetadata><TableName>ArchiveJetasObjectData</TableName><SyncDirection>Bidirectional</SyncDirection><LastSentAnchor><Anchor>AQAAAAAAAAA=</Anchor></LastSentAnchor><LastReceivedAnchor><Anchor>AAEAAAD/////AQAAAAAAAAAEAQAAAAxTeXN0ZW0uSW50NjQBAAAAB21fdmFsdWUACUNDAwAAAAAA
Cw==</Anchor></LastReceivedAnchor></SyncTableMetadata><SyncTableMetadata><TableName>ArchiveJetasObject2Task</TableName><SyncDirection>Bidirectional</SyncDirection><LastSentAnchor><Anchor>AQAAAAAAAAA=</Anchor></LastSentAnchor><LastReceivedAnchor><Anchor>AAEAAAD/////AQAAAAAAAAAEAQAAAAxTeXN0ZW0uSW50NjQBAAAAB21fdmFsdWUACUNDAwAAAAAA
Cw==</Anchor></LastReceivedAnchor></SyncTableMetadata><SyncTableMetadata><TableName>ArchiveGroup</TableName><SyncDirection>DownloadOnly</SyncDirection><LastSentAnchor /><LastReceivedAnchor><Anchor>AAEAAAD/////AQAAAAAAAAAEAQAAAAxTeXN0ZW0uSW50NjQBAAAAB21fdmFsdWUACUNDAwAAAAAA
Cw==</Anchor></LastReceivedAnchor></SyncTableMetadata><SyncTableMetadata><TableName>MeterProperty</TableName><SyncDirection>DownloadOnly</SyncDirection><LastSentAnchor /><LastReceivedAnchor><Anchor>AAEAAAD/////AQAAAAAAAAAEAQAAAAxTeXN0ZW0uSW50NjQBAAAAB21fdmFsdWUACUNDAwAAAAAA
Cw==</Anchor></LastReceivedAnchor></SyncTableMetadata><SyncTableMetadata><TableName>WorkOrder</TableName><SyncDirection>Bidirectional</SyncDirection><LastSentAnchor><Anchor>AQAAAAAAAAA=</Anchor></LastSentAnchor><LastReceivedAnchor><Anchor>AAEAAAD/////AQAAAAAAAAAEAQAAAAxTeXN0ZW0uSW50NjQBAAAAB21fdmFsdWUACUNDAwAAAAAA
Cw==</Anchor></LastReceivedAnchor></SyncTableMetadata><SyncTableMetadata><TableName>WorkOrderContent</TableName><SyncDirection>Bidirectional</SyncDirection><LastSentAnchor><Anchor>AQAAAAAAAAA=</Anchor></LastSentAnchor><LastReceivedAnchor><Anchor>AAEAAAD/////AQAAAAAAAAAEAQAAAAxTeXN0ZW0uSW50NjQBAAAAB21fdmFsdWUACUNDAwAAAAAA
Cw==</Anchor></LastReceivedAnchor></SyncTableMetadata><SyncTableMetadata><TableName>WorkOrderStatusChange</TableName><SyncDirection>Bidirectional</SyncDirection><LastSentAnchor><Anchor>AQAAAAAAAAA=</Anchor></LastSentAnchor><LastReceivedAnchor><Anchor>AAEAAAD/////AQAAAAAAAAAEAQAAAAxTeXN0ZW0uSW50NjQBAAAAB21fdmFsdWUACUNDAwAAAAAA
Cw==</Anchor></LastReceivedAnchor></SyncTableMetadata></TablesMetadata></groupMetadata>
GetChangesResponse:
<GetChangesResult><GroupProgress><GroupName>WorkOrderDepending</GroupName>
<TablesProgress><SyncTableProgress><TableName>ArchiveGroup</TableName><Inserts>0</Inserts><Updates>4</Updates><Deletes>0</Deletes><ChangesApplied>0</ChangesApplied><ChangesFailed>0</ChangesFailed><Conflicts/></SyncTableProgress>
<SyncTableProgress><TableName>ArchiveJetasObjectType</TableName><Inserts>0</Inserts><Updates>8</Updates><Deletes>0</Deletes><ChangesApplied>0</ChangesApplied><ChangesFailed>0</ChangesFailed><Conflicts/></SyncTableProgress>
<SyncTableProgress><TableName>ArchiveJetasObjectColumn</TableName><Inserts>0</Inserts><Updates>46</Updates><Deletes>0</Deletes><ChangesApplied>0</ChangesApplied><ChangesFailed>0</ChangesFailed><Conflicts/></SyncTableProgress>
<SyncTableProgress><TableName>ArchiveDropDownListItem</TableName><Inserts>0</Inserts><Updates>0</Updates><Deletes>0</Deletes><ChangesApplied>0</ChangesApplied><ChangesFailed>0</ChangesFailed><Conflicts/></SyncTableProgress>
<SyncTableProgress><TableName>ArchiveJetasObjectData</TableName><Inserts>0</Inserts><Updates>94</Updates><Deletes>0</Deletes><ChangesApplied>0</ChangesApplied><ChangesFailed>0</ChangesFailed><Conflicts/></SyncTableProgress>
<SyncTableProgress><TableName>ArchiveJetasObject</TableName><Inserts>0</Inserts><Updates>19</Updates><Deletes>0</Deletes><ChangesApplied>0</ChangesApplied><ChangesFailed>0</ChangesFailed><Conflicts/></SyncTableProgress>
<SyncTableProgress><TableName>ArchiveJetasObject2Task</TableName><Inserts>0</Inserts><Updates>19</Updates><Deletes>0</Deletes><ChangesApplied>0</ChangesApplied><ChangesFailed>0</ChangesFailed><Conflicts/></SyncTableProgress>
<SyncTableProgress><TableName>MeterProperty</TableName><Inserts>0</Inserts><Updates>0</Updates><Deletes>0</Deletes><ChangesApplied>0</ChangesApplied><ChangesFailed>0</ChangesFailed><Conflicts/></SyncTableProgress>
<SyncTableProgress><TableName>WorkOrder</TableName><Inserts>5</Inserts><Updates>0</Updates><Deletes>0</Deletes><ChangesApplied>0</ChangesApplied><ChangesFailed>0</ChangesFailed><Conflicts/></SyncTableProgress>
<SyncTableProgress><TableName>WorkOrderContent</TableName><Inserts>19</Inserts><Updates>0</Updates><Deletes>0</Deletes><ChangesApplied>0</ChangesApplied><ChangesFailed>0</ChangesFailed><Conflicts/></SyncTableProgress>
<SyncTableProgress><TableName>WorkOrderStatusChange</TableName><Inserts>0</Inserts><Updates>0</Updates><Deletes>0</Deletes><ChangesApplied>0</ChangesApplied><ChangesFailed>0</ChangesFailed><Conflicts/></SyncTableProgress>
</TablesProgress></GroupProgress><OriginatorId>0</OriginatorId><NewAnchor><Anchor>AAEAAAD/////AQAAAAAAAAAEAQAAAAxTeXN0ZW0uSW50NjQBAAAAB21fdmFsdWUACUlDAwAAAAAACw==</Anchor></NewAnchor><MaxAnchor><Anchor>AAEAAAD/////AQAAAAAAAAAEAQAAAAxTeXN0ZW0uSW50NjQBAAAAB21fdmFsdWUACW6eAwAAAAAACw==</Anchor></MaxAnchor><BatchCount>5</BatchCount>