locked
Cannot enumerate changes at the DbServerSyncProvider for table 'service' in synchronization group 'service'. RRS feed

  • Question

  • Cannot enumerate changes at the DbServerSyncProvider for table 'service' in synchronization group 'service'.

    I got the above exception when I tried to sync for first time only one table 'service' between sql server 2005 and sql server express 2005

    Thanks, Bharathi
    • Moved by Max Wang_1983 Thursday, April 21, 2011 11:03 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Wednesday, October 21, 2009 6:37 AM

Answers

  • Hi -

    This is a general exception when change enumeration fails. You need to look at the inner exception and see the more specific reason as to why this is failing. You should also use the SQL Profiler and figure out which command this is failing on - you can then manually try to execute that command and see why it is failing.

    Thanks
    Deepa
    Deepa ( Microsoft Sync Framework)
    • Marked as answer by bharathi_m Thursday, October 22, 2009 10:50 AM
    Wednesday, October 21, 2009 11:05 PM
    Answerer

All replies

  • Hi -

    This is a general exception when change enumeration fails. You need to look at the inner exception and see the more specific reason as to why this is failing. You should also use the SQL Profiler and figure out which command this is failing on - you can then manually try to execute that command and see why it is failing.

    Thanks
    Deepa
    Deepa ( Microsoft Sync Framework)
    • Marked as answer by bharathi_m Thursday, October 22, 2009 10:50 AM
    Wednesday, October 21, 2009 11:05 PM
    Answerer
  • Hi -

    This is a general exception when change enumeration fails. You need to look at the inner exception and see the more specific reason as to why this is failing. You should also use the SQL Profiler and figure out which command this is failing on - you can then manually try to execute that command and see why it is failing.

    Thanks
    Deepa
    Deepa ( Microsoft Sync Framework)
    Deepa,

    yes.you are correct. I had given wrong database for both sides in  connectionstring.

    Also, do you have any samples which contain serversyncprovider and clientsyncprovider as separate classes using WCF(not for devices,not for sql server change tracking,not for VS2008 cache)


    Thanks, Bharathi
    Thursday, October 22, 2009 10:50 AM