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

• Question

• 

  

  0

  Sign in to vote

  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