locked
Changes to the server remain in pending state RRS feed

  • Question

  • Hi,

     

    I am able to sync up changes from Server to Client, but not the other way around.

     

    The Web service on the Server side recevies a call to ApplyChanges() function with the correct meta data in GroupMetaData and correct data in the Dataset parameter. however the call to DbServerSyncProvider returns immediately with teh SyncContext.GroupProgress.TotalChangesPending = 3 .

     

    Where should i be looking to debug into this ?

     

    thanks

    abhinav

    • Moved by Max Wang_1983 Friday, April 22, 2011 8:43 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Tuesday, January 8, 2008 3:04 PM

Answers

  • for such kind of issues, I would suggest:

    1. check the update/insert/delete commands at the sync adapter to see if they are correct

    2. hook up with the applyingChanges event on server to see if the the desired data is in the dataset or not ( seems you already did that ).

    3. hook up with the applyCHangeFailed Event to see if there are any failures

    4. use sql profiler to trace down th extact query and data to run on the sql server

     

    hope this helps.

     

    thanks

    yunwen

    Sunday, February 10, 2008 3:19 AM
    Moderator