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

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

Answer 1

have you check your conflict resolution settings? check ApplyChangeFailed event if it fires during your sync.

Answer 2

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

Answer 3

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>

Answer 4

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

Answer 5

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...

Answer 6

Thanks JuneT, Will do that. Really appreciate your help.

Thanks again.

Happy Coding.

Regards,

Jaliya

---

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