Solution to the problem RRS feed

  • Question

  • The problem is the timestamp tracking tables and stored procedures updatematadata, insertmetadata,and insert trigger for each table:

    1. You should to install the hotfix from Microsoft, which updates the Sync Framework 2.1 API.

    2. You should to change the trigger on each table, the@@DBTS+ 1 is replaced by CAST (@@DBTS as bigint)+1, the same replacement is done in stored procedures,updatemetadata,insertmetada of each table.

    It's solves the after problems ,but it's not solves above records.To find records that generate conflict we search for tracking tables, filtering by columns, scope_update_peer_timestamp ,local_update_peer_timestamp, scope_create_peer_timestamp, local_create_peer_tiemsatamp, if it's negative, you should update its value through CAST (@@DBTSasbigint) + 1

    Wednesday, November 26, 2014 2:06 PM

All replies

  • and what exact/specific problem are you running into that requires the above changes?
    Monday, December 1, 2014 6:47 AM