Sync proccess is stuck when syncing table with PK which contains 2 columns RRS feed

  • Question

  • I am using sync framework to sync sql 2016 to 2014
    I have a connecting table which contains only 2 columns:
    Table A: ID, Name
    Table B: ID, Name
    Table C: A_ID, B_ID

    When i try to sync table C it goes into infinite loop and in the profiler i see this query running non stop:
    exec [C_selectrow] @P_1=1,@P_2=1,@sync_scope_local_id=1,@sync_scope_restore_count=0

    I found a workaround and added a dummy column with no data to table C (nvarchar(1) column) which solved the problem

    • Edited by Uri Zeira Thursday, October 20, 2016 10:44 AM
    Thursday, October 20, 2016 10:18 AM