Unexpected end when deserializing array

[damien-c-d]

Occasionally during the sync process using SqlSyncChangeTrackingProvider I encounter the error:

Newtonsoft.Json.JsonSerializationException: 'Unexpected end when deserializing array. Path 't[0].c[69].t', line 1, position 2048.'

It is happening in LocalJsonSerializer.cs at the breakpoint here:

[Mimetis]

are you able to reproduce it ?

[damien-c-d]

I believe it had something to with differences in Collation. One database was using Latin1_General_CI_AS and the other was using SQL_Latin1_General_CP1_CI_AS. We had to use sqlpackage to get around this and migrate from one to the other.

We are now experiencing a different error which I'll open another issue for.