none
Sync with Filters : Tracking table is updated, but not the base? RRS feed

  • Question

  • Hi All,

    This is my requirement. I have a table and I want some data to be synced with a table in remote database. I have used a filter. But the thing is, I can see in the stats changes are applied, but in my remote base table there are none. The remote tracking table is updated it seems. I am wondering why remote base table is not getting updated.

    Appreciate your help.

    Thanks. Happy Coding.

    Regards,

    Jaliya 


    Jaliya Udagedara(MCPD) http://www.jaliyaudagedara.blogspot.com

    Wednesday, February 13, 2013 7:31 AM

Answers

  • i think you can simply enable it in an app.config file.

    e.g.

    <configuration>
      <system.diagnostics>
        <switches>
          <!--  0-off, 1-error, 2-warn, 3-info, 4-verbose. -->
          <add name="SyncTracer" value="3" />
        </switches>
    
        <trace autoflush="true">
          <listeners>
            <add name="TestListener" type="System.Diagnostics.TextWriterTraceListener" initializeData="TraceSample.log"/>
          </listeners>
        </trace>
      </system.diagnostics>
    </configuration>
    
    

    Wednesday, February 13, 2013 8:05 AM
    Moderator

All replies

  • have you check your conflict resolution settings? check ApplyChangeFailed event if it fires during your sync.
    Wednesday, February 13, 2013 7:40 AM
    Moderator
  • Hi JuntT,

    It's always great see you replying. :)

    Actually my sync is running as a windows service. It's bit of hard it debug. Since I have enabled tracing I have put "SyncTracer.Verbose(e.Error)". It should work right? 


    Jaliya Udagedara(MCPD) http://www.jaliyaudagedara.blogspot.com

    Wednesday, February 13, 2013 7:57 AM
  • i think you can simply enable it in an app.config file.

    e.g.

    <configuration>
      <system.diagnostics>
        <switches>
          <!--  0-off, 1-error, 2-warn, 3-info, 4-verbose. -->
          <add name="SyncTracer" value="3" />
        </switches>
    
        <trace autoflush="true">
          <listeners>
            <add name="TestListener" type="System.Diagnostics.TextWriterTraceListener" initializeData="TraceSample.log"/>
          </listeners>
        </trace>
      </system.diagnostics>
    </configuration>
    
    

    Wednesday, February 13, 2013 8:05 AM
    Moderator
  • Hi JuneT,

    I am getting a Apply Change Failed Event and it's a LocalDeleteRemoteUpdate. Any idea on how to handle these type of things?


    Jaliya Udagedara(MCPD) http://www.jaliyaudagedara.blogspot.com

    Wednesday, February 13, 2013 8:59 AM
  • You have to specify how to handle the conflict; client wins, server wins, etc...

    just lookup conflict resolution or how to handle conflicts in the docs...

    Wednesday, February 13, 2013 9:25 AM
    Moderator
  • Thanks JuneT, Will do that. Really appreciate your help.

    Thanks again.

    Happy Coding.

    Regards,

    Jaliya


    Jaliya Udagedara(MCPD) http://www.jaliyaudagedara.blogspot.com

    Wednesday, February 13, 2013 9:57 AM