I have a table marked as BiDirectional. After adding a new record, the upload piece of bidirectional works because the record is on the server. However, the download piece throws an error because of a PK violation. Basically, sync services is trying to download
the record that I just entered.
I did overide the generated Insert and Update statements to exclude the CreationDate column.
Its almost like the @sync_new_received_anchor = @@DBTS is not being set properly.
On the generated insert trigger the CreationDate is set to @@DBTS + 1 so I would think that the creation date would be greater than the @sync_new_received_anchor thus not showing up in the SelectIncrementalInsertsCommand
WHERE ([CreationDate] > @sync_last_received_anchor
AND [CreationDate] <= @sync_new_received_anchor)";
Any ideas?
