locked
0 changes selected on Server even though there are changes present RRS feed

  • Question

  • Hi,

    I am using syncFx2.0 and SqlCeSyncProvider, SqlSyncProvider providers.

    When I try to sync a downloadonly syncgroup between CE and SqlServer, I get 0 selected changes on server. However, when I tracked the queries via sql profiler I see that _selectchanges stored proc is run. When I run that procedure seperately on Server, I get 17 changes. So I don't understand why these changes are not being returned to CE. My expected behaviour is to get 17 changes from server.

    Does anyone else has observered similar thing or know what might be going on here?

    Thanks

    Sumit

    Friday, May 14, 2010 8:43 PM

Answers

  • Hi,

    You haven't enable Verbose (level = 4) in your tracing config. Currently, I only see Info level traces. With Verbose level of tracing, all SQL commands will be logged too. Please get the tracing logs in verbose level and share to me again. Based on your current tracing logs, no change is found in the SQL Server endpoint. Did you ever sync the Sql Sync with Sql Ce table before? You said that you can find 17 rows in the Sql Server "Trade" table by executing the _selectchanges SP, can you show me the query with the exact input parameters? In Sync Framework change enumeration, if the knowledge in Sql Ce side contains these changes, they will not be synced too.

    Thanks,
    Dong


    This posting is provided AS IS with no warranties, and confers no rights.
    Monday, May 17, 2010 7:15 PM

All replies

  • Hi,

    Please enable tracing with verbose level (http://msdn.microsoft.com/en-us/library/cc807160.aspx) to check if no change is found in Sql Server side, or the changes are not successfully applied on CE store.

    If you cannot find anything wrong in the tracing logs, please share it to us. If you can get the 17 changes by running the exact same stored procedure with same set of parameters, server provider should be able to enumerate them.

    Thanks,
    Dong


    This posting is provided AS IS with no warranties, and confers no rights.
    Friday, May 14, 2010 11:19 PM
  • Hi Dong, I have tried running the sync tracer, but still I see that 0 changes were selected on server. Following is the snippet from tracer when this syncgroup was running. Based on this do you find any problem in the my settings? Thanks Sumit INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:095, BeginSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:095, BeginSession() called on Provider SqlCeSyncProvider, Microsoft.Synchronization.Data.SqlServerCe, Version=3.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:158, ----- Checking for Outdated Peer ----- INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:158, Destination is not outdated INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:158, --- End Checking for Outdated Peer --- INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:158, INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:158, ----- Enumerating Changes for Scope "Trade" ----- INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:173, Source Scope Id: 18fcc913b0b648dba7356332f91df4f0 INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:173, Destination Scope Id: 5813e6eebbd9405b905b41443281109a INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:173, Change Tracking Model: Decoupled INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:173, ----- Table "Trade" ----- INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, Inserts: 0 INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, Deletes: 0 INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, Updates: 0 INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, Changes Enumerated: 0 INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, --- End Table "Trade" --- INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, --- End Enumerating Changes for Scope "Trade" --- INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, Committing transaction INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, ----- Applying Changes for Scope "Trade" ----- INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, Source Scope Id: 18fcc913b0b648dba7356332f91df4f0 INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, Destination Scope Id: 5813e6eebbd9405b905b41443281109a INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, ----- Deletes for Table "Trade" ----- INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, 0 Deletes Applied INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, --- End Deletes for Table "Trade" --- INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, ----- Inserts for Table "Trade" ----- INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, 0 Inserts Applied INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, --- End Inserts for Table "Trade" --- INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, ----- Updates for Table "Trade" ----- INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, 0 Updates Applied INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, --- End Updates for Table "Trade" --- INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, Committing transaction INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:376, --- End Applying Changes for Scope "Trade" --- INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:376, INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:376, EndSession() called on Provider SqlCeSyncProvider, Microsoft.Synchronization.Data.SqlServerCe, Version=3.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 INFO , BE.Client.vshost, 17, 05/17/2010 14:09:50:376, EndSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    Monday, May 17, 2010 2:20 PM
  • Hi,

    Just posting the log again, because in previous post it lost the formatting

    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:095,  BeginSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:095,  BeginSession() called on Provider SqlCeSyncProvider, Microsoft.Synchronization.Data.SqlServerCe, Version=3.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:158, ----- Checking for Outdated Peer -----
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:158,  Destination is not outdated
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:158, --- End Checking for Outdated Peer ---
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:158, 
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:158, ----- Enumerating Changes for Scope "Trade" -----
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:173,     Source Scope Id: 18fcc913b0b648dba7356332f91df4f0
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:173,   Destination Scope Id: 5813e6eebbd9405b905b41443281109a
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:173,  Change Tracking Model: Decoupled
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:173,  ----- Table "Trade" -----
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:251,    Inserts: 0
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:251,    Deletes: 0
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:251,    Updates: 0
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:251,    Changes Enumerated: 0
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:251,  --- End Table "Trade" ---
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, 
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, --- End Enumerating Changes for Scope "Trade" ---
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, 
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, Committing transaction
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, ----- Applying Changes for Scope "Trade" -----
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:251,     Source Scope Id: 18fcc913b0b648dba7356332f91df4f0
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:251,  Destination Scope Id: 5813e6eebbd9405b905b41443281109a
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:251, 
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:314,  ----- Deletes for Table "Trade" -----
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:314,    0 Deletes Applied
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:314,  --- End Deletes for Table "Trade" ---
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, 
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:314,  ----- Inserts for Table "Trade" -----
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:314,    0 Inserts Applied
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:314,  --- End Inserts for Table "Trade" ---
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, 
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:314,  ----- Updates for Table "Trade" -----
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:314,    0 Updates Applied
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:314,  --- End Updates for Table "Trade" ---
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, 
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:314, Committing transaction
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:376, --- End Applying Changes for Scope "Trade" ---
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:376, 
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:376,  EndSession() called on Provider SqlCeSyncProvider, Microsoft.Synchronization.Data.SqlServerCe, Version=3.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO  , BE.Client.vshost, 17, 05/17/2010 14:09:50:376,  EndSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91

    Thanks

    Sumit

    Monday, May 17, 2010 3:56 PM
  • Hi,

    You haven't enable Verbose (level = 4) in your tracing config. Currently, I only see Info level traces. With Verbose level of tracing, all SQL commands will be logged too. Please get the tracing logs in verbose level and share to me again. Based on your current tracing logs, no change is found in the SQL Server endpoint. Did you ever sync the Sql Sync with Sql Ce table before? You said that you can find 17 rows in the Sql Server "Trade" table by executing the _selectchanges SP, can you show me the query with the exact input parameters? In Sync Framework change enumeration, if the knowledge in Sql Ce side contains these changes, they will not be synced too.

    Thanks,
    Dong


    This posting is provided AS IS with no warranties, and confers no rights.
    Monday, May 17, 2010 7:15 PM
  • Hi Dong,

    Sorry, I could not post the verbose trace. I was trying to reproduce the problem, but it seems that now its working everytime I try it.

    I will ask further questions if I see the problem again.

    Thanks for your help.

     

    - Sumit

     

    Thursday, May 20, 2010 3:01 PM